• Attempt any five questions.
• All questions carry equal marks.
Describe various disadvantages of file system compare to Data base management system.
Differentiate specialization and generalization with help of example.
Explain in detail about various key constraints used in database system.
Explain the components of DBMS with a neat diagram. alt=''
Define and explain following terms :- Levels of data abstraction, Instances, Schema, Physical data independence, Logical data independence.
Consider the following relational schema: Doctor (Dname, Reg_no) Patient (Pname, Disease) Assigned To (Pname, Dname) Give expression in both SQL and relational algebra for each of the queries:
i) Get the names of patients who are assigned to more than one doctor.
ii) Get the names of doctors who are treating patients with 'Polio'.
State the Armstrong inference rules. Provide suitable examples to describe each.
Describe the concept of Referential Integrity
What do you mean by Normalization? Explain BCNF, 3NF and 2NF with a suitable example.
Given a set of FDs A \to B, ABCD \to E, EF \to G Is ACDF \to G, implied by the set of given FDs? Justify your answer.
What is Transaction? Explain its four important Properties.
What are the problems encountered in DDBMS while considering concurrency control and recovery.
Explain in detail about timestamp based concurrency control techniques.
Write and explain optimistic concurrency control algorithm.
Multi Valued Dependency
Expression Evaluation Plan
Object Oriented Data Base System.
