Course Offerings

1
Course Offerings

• Dimensional Model for the Course Offerings
  Database

2
Dimensional Model

• Analyze courses offered by different instructors
  to understand enrollment trends and adjust loads
  for potential classes.
• Section Offered Each Semester
• Dimension
• Section-Fact
• Course
• Instructor
• Room
• Date
• Fact
• Capacity
• Enrollment

3
Dimensional Diagram
SECTION-FACT FactID (pk) CourseKey (fk) DateKey
(fk) InstructorKey (fk) RoomKey
(fk) Enrollment PotentialSize RoomCapacity TotalCr
editHours SectionNumber LabNumber Monday? Tuesday?
Wednesday? Thursday? Friday? StartTime EndTime
COURSE CourseKey CourseNumber CourseDescription Cr
editHours
INSTRUCTOR InstructorKey InstructorID InstructorFi
rst InstructorLast
ROOM RoomKey BuildingAbbrev BuildingName RoomNumbe
r Capacity
DATE DateKey Year Semester