Engineering BE Electronics and Telecommunication Sem 6 December 2019 2019 Database Management System Elective IIChoice Base Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q2 Solve any three from remaining five questions
2. Q1 Solve all. 20 marks
   • a) Explain ACID properties of transaction
   • b) Explain different types of attributes with examples?
   • c) Explain weak entity with example
   • d) Describe trigger with example
3. Q2 a) Define Normalization? Explain INF, 2NF and 3NF with example. )
   • b)Discuss conflict serliazability and view serializability with example
4. Q3 a) Consider a MOVIE database in which data is recorded about the movieindustry. The data requirements are summarized as follows: e Each movie is identified by title and year of release. Each movie has alength in minutes Each has a production company, and each is classifiedunder one or more genres (such as horror, action, drama, and so forth).Each movie has one or more directors and one or more actors appear in it.Each movie also has a plot outline. Finally, each movie has zero or morequotable quotes, each of which is spoken by a particularactor appearingin the e Actors are identified by name and date of birth and appear in one or moremovies. Each actor has a role in the movie e Directors are also identified by name and date of birth and direct one ormore movies. It is possible for a director to act in a movie (including onethat he or she may also direct) e Production companies are identified by name and each has an address. Aproduction company produces one or more movies Design an entity—relationship diagram for the movie database, fio Marks)
   • b) Define deadlock. Explain Deadlock Detection, Prevention and Recovery
5. Q4 a) Explain three level schema architecture of DBMS. State different level of dependencies in this architecture. (io M arks)
   • b) What do you mean by data modelling. Discuss different types of models 10
6. Q5 a) Draw E-R diagram for hospital management system. Convert E-R diagram into tables member (member_no, name, age) borrowed (member_no, isbn, date) Write the following queries in SQL (10 Marks)
   • (a) Find the name of all members who have borrowed any book published by McGraw
   • (b) Find the name of all members who have borrowed all book published by McGraw-Hill
   • (c) Find the names of members who have borrowed more than five different books published by McGraw-Hill.(4 Marks) Write the following queries in SQL
   • (a) Find all customers of the bank who have an account but not a loan 2
   • (b) Find the names of all branches with customers who have an account in the bank and who live in “Harrison”. (2 Marks)
   • (c) Delete the record of all accounts with balances below the average at the bank. 2
   • (d) Find out the total sum of all loan amounts in the bank. 2
   • (e) Find the names of all branches where the average account balance is more than $1,200
   • b) Write short note on(any two) Marks)
7. Q1 Constraints in SQL 2)Specialization and generalization
8. Q3 Integrity Constraints

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