Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments

Authors: Zvi Bodie, Alex Kane, Alan Marcus, Lorne Switzer, Maureen Stapleton, Dana Boyko, Christine Panasian

9th Canadian Edition

1259271935, 9781259271939

More Books

Students also viewed these General Management questions