CS614 Data Warehousing Assignment No. 01 spring April 2012

[Vuhelper]

[COLOR="Red"] Assignment No. 01
Semester Spring 2012
Data Warehousing-CS614
Total Marks: 15
[B]
Due Date: 16/04/2012[/COLOR]



Q: Normalize the below table up to 3rd normal form.

Read the Instructions (given on the next page) carefully before solving the assignment.



Student-ID Student-Specialization Student-Name Specialization- Semester Semester
Start-Date Semester
End-Date Specialization
Supervisor
Bc00001
SE
AI
Graphics Ali
F08
Sp09
F09 15-07-08 21-12-08 Prof Khalid
15-02-09 25-06-09 Prof Ashraf
15-07-09 21-12-09 Prof Shaw
Bc00002 AI Safdar Sp09 15-02-09 25-06-09 Prof Ashraf
Bc00003
SE
Graphics
AI Usman
F08
Sp09
F09 15-07-08 21-12-08 Prof Khalid
15-02-09 25-06-09 Prof Shaw
15-07-09 21-12-09 Prof Ashraf
Bc00004
SE
AI Naeem
F09
Sp010 15-07-09 21-12-09 Prof Khalid
15-02-10 25-07-10 Prof Ashraf
Bc00005 Graphics Naveed Sp010 15-02-10 25-07-10 Prof Shaw
Bc00006 AI Zaman Sp010 15-02-10 25-07-10 Prof Ashraf
Bc00007 SE Zeshan Sp010 15-02-10 25-07-10 Prof Khalid




Guidelines / Instructions

• Do not send the archived file (.rar etc).
• Understand the scenario on the basis of given data only.
• Give the reason, if relation cannot be converted in any Particular Normal Form (1st, 2nd, 3rd ).
• Don’t convert the relation in to 3rd normal form directly. Show each normal form of the relation.
• Show the data along with table structure.


“Try to upload the assignment before BONUS day”



[/B]