Relationships in relational databases require certain requirements, and meet different levels of requirements for different paradigms.
The paradigm is the downward one, that satisfies the second paradigm that must satisfy the first paradigm.
The first paradigm (1NF): satisfies the most demanding called the first paradigm. The first paradigm requires that all fields have meaning, are atomic, and can no longer be divided. For example, last name and first name, can not be divided.
Second paradigm (2NF): In a database table, each tuple (that is, each row of records) must be uniquely differentiated, i.e. the table must have a primary key or primary key.
Third normal form (3NF): Requires a database table that does not contain the contained non-primary key information that is already in the other table. For example, in the student table, there should be only the class ID, not the class name, because the class table already has a non-primary keyword class name.
In the database design, there are bcnf, the third paradigm, the fourth paradigm and the fifth paradigm.
In the database design, try to satisfy the third paradigm. The general design of the database is that, according to the conceptual model, the corresponding tables and fields, according to the paradigm requirements, remove redundant fields and dependencies, at least meet the requirements of the third paradigm, but according to performance and development convenience, local adjustment database table structure, do some redundant fields.
What are the three paradigms of the database?