Quiz Complete, well Done!
What is the purpose of a primary key in a database table?
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.
What is the main goal of normalizing a database?
1st Normal Form
The third normal form is about removing
dependencies between columns.
In 2nd normal form (2NF) a table should first satisfy which normal form?
Primary Key
A key attribute in achieving the first normal form is to eliminate
groups of data.
Dependency
What is a candidate key in a relation?
The second normal form is about ensuring that each non-key column is fully functionally dependent on the
.
Atomic Values
What is the first normal form (1NF)?
Normalization
The first normal form is about ensuring each column contains only
values.
3rd Normal Form
A relation that is in 2nd normal form (2NF) is automatically in which normal form?
2nd Normal Form
Second normal form is important as it helps in splitting data into
tables to avoid redundancy.
