Explore tens of thousands of sets crafted by our community.
Database Normalization Forms
5
Flashcards
0/5
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.
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.
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.
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.
© Hypatia.Tech. 2024 All rights reserved.
