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

Note: Attempt any five questions in all selecting one question from each section. All questions carry equal marks.

Section-A

1. What is data ? Explain the term “DBMS”. how does DBMS is different from traditional file management system ?

2. Describe various aspects of file organization with respect to the physical allocation.

Section-B

3. Explain the following data models with examples :

(i) Relational

(ii) Hierarchical

(iii) Network

4. What is the process of database design ? Describe “SQL” in detail.

Section-C

5. Explain various approaches for data integrity.

6. Write down about the following concepts :

(a) Consistency

(b) Security

(d) Authentication

Section-D

7. Describe the concept of data fragmentation in detail.

8. What do you mean by “Deadlock” ? What are the factors responsible for deadlock condition ? How deadlocks are prevented ?

……..End……..

Thank You!