Distributed DBMS -Assignment 01, Exercises of Distributed Database Management Systems

Distributed DBMS - CS712 Fall 2008 Assignment 01

Typology: Exercises

2018/2019

Uploaded on 11/21/2019

zeeshan-haider-2
zeeshan-haider-2 🇵🇰

1 document

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
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

Partial preview of the text

Download Distributed DBMS -Assignment 01 and more Exercises Distributed Database Management Systems in PDF only on Docsity!

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-