Application of the Standardization of the Relationship in the Database Design
Xia Cai, Yan Min Wang · Applied Mechanics and Materials · 2013
The library database design needs to accord certain rules, in relational database, this rule is paradigm. Paradigm is in line with a certain level of relational schema collections. Relational database relationship must meet certain requirements, namely to meet the different paradigms. At present, there are six kinds of relationship database paradigm: the first normal form (1NF), the second normal form (2NF), the third normal form (3NF), BC normal form (BCNF), the fourth normal form (4NF), the fifth normal form (5NF) and the sixth Normal Form (6NF). The 1NF is the minimum paradigm for requirement. Basing on the 1NF, further meeting more requirements is the 2NF and a higher level paradigm, in practical design application, you only need to reach the 3NF.