Group B

2. What is DBMS? Describe the merits of using DBMS.

3. What is Data Model? What is the difference between hierarchical and network data model? what are its types?

4. Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.

5. Discuss about materialized and pipelined evaluation of query expression in query optimization.

6. Explain with examples, how lost update and dirty read problems can occur in sentence of transactions?

7. How time stamp ordering protocol is used to ensure concurrency control?

8. What is the advantage and Disadvantage of using stored procedure? How can you create and execute stored procedure?

Group C

9. Design an ER diagram for Hospital System. Use your assumption for the selection attributes, entities and relationships. Show the use of total and partial participation along with the appropriate cardinalities.

10. Discuss the importance of normalization in DBMS. Describe 1NF, 2NF and 3NF with examples.

11. Consider a database system with following schemes: Restaurant(Rname, Rlocation, Rfund) Cook(Cname, Cspeciality) Worksat(Cname, Rname, Workinghrs, Shift) Food(Fname, Cname, Catagory) Now write SQL statements and relational algebra statements for following Queries: a) Select the name and location of all restaurants. b) Find the working hours of cook named "Sita". c) Select name of the foods cooked by "Ramesh". d) Use join to select name of restaurants where food of category "breakfast" is available. e) Find the name of cooks who work as "KFC"

Database Management System 2020 Board Question Paper

Database Management System 2020 Board Question Paper