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:

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

Answer rating: 100% (QA)

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