CS614 Assignment no 3 Fall 2012

To learn and understand the Physical implementation of Star Schema.

Instructions:

Please read the following instructions carefully before solving & submitting the assignment:

It should be clear that your assignment will not get any credit (get zero marks) if:

• The assignment is submitted after due date.
• The submitted assignment does not open.
• The submitted assignment is in the format other than MS Access Database (.mdb or accdb).
• The assignment is copied from other student.

For any query about the assignment, contact at cs614@vu.edu.pk

GOOD LUCK

(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).

“Try to upload the assignment before BONUS day”