Database Management System

• Chapter 1: Database Fundamentals and Architecture. Notes and past questions on Database Fundamentals and Architecture for TU BIT Database Management System.
• Chapter 2: Entity-Relationship Model. Notes and past questions on Entity-Relationship Model for TU BIT Database Management System.
• Chapter 3: Relational Data Model. Notes and past questions on Relational Data Model for TU BIT Database Management System.
• Chapter 4: ER to Relational Mapping. Notes and past questions on ER to Relational Mapping for TU BIT Database Management System.
• Chapter 5: Normalization and Database Design. Notes and past questions on Normalization and Database Design for TU BIT Database Management System.
• Chapter 6: SQL and Query Processing. Notes and past questions on SQL and Query Processing for TU BIT Database Management System.
• Chapter 7: Transaction Management. Notes and past questions on Transaction Management for TU BIT Database Management System.
• Chapter 8: Concurrency Control. Notes and past questions on Concurrency Control for TU BIT Database Management System.
• Chapter 9: Database Recovery and Reliability. Notes and past questions on Database Recovery and Reliability for TU BIT Database Management System.
• Chapter 10: NoSQL and Unstructured Data. Notes and past questions on NoSQL and Unstructured Data for TU BIT Database Management System.

• What is a transaction? Describe how lost update and dirty read problems occur in concurrent execution of transactions? Illustrate with ex... (2082)
• 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.... (2082)
• Why is normalization required? Define 1NF, 2NF and 3NF with suitable examples.[10] (2082)
• 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. U... (2082)
• How is the Group By Having clause used in SQL statements? Mention the syntax and example. [5] (2082)
• Describe the three schema architecture. How does the architecture create data independence? [5] (2082)
• What is database recovery? How can shadow paging be used for database recovery? [5] (2082)
• How data is stored and retrieved in NoSQL databases? Illustrate with examples. [5] (2082)
• What is two phase locking protocol? How can it lead to the deadlock condition? [5] (2082)
• Discuss the various types of constraints used on Extended ER Model. [5] (2082)
• What is the view? How can you create a view in SQL? Illustrate with an example. [5] (2082)
• Given following relations, write relational algebra statements for Person(Pid, pname, dob, paid) and Doctor(Did, pid, dname, dspeciality)... (2082)
• Define serial, non-serial and serializable schedules with example. How can you test serializability in a schedule? Explain with an exampl... (2080)
• What is Transaction? State and explain the states of transaction with transition diagram.[5] (2080)
• From the relations given below, answer the following questions EMPLOYEE (Ssn, Ename, Bdate, Address, Sex, Salary, Super_ssn, Dno), DEPART... (2080)

Frequently asked questions

Based on the official syllabus.