Q1: Find E-R Diagram of ABC Hospital, below.
a. You are required to translate diagram and write relations (tables) on behalf of E-R diagram provided. 3 Marks
b. You are required to Normalize tables obtained from part a of Question 1 to 3rd Normal Form. All tables / relations should be in 3rd normal form. (You are not required to show all procedure from 1NF to 3NF, only final relations in 3NF are required to write.) 12 Marks
Attribute Details:
P-ID: Patient ID
D-ID: Doctor ID
D-Phone: Doctor Phone
M-Code: Medicine Code
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
--
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://groups.google.com/group/vuZs/web/vuzs-basic-rules-for-posting-messages
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net
--
Please visit www.vuzs.net For Current & Old Papers, Quizzes, Assignments and study material.
--
You received this message because you are subscribed to the Google
Groups "vuZs" group.
--
To post a new message on this group, send email to vuZs@googlegroups.com
--
Message Posting Rules: http://groups.google.com/group/vuZs/web/vuzs-basic-rules-for-posting-messages
--
To unsubscribe from this group, send email to vuZs+unsubscribe@googlegroups.com
--
To join this group Send blank email from your virtual university email address to
vuZs+subscribe@googlegroups.com
or visit
http://groups.google.com/group/vuZs/subscribe
---
For more information Contact vuZs Manager at info@vuzs.net
No comments:
Post a Comment