BSc IT Sem III ATKT DATABASE MANAGEMENT SYSTEM Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt of the following: 15 marks
   • a. Write the disadvantages of file processing system
   • b. any two applications where database management system can be used
   • c. Write a short note on business rules
   • d. What is the importance of data model?
   • e. Explain the concept of weak entity set
   • f. | Write various symbols and their meaning used to draw ER diagram
2. Q2 Attempt of the following: 15 marks
   • a. | Whatdo you mean by decomposition? Write the desirable properties of decomposition
   • c. List aggregate functions of relational algebra. Explain with example
   • d. Explain the following relational algebra operations
3. Q1 Rename product
   • e. Write a formal definition of domain relational calculus. Explain with example
   • f. Write a short note on tuple relational calculus
4. Q3 Attempt of the following: 15 marks
   • a. Write a short note on views
   • b. the importance of triggers in SQL
   • c. do you mean by integrity constraint? Explain with example
   • d. various set operations of SQL. Explain any two with example
   • e. the schema where the primary keys are underlined emp_dept (E_id, dept_id, from_date,to_date) Construct the following SQL queries for this relational database
5. Q1 List all the employees of IT department
6. Q2 Delete employee whose name is ‘ABC’
7. Q3 List all departments in which at least one employee gets salary > 50000
8. Q4 List all the departments that established in the year 2000
9. Q5 Update the salary of employee to 20000 whose id is ‘E001’ for April 2018
   • f. Write SQL DDL corresponding to the schema in Q.3 e. Make any reasonable assumptions about data types, and be sure to declare primary and foreign keys
10. Q4 Attempt any three of the following: 15 marks
    • a. ACID
    • b. state diagram of transaction. Explain in short
    • c. Explain the timestamp-ordering protocol
    • d. Write a note on conflict serializability
    • e. | What is deadlock? Explain deadlock prevention
    • f. | What do you mean by concurrent execution? Write the advantages of the same
11. Q5 Attempt of the following: 15 marks
    • a. What is implicit cursor? Write implicit cursor attribute
    • b. With example explain the conditional control in PL/SQL
    • c. Write a PL/SQL function that returns the factorial of a number
    • d. What is package in PL/SQL? Explain with example
    • e. What is a procedure/function? Differentiate between procedure and function
    • f. | What is exception? Explain exception handling in PL/SQL

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