Several paradigms of database

Source: Internet
Author: User

1NF: All fields in the first normal form table contain only single values.

2NF: Each non-key field in the second Paradigm table is determined by the entire primary key and cannot be determined by a part of the primary key itself

3NF: Non-key fields that can determine other non-key fields do not exist in the third Paradigm table

BCNF Paradigm: Each determination factor is a key

4NF Fourth normal form: In the primary key table, a part of the key can determine multiple values for at most one other field.

Several paradigms of 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.