Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 408 Weeks Ago, 1 Day Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 30 Jan 2018 My Price 9.00

principles of normalization

Having mastered the principles of normalization described in Chapter 4, you recognize immediately that the star schema you developed for Millennium College (Problem and Exercise 3) is not in third normal form. Using these principles, convert the star schema to a snowflake schema. What impact (if any) does this have on the size of the fact table for this problem?

 

Problem and Exercise 3

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.

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?

 

Answers

Maurice Tutor
(5)
Status NEW Posted 30 Jan 2018 12:01 AM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)