Choose Index below for a list of all words and phrases defined in this glossary.

Fifth Normal Form (5NF)

index | Index

Fifth Normal Form (5NF) - (1) A relation R is in fifth normal form (5NF) (also called Projection Join Normal Form (PJ/NF)) if and only if every join dependency in R is a consequence of the candidate keys of R. (2) A table is in 5NF if a relation or record in which all elements within a concatenated key are independent of each other and cannot be derived from the remainder of the key.

Source: Larry English, External, 26-Jan-2009 09:23

Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: