R₁(A, B, C, D)
A → BCD
C → AB
R₂(E, F, G, H, I, J, K)
E → FG
EFG H
R₁(L, M, N, O, P, R)
L MN
LN → OPR
R → LM
a) For each of the relations R₁, R₂, and R3, check which of the following are candidate keys (can be
more than one for each relation, or none).
R₁: A, B, C, D, AB, BC, ABC
R₂: E, FG, EFG, EIJK
R₁: L, N, R, LN, MR, NMR
b) For each of the relations R₁, R₂, and R, determine if it is in 3NF.
c) For each of the relations R₁, R2, and R3 determine if it is in BCNF.