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.

Transcribed Image Text:

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