Unit 3

QUERY PROCESSING AND DATABASE TRANSACTIONS

Q.10       Explain Assertion and Triggers with suitable example.

Q.11       Given relation R(A, B, C, D, E) with dependencies AB->C, CD->E, DE->B. Is AB a candidate key? Or Is ABD is a candidate key?

Q.12       What are the different types of triggers?

Q.13       What is triggers in SQL with example?

Q.14       Compute the Closure (F+) and Canonical Cover (Fc) of following set Fof FDs for relation schema R = (A, B, C, D, E)

A →BC CD →E B →D E→ A