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

24.
25.
26.
27.
28.
29.
30.
31.

2
C 80866

۷٦
hat do you mean by commit point of a transaction ?

What are the phases of two-phase locking ?
(5 > 2 = 10 marks)

Part C (Short Essays)

Answer any five questions.
Each question carries 4 marks.

Discuss the categories of end users.

Write a note on entity set.
Distinguish between strong entity and weak entity.

Compare equijoin and natural join.
What are the basic data types available for attributes in SQL ?

Write a note on functional dependency.
Briefly explain the transaction states.
Explain lost update problem.

(5 x 4 = 20 marks)

Part D (Essays)
Answer any five questions.
Each question carries 8 marks.
Explain the advantages of using DBMS approach.

Discuss the three schema architecture.
Explain the union, intersection, set difference and division operations of relational algebra.

Discuss the commands used to modify the database.
Explain the anomalies in database.
Explain 1NF, 2NF and 3NF.

Discuss the ACID properties.
What are locks ? Discuss the various types of locks in concurrency control.
(5 x 8 = 40 marks)