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

Paper code: 13526
1526
B.Sc. (Computer Science) (Part 3)
Examination, 2017
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 do you mean by the database management system? How does it differ from flat file system? Explain its three-tier architecture.

2. Enumerate and explain various aspects of the file organisation in database management system? Also writes its performance issues.

Section-B

3. Why do we need normal forms? Write and explain the following normal forms.

• 3NF
• 4NF
• BCNF

4. Why do we need data modelling? Explain various data modelling methods with appropriate example.

Section-C

5. Explain the following:

• Transaction
• Consistency
• Atomicity
• Durability
• Integrity

6. How the concurrent operations performed in database? Explain with appropriate example.

Section-D

7. Distinguish between the following:

1. Horizontal vs. vertical fragmentation
2. Homogeneous vs. heterogeneous system.

8. How deadlock are managed in database management system? Explain.

Section-E

9. Explain the following:

1. DDL
2. DML
3. DCL

10. Write short notes on any two of the following:

1. Oracle 8i
2. Codasyl
3. Authentication

……..End……..