Quiz Complete, well Done!
What is a candidate key in a relation?
A relation that is in 2nd normal form (2NF) is automatically in which normal form?
Dependency
The third normal form is about removing
dependencies between columns.
1st Normal Form
The second normal form is about ensuring that each non-key column is fully functionally dependent on the
.
A key attribute in achieving the first normal form is to eliminate
groups of data.
Data Redundancy
The first normal form is about ensuring each column contains only
values.
Primary Key
Normalization
What is the purpose of a primary key in a database table?
2nd Normal Form
3rd Normal Form
What is the purpose of the third normal form (3NF)?
A table in first normal form does not contain any repeating groups or
of data.
In 2nd normal form (2NF) a table should first satisfy which normal form?
What is the main goal of normalizing a database?
Atomic Values
What is the first normal form (1NF)?