The goal of this assignment is to create a star schema for a data warehouse. The data warehouse is for the fictitious college used in many of the examples during this course. Analysts at the college are trying to detect trends in registrations in courses over different terms. A registration is one student registering for one course. They want to know if registrations for specific courses are going up, down, or staying the same over different terms and whether this is different at the different college campuses. They also want to know if registration trends are different for female students compared to male students. Here is the schema for the operational database.
- another Post
- another Post
- Create the fact table. Include all appropriate columns.
W Cours eNumCours eNameDescriptionCreditsLabFee ‘1? TermIDTermNameTerm‘i‘earStartDateEndD-ate ‘fl’ CampusIDCampusNameAddress City State ZipCampusPresident TI’ SectionNumCourseNumProfessorNumTermStartTimeEndTimeCampusRoomIsMonIsTuesIsWedIsThurIsFri Registration “I? SectionNumI]? StudentNumGrade Professor ‘fl’ EmployeeNumDepartm entNumMentorChairD’i‘ficeNumber Student W StudentNumLastNameFirstNameAddressCityStateZipAdmittedGenderTransferCreditsSSN Department ‘1? DepartmentNumDescription Cost Center