CS712 Distributed DBMS Assignment No. 1 MS (CS) Fall 2014 Last Date 5th December 2014

[Vuhelper]

CS712 Distributed DBMS Assignment No. 1 MS (CS), Fall 2014 Due Date: Dec 05, 2014


assignment.
Cheating from any source will result in zero marks in the assignment.
Any student found cheating in any two of the assignments submitted during the course will be awarded
"F" grade in the course.
· No assignment after due date will be accepted.Virtual University of Pakistan
Fall 14
2
Answer the following questions in your own words. Plagiarism will be checked for
each question. Marks will be awarded on the basis of answer and plagiarism report.
Question 1 (6 + 10 = 16 Marks)
The following table gives details of patient doctor appointments.
staff ID Doctor Name Patient No Patient Name Appointment Date Time
S112 Dr. M.
Khushnood
P10112 Iqbal Kasim 22-Sep-14 11:00AM
S123 Dr. Waqar
Aziz
P10115 Jamil Ahmed 22-Sep-14 11:00AM
S112 Dr. M.
Khushnood
P10123 Usman
Khalid
22-Sep-14 03:00PM
S211 Dr. Imran
Yousaf
P10214 Bilal Hafeez 22-Sep-14 08:00PM
a. Discuss all possible anomalies that may occur by giving examples from the table.
b. Normalize the above table up to 3rd normal form.
Question 2 (10 Marks)
Draw ER Diagram using the following information:
A company needs to store information about its employees and departments.
Employees are identified by employId, other attributes are employ name, salary
and contact number. Departments are identified by departNo, other attributes are
department name and budget. In addition, employee family information (spouse,
children) is also stored; only name and age are stored regarding family
information.
Employees work in departments; each department is managed by an
employee; a child must be identified uniquely by name when the parent is known.
Question 3
(8 + 8 + 8 = 24 marks)
Read the paper entitled “What Goes Around Comes Around” and answer the following
questions.
a. What were the main motivations of Ted Codd’s proposal of relational model?
b. What were the proposals (proposed additions) of Zaniolo?
c. Briefly discuss the basic philosophy of semantic data model.