Q1. For the relation R with attributes A, B, C, D and set of FDs. F = {A → BC, B → C, A → B, AB → C, AC → D}. Calculate the canonical cover of F.
Q2. What do you mean by shadow page recovery scheme? Explain how does it compare and contrast with the log-based recovery methods in terms of ease of implementation and overhead costs?
Q3. Describe the deferred database modification. Illustrate its merits?
Q4. Describe the ACID properties of a transaction.
Q5. Describe the relative benefits of centralized and distributed databases.
Q6. Write detail notes on any three of the given:
a) Granularity of data items.
b) Multivalued Dependency and 4NF.
c) Join Dependency and 5NF.
d) Web Databases.