Filed under:
IGNOU MCA
Question Paper of CS-15 - RDBMS of December 1997
Time : 3 hours
Max. Mark : 75
Note : There are six questions in this paper.
Question 1 us compulsory and carries 30 marks.
Attempt any three from the rest.
Qns 1. (a) Draw an E-R diagram for a Hospital System. Convert this diagram to a suitable relational schema.
(b) Convert the following query in domain calculus to relational algebra, tuple calculus and English words {< A, B > | < A, B> BELONGS rel1 6B = ‘B1′ VB = ‘B2′}
© What is view ? What are the problems associated with an update operation of RDBMS if it is to be performed using views ?
(d) Explain the sort and merge method of Query evaluation.
(e) What is a Log in RDBMS ? what is write-ahead log-strategy ? How is this strategy useful in recovery of centralised databases ?
(f) what is intention-mode locking ? Explain various locks used for locking a hierarchical structure of database.
Qns 2. Write short notes on the following :
(a) Statistical Databases
(b) Access matrix and query modification
© Atomicity of Transaction
(d) Phantom phenomenon
(e) Cascading rollback
Qns 3. (a) What is prenex normal form for a query ? Explain with the help of an example.
(b) What are the basic components of a Query Processor ? Discuss.
© What are the states of a Transaction ? Discuss.
Qns 4. (a) What is shadow paging scheme for database recovery ?
(b) Describe the time-stamp based concurrency management scheme.
Qns 5. (a) A relation X { A,B,C,D,E,F,G,H} is having functional dependences as
{ABCDEFGH,
BCD AEFGH,
BCE ADEFGH,
CE H,
CD H}
Develop the normalised relational scheme of the relation.
(b) Define the following terms :
(i) Access Plan
(ii) Join Selectivity
(iii) Join Indexes
(iv) Serializable Schedule
(v) Two phase locking protocol
Qns 6. Write short notes on the following in the context of RDBMS :
(a) Triggers and Referential Integrity
(b) Relational Algebra versus Relational Calculus
© Embedded Data Manipulation Language
(d) Archival Databases
(e) Disaster Recovery
(f) Transaction Redo
(g) Check Pointing
|