Sunday, 20 January 2013
|
Q: Physically design the given “Star Schema” in MS Access?
(Star
Schema is given on the next page)
Instructions
|
- Use appropriate data types for the table attributes.
- Primary-Foreign key Constraints (Referential Integrity) must be implemented.
- 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 (.zip/.rar etc).
|
|
|
|
