No. of Printed Pages: 3 IBIeS-OIII
B.Tech. -VIEP -COMPUTER SCIENCE AND ENGINEERING (BTCSVI) )0436 Term-End Examination June, 2016
BICS-O11 OATABASE MANAGEMENT SYSTEM
Time: 3 hours Maximum Marks: 70
Note Attempt any seven questions. All questions carry equal marks.

1. Draw a system architecture of DBMS. Explain each component in detail. 10

2. Give the various advantages and disadvantages of the network model. How is it different from the relational model? 5

What is a view? What are the advantages and disadvantages of views? 5

3. Construct an ER diagram for a railway reservation system keeping record of the following information:

Customer

Train Schedule

Booking

Routes

Enquiry

List all the assumptions you make about the database and mapping constraints. 10

4. Explain the terms integrity constraints and domain constraints with suitable examples. How are they enforced in Oracle? 5

List the ACID properties. Explain the usefulness of each property. 5

5. Given the relation schema R B C D and a functional dependency

FD

B,C A,D

D E}.

What is the candidate key?

What normal form is it in Explain. 5

What is normalization What is the difference between BCNF and 3NF Illustrate with the help of an example. 5

6. Discuss the procedure of deadlock deduction and recovery in transactions with the help of an example. 5

Explain indexing. What are the different types of indexing? 5

7. Given the relational schema:

flights (fino, from, to, distance, departs)

aircraft aname, range)

certified aid)

emp ename,salary)

Give the queries expressed in relational algebra for the following queries 4x2 1/2=10

Find eid of the pilots who are certified on Boeing.

Find the name of the pilots who are certified on Boeing.

Find flno of the flights that can be piloted by every pilot whose salary is over Rs 1,00,000.

Find eid of employees certified on all the aircraft.

8. Write short notes on any two of the following: 2x5=10

Log Based Recovery

States of Transaction

Cascading Schedules

Database Protection