A. Define the term Functional Dependency as it applies to attributes in a single table.

B. What makes a functional dependency trivial?

C. Assume a relation R(A,B,C,D) with primary key AB is in 1st normal form, but not 2 nd normal form. Give at least three potential FDs that determine only part of a row.

D. What if R above is in 2nd normal form, but not 3rd normal form. Give an example FD that prevents R from being in 3rd normal form.

E. What if R has a key AB. What FD must be true for R to be in BCNF?

F. Assume R has the FDs: A-> ABCD and C->D, the last of which causes a violation of 3rd normal form. Decompose R into two relations R1 and R2 that are in 3NF. What attributes of R are in R1 and what attributes of R are in R2?

G. SQL permits arithmetic like Select A*D from R; Given that information and R1 and R2 from part F, write a select statement using JOIN that returns A*D