数据库设计范式（Database design paradigm）.docVIP

数据库设计范式（Database design paradigm） Database design paradigm Schema outline for database design The first paradigm For each row in the table, you must have only unique line values. Each column in a row has only unique values and is atomic Second normal form The second paradigm requires that the non primary key column be a subset of the primary key, and that the non primary key column activity must depend entirely on the primary key. A primary key must have unique elements, and a primary key can consist of one or more columns that make up unique values. Once created, the primary key cannot be changed, and the foreign key relates to the primary key of a table. The main foreign key association means a one to many relationship Third normal form The third paradigm requires non primary key columns to be independent of each other Fourth normal form The fourth paradigm prohibits primary key columns and non primary key columns, and one to many relationships are not bound Fifth normal form The fifth paradigm divides the table into blocks that are as small as possible, in order to exclude all redundancies in the table Relational databases are designed to conform to certain rules. In particular, the database design paradigm is a brief introduction to 1NF (first paradigm), 2NF (second paradigm), 3NF (third paradigm) and BCNF, and fourth paradigms and fifth paradigms for later introduction. When you design the database, if you can meet these paradigms, you are a master of database design. First paradigm (1NF): in each specific relation R in relational schema R, if each attribute value is the smallest data unit that can not be subdivided, then R is called the first normal form relation. Example: if the employee number, name, phone number to form a table (a person may have an office phone and a home phone number), the specification becomes 1NF, there are three ways: First, repeat the number and name of the worker. In this case, the keyword can only be the phone number. Two is worker