Fifth Normal Form

Fifth normal form (5NF), also known as project-join normal form (PJ/NF) is a level of database normalization designed to reduce redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships. A table is said to be in the 5NF if and only if every join dependency in it is implied by the candidate keys.

A join dependency *{A, B, … Z} on R is implied by the candidate key(s) of R if and only if each of A, B, …, Z is a superkey for R.

Read more about Fifth Normal FormExample

Famous quotes containing the words form and/or normal:

    Thought is the seed of action; but action is as much its second form as thought is its first.
    Ralph Waldo Emerson (1803–1882)

    Dada doubts everything. Dada is an armadillo. Everything is Dada, too. Beware of Dada. Anti-dadaism is a disease: selfkleptomania, man’s normal condition, is Dada. But the real dadas are against Dada.
    Tristan Tzara (1896–1963)