Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control? [10]
2.
Define Functional dependencies. Explain trivial and non trivial dependencies? [5]
3.
Define schedule and serializability. How can you test the serializability? [5]
Data Modeling Using the Entity-Relational Model
1.
What are the components of ER diagram? Explain the function of various symbols use in ER diagram. Construct an ER diagram to store data in a library of your college. [10]
2.
Explain Relationship and Relationship sets with example. [5]
Database and Database
1.
What are different types of Database users and their roles? Explain the Data independence with example. [10]
Database Recovery Techniques
1.
What is Checkpoints in database recovery? How does it help in database recovery? Explain. [5]
Database System – Concepts and Architecture
1.
What is difference between logical data independence and physical data independence? [5]
Relational Database Design
1.
Define Boyce-Codd normal form with example. How it is different that 3rd Normal form. [5]
SQL
1.
Retirve the TName, SName, SPhone for “ABC” school using SQL from given relation as below. [5]
The Relational Algebra and Relational Calculus
1.
Explain the difference between 'Join' and 'Natural Join' of algebraic operations with example. [5]
The Relational Data Model and Relational Database Constraints
1.
What is integrity? Explain different types of database integrity. [5]