Database Management System Question Paper - Jun 19 - Computer Engineering (Semester 5)

16views

written 5.4 years ago by

shaikhainiya2001 • 0

Database Management System - Jun 19

Computer Engineering (Semester 5)

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

1.a. Differentiate between file system and database system with an example

(5 marks) 00

1.b. Explain Referential Integrity with suitable example

(5 marks) 00

1.c. List the steps required to map ER , EER model to relational model

(5 marks) 00

1.d. Explain the ACID properties of transactions

(5 marks) 00

2.a. Explain the following Relational Algebra operations with suitable example. a) Project b) Select c) Union d) Cartesian Product

(10 marks) 00

2.b. Construct an EER diagram and convert into Relational Model for a library Management System. Specify 2 complex SQL queries on the above-one using Group by clause and the other using Join operation with an example

(10 marks) 00

3.a. Explain the following terms with an example:-

i) Natural join. ii)Set Intersection. iii)Weak Entity. iv) Foreign key

(10 marks) 00

3.b. Explain the Overall Architecture of DBMS in detail.

(10 marks) 00

4.a. Define Deadlock. Explain how deadlock can be handled

(10 marks) 00

4.b. Explain Specialization and Generalization with suitable example

(5 marks) 00

5.a. For the schema mentioned below

Employee( eid, ename, address, city) Works(eid, cid, salary)

Company( cid, cname, city)

Create an ER diagram for the same and Specify the SQL queries for each of the statements given below

1) Modify database so that John now lives in Mumbai, assuming the database entry has John staying in Delhi.

2) Find Employees who live in same city as the company for which they work.

3) Give all employees of"AZ Corporation" whose salary has increased by15% in the year 2018-19.

(10 marks) 00

5.b. Define the term Normalization as used in database design. Explain the various normal forms with an example

(10 marks) 00

6. Write short notes on any two

6.a. Log based recovery mechanism

(5 marks) 00

6.b. Triggers and transaction control commands

(5 marks) 00

6.c. Conflict and View serializability

(5 marks) 00

6.d. Data Independence

(5 marks) 00

ADD COMMENT EDIT