Department of Computer Science, Virtual
University of Pakistan
CS712: Distributed Database Management System
Assignment 1 Fall 2008 Maximum Points: 100
Submission Date: Sunday, 16th November 2008
Instructions
The purpose of this assignment is to give you hands on practice. It is
expected that students will solve the assignments themselves. Following
rules will apply during the evaluation of assignment.
Cheating from any source will result in zero marks in the
assignment.
Any student found cheating in any of the two assignments submitted
will be awarded "F" grade in the course.
No assignment after due date will be accepted
Question # 1 (35 Points)
Following is a list of different database applications. Which of the, centralized or
distributed, database architecture would you recommend for each and why?
a- The information system of a particular hospital in a city
b- The information system of a Bank (like HBL,MCB etc)
NOTE :( justify your answer with example)
Question # 2 (30 Points)
a) Differentiate between referential integrity constraint and referential existence
dependency. What each of them means, used for, implemented, etc.
b) Define Primary key, Secondary key, Candidate key .alternate Key, Super key and
Foreign key With example
Question # 3 (35 Points)
What is Data Model? What are the main features of RDM (relational Data Model)
and how it is different from Semantic Data Model― justify
M. A. Jinnah Campus, Defence Road, Off Raiwind Road, Lahore. UAN: 042-111-
880-880