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.
Incomplete and confuseable solution ...........................
Material to make 3NF
One More idea Solution
See the attached file for CS403 Assignment#03 Idea solution spring 2011