Cs614 Assignment no 1 Spring 2012 Idea Solution

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