BSc IT Sem III 2022 2023 Oct 2023 DATABASE MANAGEMENT SYSTEM Question Paper - Mumbai University | munotes

Questions asked in this paper

• (2) Figures to the right indicate marks

1. Q1 Attempt any three of the following. 15 marks
   • a) Explain network model
   • b) Explain the different types of Database Users
   • c) List and explain building blocks of data model
   • d) Describe with example the concept of Mapping List and Explain Codd’s Rules (any five) !) A football club has a name and ground and is made up of players. A player can play for only one club and a manager, represented by his name manages a club A footballer has a registration number, name and age. A club manager also buys Each club plays against each other club in the league and matches have a date. venue and
2. Q2 Attempt any three of the following. 15 marks
   • a) Explain the Normalization with its forms Write a note on relational algebra
   • c) What is the tuple relational calculus? Explain it
   • d) Differentiate between Relational Algebra and Relational Calculus Explain set operator with suitable example !) Write a short note on Domain Relational Calculus
3. Q3 Attempt any three of the following
   • a) Explain correlated Subqueries with its types
   • 5) Explain Group by clause and Order by clause with example
   • c) Write the of views
   • d) Explain aggregate functions with example Solve the following query
   • 1) Display the total number of employees
   • 2) Display the names of the employees located in city ‘Pune’
   • 3) Display the employee’s name whose name begin with
   • 4) Display the employee’s name whose salary is greater than 10000
   • 5) Display all the employees located in each city / VCD/ SYIT SEM III DATABASE MANAGEMENT SYSTEM .75 MARKS 2% HOURS ‘ Q4. Attempt any three of the following
   • a) Explain properties of transaction,
   • b) Write a short note on view serializability What are concurrent transactions? Explain
   • d) Write a short note on 2PL Discuss various Strategies used for handling deadlock Write a short note on transaction state
4. Q5 Attempt any three of the following. 15 marks
   • a) Create a function to swap numbers
   • b) Explain while loop statement in PL/SQL block with an example How to create and execute store
   • d) Create a trigger to insert the name of the student in UPPERCASE in the table student Explain CASE statement with example
   • f) What do you mean by parameterized cursor? How to declare it? Explain

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