Re: 4th and 5th normal form?

4th Normal Form (4NF)

Definition: A table is in 4NF if it is in BCNF and if it has no multi-valued dependencies.

5th Normal Form (5NF)

Definition: A table is in 5NF, also called "Projection-Join Normal Form" (PJNF), if it is in 4NF and if every join dependency in the table is a consequence of the candidate keys of the table.

Follow this link for more detailed explanation: http://www.gslis.utexas.edu/~l384k11w/normstep.html

"Mil Wouters" <mil_wouters_at_servico.be> wrote in message news:86jie3$rd6$1_at_news.planetinternet.be...
> I know what the normal forms 0,1,2,3 but what's the 4th and 5th normal
 form?
> Can anyone give me a brief explanation?
>
> Thanks,
>
> Mil
>
>
Received on Tue Jan 25 2000 - 00:00:00 CST