数据结构-范式（Data structure paradigm）.doc

数据结构-范式（Data structure paradigm） The basic rule of relational database design -- Paradigm The construction database must follow certain rules. This rule is the paradigm in relational databases. A paradigm is a collection of relational patterns that conform to a certain level. Relationships in relational databases must satisfy certain requirements, i.e., satisfy different paradigms. At present, relational databases have six paradigms: the first paradigm (1NF), the second paradigm (2NF), the third paradigm (3NF), the fourth paradigm (4NF), the fifth paradigm (5NF) and the sixth paradigm (6NF). The paradigm that satisfies the minimum requirement is the first paradigm (1NF). To further meet the basis of the first paradigm more requirements are called the second paradigm (2NF), the paradigm and so on. Generally speaking, the database needs only to satisfy the third paradigm (3NF). Next we present examples of the first paradigm (1NF), the second paradigm (2NF) and the third paradigm (3NF). 3.4.1 first paradigm (1NF) In any relational database, the first paradigm (1NF) is the basic requirement for relational schema, and the database that does not satisfy the first normal form (1NF) is not a relational database. The first paradigm (1NF) refers to a database table for each column are the basic data items can not be divided, not in the same column with multiple values, a property cannot have more than one value in the entity or not duplicate property. If duplicate attributes are present, you may need to define a new entity, which consists of repeated attributes that are one to many relationships between the new entity and the original entity. In the first paradigm (1NF), each line of the table contains only one instance of information. For example, the employee information table in Figure 3-2, not employee information is placed in a column display, nor will the two or more columns in a column where the employee information display; each row of the table represents only an emp