Introduction To Database Management System 2018 – BSc Computer Science Part 3

Note: Attempt any five questions. All questions carry equal marks.

1. Draw and explain the detailed system architecture of DBMS.

2. (a) What is a view? Explain it.

(b) What are various advantages of DBMS? Explain.

3. (a) Explain the different data types in SQL.

(b) Write the syntax for UPDATE command in SQL.

4. Explain briefly abut 3NF, 4NF and BCNF.

5. Differentiate between the following:

6. (a) What is hash based indexing?

(b) What is data fragmentation?

7. Define the following:

8. (a) What is 2-phase locking protocol? How it guarantee serializability?

(b) What do you mean by Concurrency Control?

……..End……..