0
844views
Database Management Systems Question Paper - Dec 17 - Computer Engineering (Semester 4) - Mumbai University (MU)
1 Answer
0
11views

Database Management Systems - Dec 17

Computer Engineering (Semester 4)

Total marks: 80
Total time: 3 Hours
INSTRUCTIONS
(1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Make Suitable assumptions wherever necessary.

Q1

a) Describe data independence.
(5 marks) 00

b) Compare file system and database system.
(5 marks) 00

c) Explain ACID properties.
(5 marks) 00

d) Explain aggregate Functions in SQL.
(5 marks) 00

Q2

a) Define Normalization. Discuss different Normalization Techniques with example.
(10 marks) 00

b) Describe the overall architecture of DBMS with suitable diagrams.
(10 marks) 00

Q3

a) Explain types of integrity constraints with example.
(10 marks) 00

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

Q4

a) Discuss Data Definition and Manupulation commands in SQL.
(10 marks) 00

b) Explain security and Authorization in DBMS.
(10 marks) 00

Q5

a) Explain the following Relational Algebra Operations with eample.
(10 marks) 00

i. Cartesian product

ii. Natural Join

iii. Project

iv. Union

b) Explain Log based recovery and shadow paging in detail.
(10 marks) 00

Q6 Write Short note on:

a) Steps in Query Processing
(5 marks) 00

b) Role of database Administrator
(5 marks) 00

c) Deadlocks
(5 marks) 00

d) Specialization and Aggregation
(5 marks) 00

Please log in to add an answer.