a) Describe various disadvantages of file system compare to Data base management system. (Unit 1)

b) Differentiate specialization and generalization with help of example. (Unit 2)

a) Explain in detail about various key constraints used in database system. (Unit 2)

b) Explain the components of DBMS with a neat diagram. (Unit 1)

a) Define and explain following terms: Levels of data abstraction, Instances, Schema, Physical data independence, Logical data independence. (Unit 1)

b) 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'. (Unit 3)

a) State the Armstrong inference rules. Provide suitable examples to describe each. (Unit 4)

b) Describe the concept of Referential Integrity. (Unit 2)

a) What do you mean by Normalization? Explain BONE, 3NF and 2NF with a suitable example. (Unit 4)

b) Given a set of FDs
A→B, ABCD→E, EF G
Is ACDF G implied by the set of given FDs? Justify your answer. (Unit 4)

a) What is Transaction? Explain its four important Properties. (Unit 5)

b) What are the problems encountered in DDBMS while considering concurrency control and recovery. (Unit 5)

a) Explain in detail about timestamp based concurrency control techniques. (Unit 5)

b) Write and explain optimistic concurrency control algorithm. (Unit 5)

Write short note on any two:

a) Multi Valued Dependency (Unit 4)

b) Expression Evaluation Plan (Unit 3)

c) Object Oriented Data Base System. (Unit 5)