What normal form are the this relation in? Am I right?

Question

-

R(a, b, c, d)

Functional dependencies: None

I think it is 0NF, because there are no functional dependencies.

R(a, b, c, d)

Functional dependencies: b->d AND a,b->c

This should be 3NF, i think.

I am stuck at this one

R(a, b, c, d, e)

Functional dependencies: a->d,e AND a,d->b,c,e

Walter Mitty · Answer 1 · 2013-06-08 09:13:26Z

up vote 0 down vote

There is always the trivial dependency,

a,b,c,d -> a,b,c,d

The key is the entire relation. Not often useful, but not 0NF.

answered 51 mins ago

Walter Mitty
7,392721

1 Answer