中文翻译过来的一大堆概念很晦涩,中英文结合去看,知其所以然,更好理解
自己理解,通俗来说:
###1NF规则:
1.列不可分。字段不能是集合,
----every attribute is an elementary type,not a set
2.行被索引。即要有主键(可以是字段组合)
----identify each row with a unique column (the primary key)
###2NF规则:
1.满足1NF
2.通过拆表、外键减少redundant data, 消除部分依赖
----every non-prime attribute dependent on the whole of every candidate key
----reduce the redundant data by extracting it, placing it in new table(s) and creating relationships between those tables by foreign keys.
###3NF规则:
1.满足2NF
2.直接依赖。其他所有非主键字段完全依赖主键, 消除传递依赖
----every non-prime attribute depend on the primary key directly
可参考文章:
[1]https://www.ibm.com/developerworks/cn/data/library/techarticles/dm-0605jiangt/index.html IBM技术文档
[2]https://www.thoughtco.com/database-normalization-basics-1019735 英文,容易看懂三大范式到底是要做什么,翻译的话容易变味
[3]https://en.wikipedia.org/wiki/Database_normalization 维基百科
[4]https://zhuanlan.zhihu.com/p/24342860