Engineering BE Computer Engineering Sem 5 May 2019 2019 Data Management System Question Paper - Mumbai University | munotes

Questions asked in this paper

• Please check whether you have got the right question paper

1. Q2 Attempt any 3 questions out of rest
2. Q3 Make suitable assumptions if any
3. Q4 All questions carry equal marks
4. Q1 a) Differentiate between file system and database system with an example 5 marks
   • b) Explain Referential Integrity with suitable example 05
   • c) List the steps required to map ER , EER model to relational model 05
   • d) Explain the ACID properties of transactions 05
5. Q2 a) Explain the following Relational Algebra operations with suitable example. 10 marks
   • a) Project Select
   • b) Construct an EER diagram and convert into Relational Model fora library 10 Specify 2 complex SQL queries on the above-one using Group by clause and the other using Join operation with an example
6. Q3 a) Explain the following terms with an example 10 marks
   • b) Explain the Overall Architecture of DBMS in detail. 10
7. Q4 a) Define Deadlock. Explain how deadlock can be handled 10 marks
   • b) Explain Specialization and Generalization with suitable example 10
8. Q5 a) For the schema mentioned below Create an ER diagram for the same and Specify the SQL queries for each of the statements given below 10 marks
9. Q1 Modify database so that John now lives in Mumbai, assuming the database entry has John staying in Delhi
10. Q2 Find Employees who live in same city as the company for which they work
11. Q3 Give all employees of"AZ Corporation" whose salary has increased by15% in the year
    • b) Define the term Normalization as used in database design. Explain the various normal forms with an example
12. Q6 Write short notes on any two 20 marks
    • b) Triggers and transaction control commands
    • c) Conflict and View Serializability
    • d) Data Independence

Read from the scan above, so a character or two may differ. The scan is the original.