What is the need for an ER diagram? Design an ER diagram that contains at least five entities. One of the entities must be a weak entity. There should be many to many relationships between the two strong entities. One of the entities should have derived and multi-valued attributes. Any one strong entity should have total participation in a relationship with another entity. Use your own assumptions as per required.[10]
2.
Discuss the various types of constraints used on Extended ER Model.[5]
Database Recovery Techniques
1.
What is database recovery? How can shadow paging be used for database recovery?[5]
NoSQL
1.
How data is stored and retrieved in NoSQL databases? Illustrate with examples.[5]
SQL
1.
Write SQL statements to create a table and update value in a table. Also mention the use of cascade on delete while creating the table. Use your own assumption for the table and update conditions.[5]
2.
How is the Group By Having clause used in SQL statements? Mention the syntax and example.[5]
3.
What is the view? How can you create a view in SQL? Illustrate with an example.[5]
The Relational Data Model and Relational Database Constraints
1.
Why is normalization required? Define 1NF, 2NF and 3NF with suitable examples.[10]
2.
Given following relations, write relational algebra statements for Person(Pid, pname, dob, paid) and Doctor(Did, pid, dname, dspeciality). a. Retrieving name of person who is doctor b. Retrieving all doctors whose speciality is pediatric.[5]
Transaction Processing and Concurrency Control, and Recovery
1.
What is a transaction? Describe how lost update and dirty read problems occur in concurrent execution of transactions? Illustrate with examples.[10]
2.
What is two phase locking protocol? How can it lead to the deadlock condition?[5]
1.
Describe the three schema architecture. How does the architecture create data independence?[5]