loading...

CS614 Data Warehousing Assignment 3 Solution Fall 2012

Q: Physically design the given “Star Schema” in MS Access? (Star Schema is given on the next page)

Instructions

• SQL Queries are not required.
• Use appropriate data types for the table attributes.
• Enter raw data in the tables. Each table should have 2 rows.
• There should not be any “null value” in any table.
• Only MS Access Database files will be accepted.
• Do not send the archived file (.rar etc).

Answer: Download the previous semester Assignment Solution


Spring2012_CS614_4_SOL

DOWNLOAD SOLUTION HERE
loading...