INTRODUCTION TO DATABASE MANAGEMENT SYSTEM - 2017 | B.SC CS 3RD YEAR | MJPRU | EXAM PAPER | My CS Tutorial

Database management system | My CS Tutorial

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

_______________________________________

Please share this post and blog link with your friends.For more programs use this blog.

If you have any problem, please comment in comment box, subscribe this blog for notifications of new post on your email and follow this blog.If you have any method of this tutorial or program or want to give any suggestion send email on hc78326@gmail.com

Created by-- HARSH CHAUHAN