Q1. Describe the Trivial Functional dependencies with illustration.
Q2. Describe multivalued dependencies and as well explain 4NF with suitable illustration.
Q3. Give a Relation R(W, X, Y, Z) and functional dependencies are illustrated as:
W→Z
{Y, Z}→X
{W, Z}→Y
Find out the superkeys and candidate key.
Q4. What do you mean by the term lock? Explain the types of locks which are used in concurrency control?
Q5. Describe the various types of transaction failures. What do you mean by catastrophic failure?
Q6. Illustrate the two phase locking protocol? How does it guarantee serializability?