What are the three paradigms of the database?

Source: Internet
Author: User

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?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.