Introduction To Database Management System 2024 – BSc CS Part 3

Total No. of Questions : 10] [To No. of Printed Pages : 3

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

Time: 3 Hours] [Maximum Marks: 50

Note : Attempt any five questions in all selecting one question from each unit.

Section-A

1. (a) What do you understand by storage structure and data structure? Explain.

    (b) What is Data Base system architecture? Explain.

2. (a) What do you understand by the aspects of file organization relating to physical allocation?

    (b) What is classical data management?

Section-B

   (b) What is normalization? Define 2NF and 3NF with the help of example?

4. (a) What is SQL and what are its application?

    (b) What are the differences between DDL and DML? Explain.

Section-C

5. (a) Present detailed study of relational model?

    (b) What is distributed database? Explain.

6. (a) What is the data fragmentation? Explain.

    (b) Explain privacy and authentication aspects in database.

Section-D

7. (a) What is the difference between homogeneous hetrogeneous system? Explain.

    (b)What do you understand by the management of deadlock and crashes? Explain.

8. (a) What is distributed concurrency control? Explain.

    (b) Explain consistency and security aspects in database.

Section-E

9. (a) What is ORACLE 8i? Explain.

    (b) What is data integrity? Explain.

10. (a) Explain following terms:

        (i) Systems R,

        (ii) DBTG

        (iii) IMS

    (b) Explain Hierarchical and network data models.

……..End……..

Thank you Neeraj 🙂