CS403 Database Management System Assignment No. 3 spring June 2011

[Vuhelper]

View more random threads:

• MCM401 Fundamentals of Public Relations Assignment No.1...
• Assignment No. 2 Fall 2012 Computer Networks – CS610
• CS201 assignment no 4 solution fall 2010 on 20/01/2011
• cs403 assginment no 2 data base management spring 2011 idea...
• CS304 Object Oriented Programming Assignment No.2 Fall...
• CS504 - Software Engineering - I assignment no 5 idea...
• CS615 Software Project Management Assignment No. 1 Solution...
• cs301 assignment solution 4/1/2011
• eng201 assignment no 5 solution fall 2010
• CS506 Web Design and Development Assignment No. 04 SEMESTER...

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

Sponsored Links

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.

[sohail_gill]

plz solved it

[Xpert]

okkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk

[hashir]

please upload the idea solution of assignment cs403

[Xpert]

kartay han bhai

[Vuhelper]

only idea solution

[Xpert]

that's good to see a idea solution

[ZED49]

Thanks for uploading idea solution

[Vuhelper]

hmmmmm theakkkkkkkk

[saira muneer]

thnxxxxxxxxxxxxxxxxx