BSc IT Sem III ATKT 2017-18 ATKT Database Management System Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any three of the following: 15 marks
   • a. What are the disadvantages of file processing system?
   • b. List and explain different levels of abstraction Write importance of data model
   • d. What are the basic building blocks of data model? Explain with example What is mapping cardinality? Explain with suitable example
   • f. List and explain different types of attributes in ER model
2. Q2 Attempt any three of the following: 15 marks
   • a. Write a short note on Boyce—Codd Normal Form(BCNF)
   • b. Define: Give example of each With suitable example explain the select and project operation of relational algebra
   • d. Explain the aggregate operation of relational algebra
   • e. Write the formal definition of tuple Explain
   • f. Write a short note on domain
3. Q3 Attempt any three of the following: 15 marks
   • a. Explain the use of integrity constraints
   • b. What is view? Explain how to create a view Write-a short note on updatable view
   • d. Consider the schema where the primary keys are underlined Construct the following SQL queries for this relational database
   • (i) Find the total number of people who owned cars that were involved in accidents in
   • (ii) Add a new accident to the database; assume any values for required attributes
   • (iii) Delete. the Mazda belonging to “John Smith”
   • (iv) Find the number of accidents in which the cars belonging to “John Smith” were involved. 5. Update the damage amount for the car with the license number “AABB2000” in the accident with report number “AR2197” to $3000
   • e. Write SQL DDL corresponding to the schema in Q.3 d. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys
   • f. What is trigger? Why is it required? Explain with example
   • Q. P. Code: 20942
4. Q4 Attempt any three of the following: 15 marks
   • a. Write the ACID properties
   • b. List and explain various states of transaction Write a note on conflict serializability d Explain the Two-Phase locking protocol e How deadlock is prevented? f Explain the timestamp ordering protocol
5. Q5 Attempt any three of the following: 15 marks
   • a. Explain with example the for loop in PL/SQL
   • b. What is cursor? What are different types of cursors? List and explain different cursor Write a function that is used to display factorial of anumber entered by user. Also write a PL/SQL block that calls this function
   • d. Explain how exceptions are handled in PL/SQL. Give suitable example
   • e. Create a package containing definition of a procedure, a constant and.a variable. Write a PL/SQL program to use the same
   • f. Explain how triggers are created. Give suitable example

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