Question: Millennium College (see Problem and Exercise 9-28) now wants to include new data about course sections: the department offering the course, the academic unit to

Millennium College (see Problem and Exercise 9-28) now wants to include new data about course sections: the department offering the course, the academic unit to which the department reports, and the budget unit to which the department is assigned. Change your answer to Problem and Exercise 9-28 to accommodate these new data requirements. Explain why you implemented the changes in the star schema the way you did.

CourseSection Professor Student Period Attributes: CourselD, Section Number, CourseName, Units, RoomID, and

CourseSection Professor Student Period Attributes: CourselD, Section Number, CourseName, Units, RoomID, and RoomCapacity. During a given semester, the college offers an average of 500 course sections. Attributes: ProfID, ProfName, Title, DepartmentID, and DepartmentName. There are typically 200 professors at Millennium at any given time. Attributes: StudentID, StudentName, and Major. Each course section has an average of 40 students, and students typically take five courses per period. Attributes: SemesterID and Year. The database will contain data for 30 periods (a total of 10 years).

Step by Step Solution

★★★★★

3.40 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solution a Dimentional Table in star schemas will be CourseSection Professor Student P... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Bells company had the following transactions in the month of May. May 2. Dee Bell transferred her personal car valued at $8,000 into the business. 10. Did $4,000 of work for a customer on account....

Millennium College wants you to help design a star schema to record grades for courses completed by students. There are four dimension tables, with attributes as follows: CourseSection..Attributes:...

Is a star schema a relational data model? Why or why not?

You are to construct a star schema for Simplified Automobile Insurance Company (see Kimball, 1996b, for a more realistic example). The relevant dimensions, dimension attributes, and dimension sizes...

Visit www.teradatauniversitynetwork.comand download the dimensional modeling tool located under the downloadable software section. Use this tool to draw your answers to Problems and Exercises 9-28,...

Millennium College wants you to help design a star schema to record grades for courses completed by students. There are four dimension tables, with attributes as follows: The only fact that is to be...

Millennium College offers several courses in different subject ( Major ) areas. Courses are managed by professors who are employed in different departments. The college records the course details,...

A taxpayer, a single individual, owns and operates an auto supply store. for the year, her taxable income is $70,000. in addition, she is entitled to a $1,000 tax credit. What is her tax liabilty for...

Wedig Diagnostics manufactures two laser photometers that are used in preparing DNA tests. The U. S. model is designed for use in the United States and the EU model is designed to meet the...

The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for the next year by developing a master budget by quarters. Griltons balance...

Andreea Ltd. manufactures t-shirts, which sell at 15 each. Table shows the sales and total costs for the period July 2020 to December 2020. Monthly fixed costs have been the same each month and it is...

The following figures relate to two companies: Particulars Sales Variable Costs Contribution Fixed Costs EBIT Interest PBT X Ltd. (Rs in Lakh) Y Ltd. (Rs. in Lakh) 100 200 40 60 60 30 30 10 20 You...

A linear system satisfies the properties of superposition and homogeneity. True or False

H,(2) Fourier Series (FS) is one of the design method of FIR filters. It can be summarized as follows: a) Sketch the ideal frequency response required H, (2). -2c Where, i denotes of ideal. b) Find...

In the Ethiopian Metal works company all disbursements for amounts over Birr 50 are made by cheque. Each cheque on general cash requires the signature of Ato Samuel, Treasurer, plus counter signature...

In your examination of a medium sized restaurant you observe that all customers pay their cheque to a single cashier, who also prepares and makes daily banking deposits. she submits a copy of the...

On Matlab, it is required to solve the following problem Consider the feedback system of Figure P1.46. Assume that y[n] = 0 for n

Determine whether the given relation is an equivalent relation on the set of all people a. (x, y), | x and y have the same first name} b. { x, y), | x and y have the same parents} c. { x, y), | x is...

Callaway College (see Problem 11-35) would like to investigate the effect of adding the age of the student to the regression model. The table in Problem 11-35 includes the ages of the original 12...

Newark College (see Problem 16.40) would like to include seasonality in its GPA forecasting model. The average GPA of the study body for each year was broken down into the average GPA by semester...

9-28. Millennium College wants you to help design a star schema to record grades for courses completed by students. There are four dimension tables, with attributes as follows: CourseSection...

Screen shot the model in SQL with all primary and foreign keys showing please. Individual Assignment -Logical Database Design Problem 4-32: Points: 10 The figure below shows a class list for...

please help me with matlap assighment i need page 3 problem 4 only #3&4 thanks Write a single live script with a proper header with your name, class, date and assignment. Create section breaks for...

QUESTION 1. To keep track of students and majors offered by different schools, Millennium College, a new college on the East coast, uses the table structure shown below. Assuming that the sample data...