123范式（123 paradigm）.docVIP

123范式（123 paradigm） In the process of creating a database, according to certain standards, these standards are called paradigm, from the first to sixth a total of six general database design paradigm, as long as we follow the first second and third paradigm, paradigm, paradigm is enough. Databases that meet these specifications are concise and structured, without the exception of insert, delete, and update (update) operations. It is out of order, not only to the database programmers to make trouble, and hateful appearance may be stored, a lot of redundant information. Reading object Best understanding of the basic knowledge of relational databases People who want to work in software development Introduction to I and relational database design paradigm 1.1, the first paradigm (1NF) has no duplicate columns 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. In short, the first paradigm is the column without repetition. Explanation: 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 1.2 second paradigm (2NF) attribute is entirely dependent on the primary key The second paradigm (2NF) is established on the basis of the first paradigm (1NF), i.e., satisfying the second paradigm (2NF) must first satisfy the first normal form (1NF). The second paradigm (2NF) requires that each instance or row in the database table must be uniquely divided. To make a dis