Pages

Saturday, June 4, 2011

CS403 Assignment No. 3 Announced


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



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.

Is this blog is useful for you?

Powered by Blogger.