Q1.
a) Define the term transaction and its desirable ACID properties. Describe the problem of dirty read by providing an illustration.
b) Illustrate the terms data redundancy, data integrity, data constraints and data independence
c) Distinguish between the strong entity set and weak entity set.
Q2.
a) Illustrate the key properties of long duration transactions? How does the concurrency protocol influence the long duration transactions?
b) How checkpoints are employed in the database recovery?