Department of Is, College of Computer Science Semester II Data ware housing and data mining (2231SM-3) Assignment # 01 - Data Warehousing Date of issue: 16.2.2021 Submission Due: 18.3.2021 Marks 5 Instructions: Total Marks - 5 ( 10 Marks will be scaled to 5 Marks) Use the Assignment Template is attached for submitting your answer. The assignment should be well formatted (font, text color, etc.). It should be submitted via blackboard in separate word/pdf file through Safe Assignment. For Plagiarism (Copying Assignment Answer from the Internet completely or from others), Marks will be given ZERO. For late submission, there will be a penalty or cut-off marks Q1. 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 ) Department of Is, College of Computer Science Semester II Data ware housing and data mining (2231SM-3) Assignment # 01 - Data Warehousing Date of issue: 16.2.2021 Submission Due: 18.3.2021 Marks 5 Instructions: Total Marks - 5 ( 10 Marks will be scaled to 5 Marks) Use the Assignment Template is attached for submitting your answer. The assignment should be well formatted (font, text color, etc.). It should be submitted via blackboard in separate word/pdf file through Safe Assignment. For Plagiarism (Copying Assignment Answer from the Internet completely or from others), Marks will be given ZERO. For late submission, there will be a penalty or cut-off marks Q1. 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 )
