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