Q1. Describe Domain Integrity Constraint, Key Integrity Constraint, Entity Integrity Constraint and the Referential Integrity Constraint.
Q2. Design a generalization-specialization hierarchy for the motor-vehicle sales company. The company sells motorcycles, vans, passenger cars and buses. Validate your placement of attributes at every level of hierarchy. Describe why they must not be placed at a higher or lower level?
Q3. Distinguish between the given:
a) Simple (Atomic) and Composite Attributes.
b) Single-valued and multi-valued attributes.
c) Stored and Derived Attributes.
Q4. Describe the two-phase locking protocol? Describe strict and conservative two-phase locking protocol? Which of them is favored and explain why?
Q5. Describe why during system recovery from crash; the log records for transactions on the undo list should be processed in the backward direction and log records for transactions on redo list are processed in forward direction.