Question 7. a) Give an example of a relation in 2NF but not 3NF.

b) Determine all (minimal) keys for the following relation.

i) R [A B C]

F = {AB C, C B}

ii) R [A B C D] F = {C D, BC A}

c) Given the following:

RETAILTHERAPY [ProductID, ProductName, Manufacturer, RetailerName, URL, Price]

FD1:ProductID {ProductName, Manufacturer}

FD2:RetailerName URL FD3:{ProductID, RetailerName} Price

i) Determine the candidate key(s) for the given relation

ii) Determine the highest normal form of the given relation

iii) Decompose the given relation to achieve BCNF. You only have to show the final BCNF relations here