database-normalization3nfbcnf

Normalization Form

would like to ask a question that related with normalization form.

R = A,B,C,D
AB -> CD
CD -> AB

Is this is 3NF with BCNF ? why ?

Solution

  • If the two dependencies are a cover of all the dependencies holding on the relation, it is in BCNF and in 3NF, since the candidate keys are AB and CD.