What is conflict schedule? Explain with example. [5]
2.
What is concurrency control? What are its advantages in DBMS? [5]
3.
What is transaction? Draw states of transaction and explain. [5]
Data Modeling Using the Entity-Relational Model
1.
What is entities and its types? How do we reduce different types of entities and relationships of ER diagram into Tables? Explain with assuming different types of entities and relations. [10]
2.
Explain aggregation with example. [5]
Database and Database
1.
What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence? [10]
Database System – Concepts and Architecture
1.
What do you mean by Schema and Instance in DBMS? Explain both with examples. [5]
Relational Database Design
1.
What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example. [10]
2.
Define functional dependencies. Explain 2nd normal form with example. [5]
SQL
1.
Retrieve the TName, and No_of_priod of teachers who teach in 'ABC' school using Relational Algebra.TEACHER (TID, TName, TAddress, TQualification), SCHOOL (SID, SName, SAddress, SPhone), SCHOOL_TEACHER (SID, TID, No_of_Period) [5]
The Relational Data Model and Relational Database Constraints