Consider The Relation R = {A, B, C, D, E, F, G, H, I, J, K} And The Set Of Functional Dependencies S = { {A, B} -> {C}, {B, D} -> {E, F}, {A, D} -> {G, H}, {B} -> {I}, {G} -> {J} , {F} -> {K} }.. Consider the relation R = {A, B, C, D, E, F, G, H, I, J, K} and the set of functional dependencies S = { {A, B} -> {C}, {B, D} -> {E, F}, {A, D} -> {G, H}, {B} -> {I}, {G} -> {J} , {F} -> {K} }.
- What is the key of R?
- Decompose R into 2NF relations:
- Further decompose the 2NF relations into 3NF relations:
- check whether the 3NF relations you obtained are in BCNF or not.