fifth normal formcomputing dictionary

<database design> A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the chances of data becoming inconsistent.

A table in a relational database is said to be in normal form if it satisfies certain constraints. Codd's original work defined three such forms but there are now five generally accepted steps of normalisation.

See: 1NF, 2NF, 3NF, 4NF, 5NF.

Fifth normal form breaks out data redundancy that is not covered by any of the previous normal forms.

(01 Oct 2005)

fifth disease, fifth finger, fifth generation language < Prev | Next > fifth ventricle, fiftieth, fig

Bookmark with: icon icon icon icon iconword visualiser Go and visit our forums Community Forums