Suppose that a data warehouse consists of the four dimensions, date, spectator, location, and game, and...

Transcribed Image Text:

Suppose that a data warehouse consists of the four dimensions, date, spectator, location, and game, and the two measures, count and charge, where charge is the fare that a spectator pays when watching a game on a given date. Spectators may be students, adults, or seniors, with each category having its own charge rate. Draw a SNOWFLAKE SCHEMA MODEL for the data warehouse. Consider primary key and foreign key along with important attributes for the dimensions. Underline the primary key column(s) in each table and italicize the foreign key column(s) in each table. Note: Use Microsoft Access/Word / neatly drawing with hands. Marks (7) Q2. A data warehouse can be modeled by either a star schema or a snowflake schema. Write your opinion of which model might be more empirically useful and state the reasons behind your answer. Marks (3) Suppose that a data warehouse consists of the four dimensions, date, spectator, location, and game, and the two measures, count and charge, where charge is the fare that a spectator pays when watching a game on a given date. Spectators may be students, adults, or seniors, with each category having its own charge rate. Draw a SNOWFLAKE SCHEMA MODEL for the data warehouse. Consider primary key and foreign key along with important attributes for the dimensions. Underline the primary key column(s) in each table and italicize the foreign key column(s) in each table. Note: Use Microsoft Access/Word / neatly drawing with hands. Marks (7) Q2. A data warehouse can be modeled by either a star schema or a snowflake schema. Write your opinion of which model might be more empirically useful and state the reasons behind your answer. Marks (3)

Answer rating: 100% (QA)

1 Consider the star schema diagram below Each Attribute corresponds to primary key The value of count and charge are calculated by aggregation of entr... View the full answer