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

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

2 C 23299
Part C

Answer any five questions.
Each question carries 4 marks.

Briefly discuss about various advantages of a DBMS. |

Explain about any two popular data models.

Differentiate between physical data independence and logical data independence.
Explain the syntax and working of SELECT command in SQL.

Explain about various aggregate functions available in SQL.

Discuss about the lost update problem.

What are the basic properties of a transaction ? Explain each.

What is serializability ? Explain the concept with the help of an example. :
۱
; (5 x 4 = 20 marks)

Part D

Answer any five questions. |
Each question carries 8 marks.

Explain the differences between a file-oriented system and a database oriented system.
Explain with example, various basic operations of relational algebra. |
What are the different ways of joining multiple tables together ? Explain.
Explain various DML commands with syntax and example.
What is functional dependency ? Explain 2NF, 3NF and BCNF ? |
Distinguish between implicit and explicit locking.
Describe the use of stored procedures and functions with example.
Write short notes on :

(a) EER diagrams.

(b) Views in SQL.

(c) Anomalies in a database.

(d) Granting and revoking privileges.

(5 x 8 = 40 marks)