Data Warehousing-CS614 Assignment no 4 Spring 2012 Solution

Q: Physically design the given “Star Schema” in MS Access? Guidelines You can create the tables through design view or through SQL queries. Enter raw data in the tables. Each Dimension table should have 5 rows and fact table can have more than 5 rows.

• Use appropriate data types for the table attributes.







Only MS Access Database files will be accepted. Do not send the archived file (.rar etc).