Database Management System Question Paper - May 16 - Computer Engineering (Semester 5)

34views

written 5.6 years ago by

yashbeer ★ 11k

Database Management System - May 16 (Old Syllabus 2012)

Computer Engineering (Semester 5)

TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks.

1(a) Explain BCNF with example.

(5 marks) 652

1(b) Write short note on Deadlocks.

(5 marks) 662

1(c) Explain Total and partial Participation.

(5 marks) 00

1(d) Discuss the role of Database Administrator.

(5 marks) 635

2(a) Discuss steps in query processing. Also describe cost based query optimization.

(10 marks) 00

2(b) Draw an ER Diagram and convert it into relational model for a Company, which has several Employees working on different types of projects. Several Employees are working for one Department every Department has a Manager. Several Employees are supervised by one Employee.

(10 marks) 00

3(a) Explain types of integrity constraints with example.

(10 marks) 00

3(b) Discuss Data definition and Manipulation Commands in SQL.

(10 marks) 653

4(a) Describe the overall architecture of DBMS with suitable diagram.

(10 marks) 638

4(b) Explain Security and Authorization in DBMS.

(10 marks) 00

5(a) Explain the following Relational Algebra Operations with example:
i. Natural Join
645

ii. Set Intersection
iii. Generalized Projection
642

iv. Division Operator

(10 marks) 00

5(b) Explain Assertions and Triggers in detail.

(10 marks)

Write Short notes on

6(a) ACID properties

(5 marks) 654

6(b) Shadow Paging

(5 marks) 661

6(c) Specialization and Generalization

(5 marks) 642

6(d) Aggregate Functions in SQL.

(5 marks) 648

ADD COMMENT EDIT