You are given following enrollment information for June 2019 - Oct 2019 for education_r_us.com, an online university.
No answer yet for this question.
Ask a Tutor
Question:
You are given following enrollment information for June 2019 - Oct 2019 for education_r_us.com, an online university. (10 points)
campus/Month | June | July | Aug | Sep | Oct |
Campus 1 | 4590 | 3500 | 3400 | 4990 | 5250 |
Campus 2 | 332 | 311 | 321 | 340 | 398 |
Campus 3 | 612 | 666 | 664 | 620 | 554 |
Campus 4 | 445 | 411 | 434 | 480 | 500 |
Sample enrollment information about each campus for the month of June is shown below:
Campus/Department | Law | Business | Engineering | Arts |
Campus 1 | 1000 | 2590 | 1000 | 0 |
Campus 2 | 0 | 332 | 0 | 0 |
Campus 3 | 0 | 100 | 0 | 512 |
Campus 4 | 200 | 200 | 0 | 45 |
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
Related Book For
Investments
ISBN: 9781259271939
9th Canadian Edition
Authors: Zvi Bodie, Alex Kane, Alan Marcus, Lorne Switzer, Maureen Stapleton, Dana Boyko, Christine Panasian
Posted Date: