databasedatabase-normalizationfunctional-dependencies3nf

Higher normal form that this relation satisfies


Let R{A,B,C,D,E} be a relation with functional dependencies:

B->EA
EBC->D
BED->A

Question: What's the higher normal form that R satisfies?

Attempt:

Why (or why not) the 2NF is satisfied?


Solution

  • B -> EA
    

    is equivalent to the two dependencies:

    B -> E
    B -> A
    

    for the decomposition rule. Since neither E nor A are prime attribute and B is a proper subset of a candidate key, the relation is not in 2NF.