Millennium College wants you to help design a star schema to record grades for courses completed by students. There are four dimension tables, with attributes as follows:

The only fact that is to be recorded in the fact table is CourseGrade.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

a. Design a star schema for this problem. See Figure 9-10 for the format you should follow.

b. Estimate the number of rows in the fact table, using the assumptions stated previously.

c. Estimate the total size of the fact table (in bytes), assuming that each field has an average of 5 bytes.

d. If you didn’t want to or didn’t have to stick with a strict star schema for this data mart, how would you change the design? Why? e. Various characteristics of sections, professors, and students change over time. How do you propose designing the star schema to allow for these changes? Why?