CS403 Database Management Systems Assignment#3 Solution

Second Normal Form

Student ID	Name
Vu001	Faizan
Vu001	Faizan
Vu002	Zafar
Vu003	Ahmad
Vu003	Ahmad
Vu003	Ahmad
Vu004	Fahad
Vu004	Fahad

Specialization semester	Semester start date	Semester end date
Fall 2009	05-07-09	31-12-09
Spring 2010	05-02-10	30-06-10
Spring 2010	05-02-10	30-06-10
Fall 2009	05-07-09	31-12-09
Spring 2010	05-02-10	30-06-10
Fall 2010	05-07-10	31-12-10
Fall 2010	05-07-10	31-12-10
Spring 2011	05-02-11	30-06-11

Specialization	Specialization supervisor
SE	Prof. Majid
AI	Prof. Saeed
AI	Prof. Saeed
SE	Prof. Majid
Networks	Prof. Wajid
AI	Prof. Saeed
SE	Prof. Majid
AI	Prof. Saeed

Third Normal Form

Specialization	Specialization semester	Semester start date	Semester end date
SE	Fall 2009	05-07-09	31-12-09
AI	Spring 2010	05-02-10	30-06-10
AI	Spring 2010	05-02-10	30-06-10
SE	Fall 2009	05-07-09	31-12-09
Networks	Spring 2010	05-02-10	30-06-10
AI	Fall 2010	05-07-10	31-12-10
SE	Fall 2010	05-07-10	31-12-10
AI	Spring 2011	05-02-11	30-06-11