I have a schema
with the following functional dependencies
I need to figure out which is the highest normal form in which the following table exists. Here
A is the primary key.
2NF- Since B, C and D are fully dependent on A, 2NF holds.
3NF-Since B,C and D are not transitively dependent on A. 3NF holds.
Since on the LHS of functional dependencies, there are only super keys, BCNF holds.
Is my solution fully correct? or am i lacking something? I feel this is not 100% correct. Here
CD is also a key attribute so do I not need to check my non key attributes with it?