You are given following enrollment information for June 2019 – Oct…
Question Answered step-by-step You are given following enrollment information for June 2019 – Oct… You are given following enrollment information for June 2019 – Oct 2019 for education_r_us.com, an online university. (10 points) campus/MonthJuneJulyAugSepOctCampus 145903500340049905250Campus 2332311321340398Campus 3612666664620554Campus 4445411434480500 Sample enrollment information about each campus for the month of June is shown below: Campus/DepartmentLawBusinessEngineeringArtsCampus 11000259010000Campus 2033200Campus 301000512Campus 4200200045 a. Education_r_us would like to develop a data warehouse that will provide total enrollment over time for each department and campus. Draw the star schema for Education_r_us. Clearly identify fact table, dimension tables, PK and FK. b. Describe what a ROW of the fact table represents Engineering & Technology Industrial Engineering Operations Management INSS 651 Share QuestionEmailCopy link Comments (0)
