ThinkerQAQ

NOTE

Database Normal Forms

1. Definition 1NF: Every attribute in a relation that conforms to 1NF cannot be further divided. 2NF: On the basis of 1NF, 2NF eliminates partial functional dependencies of non-prime attributes on a candidate key. 3NF: On the basis of 2NF, 3NF eliminates transitive functional dependencies of non-prime attributes on a candidate key. 2. Reference What Are the First, Second, and Third Normal Forms Actually Saying? - Zhihu

DatabasesCreated Updated 1 min readhistorical

This is a historical learning note and may contain outdated or incomplete understanding.

1. Definition

  • 1NF: Every attribute in a relation that conforms to 1NF cannot be further divided.
  • 2NF: On the basis of 1NF, 2NF eliminates partial functional dependencies of non-prime attributes on a candidate key.
  • 3NF: On the basis of 2NF, 3NF eliminates transitive functional dependencies of non-prime attributes on a candidate key.

2. Reference

Discussion

Sign in with GitHub to comment. Discussions are stored as GitHub Issues.View on GitHub