CS403 Database Management System Assignment No. 3 spring June 2011

[Vuhelper]

Assignment No. 3
Semester FALL 2011
Database Management System-CS403
Total Marks: 15

Due Date: June 09, 2011
Objective:

Instructions:
Please read the following instructions carefully before solving & submitting assignment:
Assignment should be in your own wordings not copied from internet, handouts or books.
It should be clear that your assignment will not get any credit (zero marks) if:

o The assignment is submitted after due date.
o The submitted assignment does not open or file corrupt.
o The assignment is copied (from other student or copy from handouts or internet).


For any query about the assignment, contact at cs403@vu.edu.pk

GOOD LUCK



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


** You are not required to change / update new attributes or entities in E-R Diagram, while writing relations in part a / part b.