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

Paper code: 13526
1526
B.Sc. (Computer Science) (Part 3)
Examination, 2019
Paper No. 3.2
INTRODUCTION TO DATABASE MANAGEMENT SYSTEM

Time: Three Hours] [Maximum Marks: 50

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

    (c) Privacy

    (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!