16.
17.
18.
19.
20.
21.
22.
23.

24.
25.

26.
27.
28.

29.
30.

31.

2 ६ C 3969
Part C

Answer any five questions.
Each question carries 4 marks.
What are the responsibilities of DBA ?
Distinguish between logical data independence and physical data independence.
Distinguish between primary key, super key and candidate key.
Define 3NF and BCNF.
Compare DDL and DML.
What is lost update problem ?
Explain about two-phase locking protocol.
Explain the syntax to create a stored procedure with an example.
(5 x 4= 20 marks)
Part D ಕ

Answer any five questions.
Each question carries 8 marks.
With the help of a neat diagram, explain the three level architecture of a DBMS.

Differentiate between relational algebra and relational calculus. Explain any three relational
algebraic operations.

Explain about various DML commands with syntax and example.
Explain about the desirable properties of a transaction.

Construct an ER diagram for a car insurance company with a set of customers, each of whom owns
a number of cars. Each car has a number of recorded accidents associated with it. Identify the
appropriate entities, attribute and relationships.

Distinguish between lock-based protocol and timestamp-based protocols.
(a) Distinguish between tuple relational calculus and domain relational calculus.
(b) Explain about multi-valued dependency.
Write short notes on:
(a) Referential integrity.
(b) - Concurrency control in a database system.
(5 x 8 = 40 marks)