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:
- Horizontal vs. vertical fragmentation
- Homogeneous vs. heterogeneous system.
8. How deadlock are managed in database management system? Explain.
Section-E
9. Explain the following:
- DDL
- DML
- DCL
10. Write short notes on any two of the following:
- Oracle 8i
- Codasyl
- Authentication
……..End……..
Leave a Comment