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 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).