Database Normalization Flashcards
(16 cards)
Eliminates independent many-to-one relationships between columns
Fourth Normal Form
Place all items that appear in the repeating group in a new table.
First Normal Form (1NF)
when there can be no insertion or deletion anomalies in the database.
Domain Key Form
Does not allow dependencies between attributes that belong to candidate keys.
Boyce-Codd Normal Form (BCNF)
Move all items involved in transitive dependencies to a new entity
Third Normal Form
No attribute is transitively dependent on the primary key
Third Normal Form
The table has two or more candidate keys
Boyce-Codd Normal Form (BCNF)
This form dictates that all non-key attributes of a table must be functionally dependent on a candidate key i.e. there can be no interdependencies among non-key attributes.
Third Normal Form
Involves restructuring the tables to successively meeting higher forms of Normalization.
Database Normalization
A give relation may not contain more than one multi-values attribute.
Fourth Normal Form
A table is considered this form if all the fields contains scalar values
First Normal Form (1NF)
The process which allows you to winnow out redundant data within your database
Database Normalization
All non-key attributes in the table must be functionally dependent on the entire primary key
Second Normal Form
Duplicate in the new table the primary key of the table from which the repeating group was extracted or vice versa.
First Normal Form (1NF)
Is satisfied when all tables are broken into as many tables a possible in order to avoid redundancy. It cannot be broken into smaller relations without changing the facts or the meaning.
Fifth Normal Form
Place the primary key for the new entity as a foreign key on the original entity
Third Normal Form
