Consider a database scheme containing the following relation schemes, with designated keys in bold and sets of designated FDs as given:

relation scheme designated FDs

R1(A,B,C ) F1 = {ABA, BCA}

R2(B, C, D) F2 = {BCD}

R3(D, E, G) F3 = {DEG}

a) Is the database scheme as given in BCNF?

b) What designated FD is trivial?

c) What FD implied by designated keys does not appear in any set of designated FDs? What sets of designated FDs should contain it?