Assignment No. 03 Semester Spring 2012 Data Warehousing-CS614

	Assignment No. 03 Semester Spring 2012 Data Warehousing-CS614		Total Marks: 15 Due Date: 04/06/2012
Objective: To learn and understand basic concept of Star Schema and SQL. Instructions: Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit (get zero marks) if: o        The assignment is submitted after due date. o        The submitted assignment does not open. o        The submitted assignment is in the format other than MS Word (doc). o        The assignment is copied (from other student or copy from handouts). o        Student ID is not mentioned in the assignment File or name of file is other than student ID. For any query about the assignment, contact at cs614@vu.edu.pk GOOD LUCK
Q: Write SQL statements to construct the “Star Schema” given on the next page? Guidelines are given below: Guidelines Use appropriate data types for the table attributes. Show the Primary/Foreign key constraints. Do not send the archived file (.rar etc). “Try to upload the assignment before BONUS day”