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 toshow all procedure from 1NF to 3NF, only final relations in 3NF are required to write.) 12 Marks
P-ID: Patient ID
D-ID: Doctor ID
D-Phone: Doctor Phone
M-Code: Medicine Code
** You are not required to change / update new attributes or entities in E-R Diagram, while writing relations in part a / part b.
+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)
+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)+ Click Here to Search (Looking For something at vustudents.ning.com?) + Click Here To Join (Our facebook study Group)
Incomplete and confuseable solution ...........................
Material to make 3NF
One More idea Solution
See the attached file for CS403 Assignment#03 Idea solution spring 2011