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:

• The assignment is submitted after due date.
• The submitted assignment does not open or file corrupt.
• 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.

 

1. You are required to translate diagram and write relations (tables) on behalf of E-R diagram provided. 3 Marks
2. You are required to Normalize tables obtained from part a of Question 1 to 3^rd Normal Form. All tables / relations should be in 3^rd 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.