Explore tens of thousands of sets crafted by our community.
Database Normalization Forms
5
Flashcards
0/5
First Normal Form (1NF)
A table is in First Normal Form when it contains only atomic (indivisible) values and each entry in the table is unique.
Second Normal Form (2NF)
To be in Second Normal Form, a table must first satisfy all the requirements of 1NF. In addition, all non-key attributes must be fully functionally dependent on the entire primary key.
Third Normal Form (3NF)
A table is in Third Normal Form if it is in 2NF and all the attributes in the table are not transitively dependent on the primary key.
Boyce-Codd Normal Form (BCNF)
A table is in Boyce-Codd Normal Form if it is in 3NF and for every one of its non-trivial functional dependencies, X -> Y, X is a superkey.
Fourth Normal Form (4NF)
A table is in Fourth Normal Form if it is in BCNF and it does not have any multi-valued dependencies.
© Hypatia.Tech. 2024 All rights reserved.
