数据库范式5nf
Fifth normal form (5NF) is also known as project-join normal form (PJ/NF). It is designed to minimize redundancy in relational databases by separating semantically connected relationships in multiple formats to store multi-valued facts.
第五范式(5NF)也称为投影联合范式(PJ / NF) 。 它旨在通过以多种格式分隔语义连接的关系来存储多值事实,以最大程度地减少关系数据库中的冗余。
A relation R is in 5NF if and only if every non-trivial join dependency in R is implied by the candidate keys of R. A relation break up into two relations must contain lossless join Property, which makes certain that no invalid or extra tuples of attributes are created when relations are again joined together through a natural join.
关系R是5NF当且仅当每一个不平凡的连接依赖于R由R的候选键暗示。 分解为两个关系的关系必须包含无损连接属性,这可以确保在通过自然连接将关系再次连接在一起时,不会创建任何无效或多余的元组。
Properties:
特性:
A relation R with attributes, its values and tuples is in 5NF if and only if the following conditions are satisfied,
当且仅当满足以下条件时,带有属性,其值和元组的关系R的值为5NF :
The relation R should be already in 4NF.
关系R应该已经在4NF中 。
The relation R cannot be additionally non loss decomposed (join dependency).
关系R不能另外进行非损耗分解(联接依赖)。
If the relation or table can further decompose to remove redundancy and anomaly, and when the process of rejoining followed the decomposed tables through the means