Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started