BSc IT Sem I 2023 2024 2024 FUNDAMENTALS OF DATABASE MANAGEMENT SYSTEMS Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 All questions are compulsory
2. Q2 All questions carry equal marks Attempt the following (Any Three) [15 Marks]
   • a) What is DBMS? Explain any Four Database System Application
   • b) Explain various types of Database Users
   • c) List and explain different levels of Abstraction
   • d) Write a short note on
   • a. Selection
   • b. Union
   • c. Join
   • e) Explain various types of Keys used in DBMS
   • f) Explain the DML & DDL with example
3. Q2 Attempt the following (Any Three) 15 marks
   • a) List and explain different types of Attributes in ER-models?
   • b) Construct an ER diagram for a Hotel Management System. Customer books the room, customer pay amount. Customer uses restaurant for breakfast, lunch and dinner. After checkout, cusiomer leaves the room
   • c) Explain Generalization with proper example
   • d) State and explain Codd’s 12 rules
   • e) Explain the various Notation for ER diagram
   • f) Explain Class diagram with suitable example
4. Q3 Attempt the following (Any Three) {15 Marks]
   • a) the Functional dependency
   • b) Write a short note on Lossless join Decomposition
   • c) Explain Needs of Normalization
   • d) Explain the concept of Normalization. Also explain 2NF
   • e) Explain the’co:cept of Lossy join Decomposition
   • f) Consider following un-normalized data Cust_id Cust_name Cust_phone Description Order no VCD/ F.Y.B.Sc.IT Fundamentals of DBMS 2” HOURS
5. Q4 Attempt the following (Any Three) 15 marks
   • a) Write a short note on Views
   • b) Explain the different Aggregate Function with proper example What is Index? Explain Primary Index and Secondary Index
   • d) Consider following tables: and write queries for following: Find the employee id whose salary lies in the range of 35000 and 55000
6. Q2 Display the empid, name that are present in employee but not in employeeSalary
7. Q3 Find the maximum, minimum, average salary uf the employees
8. Q4 Display total number of employees living in same city
9. Q5 Display all those employees who work on project other than P3
   • e) What is Join? Explain type of Join
   • f) Write note on:
   • i. Group By
10. Q5 Attempt the following (Any Three) 15 marks
    • a) Explain States of Transaction
    • b) Explain the concept of Serializability and explain in detail view Serializability
    • c) What is Deadlock? How you can prevent the Deadlock?
    • d) Describe ACID properties for Transaction Explain the Two-phase locking protocol (2PL)
    • f) Explain Undo and Redo phase in Aries Algorithm

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