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!
Leave a Comment