B.Sc. (Information Technology) Sem I Database Management System Nov 2024 Question Paper - Mumbai University | munotes

Questions asked in this paper

SECTION I - Q.1 (Attempt any TWO out of FOUR) 15 Marks

1. Q1 What is an Entity-Relationship (ER) model, and how does it assist in database design?
2. Q2 Identify and explain the basic building blocks of data models.
3. Q3 What is a database system, and what are its primary purposes?
4. Q4 Explain the concept of keys in a relational database model. What are the different types of keys?

SECTION II - Q.2 (Attempt any TWO out of FOUR) 15 Marks

1. Q5 What are the benefits and drawbacks of denormalization in database design?
2. Q6 What are the different types of indexes in a relational database, and how do they improve query performance?
3. Q7 Explain the concept of concurrency control in transaction management, and discuss the different techniques used to achieve it.
4. Q8 Explain how to write a complex SQL query using subqueries and joins.

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