nf范式
Fourth Normal Form comes into picture when Multi-valued Dependency occur in any relation. In this tutorial we will learn about Multi-valued Dependency, how to remove it and how to make any table satisfy the fourth normal form.
当任何关系中发生多值依赖时,都会出现第四范式。 在本教程中,我们将学习多值依赖关系,如何删除它以及如何使任何表满足第四范式。
Follow the video above for complete explanation of 4th Normal Form. Or, if you want, you can even skip the video and jump to the section below for the complete tutorial.
请按照上面的视频对第四范式的完整说明。 或者,如果您愿意,甚至可以跳过视频并跳至下面的部分,以获取完整的教程。
In our last tutorial, we learned about the boyce-codd normal form, we suggest you to follow the last tutorial before this one.
在上一教程中,我们了解了boyce-codd范式 ,我们建议您先阅读上一本教程。
第四范式的规则 (Rules for 4th Normal Form)
For a table to satisfy the Fourth Normal Form, it should satisfy the following two conditions:
为了使表格满足第四范式,它应满足以下两个条件:
It should be in the Boyce-