A relation is in 5NF when multivalued dependencies are isolated in their own relation.

More Questions from The Relational Model and Normalization

• Keys made up of two or more attributes are called composite keys.
• A functional dependency is a relationship between or among attributes.
• A primary key is a composite key that was selected to be the main identifier for the relation.
• A relation is a two-dimensional table.
• The only reason for the existence of relations is to store instances of functional dependencies.
• Given the functional dependency R → (S,T) , then it is also true that R → S.
• A relation is in Boyce-Codd Normal Form (BCNF) if every determinant is a composite key.
• Any table that meets the definition of a relation is said to be in first normal form.
• In a relation, the order of the rows matters.
• Given the functional dependency R → S , R is called the determinant.

Discussion & Comments