When designing a table, the second normal form (2NF) is the level of normalization where each column in a table that is not a determiner of the contents of another column must itself be a function of the other columns in the table. At 2NF, modifications are still possible because a change to one row in a table may affect data that refers to this information from another table.
Normalization degrees of relational database tables have been defined and also include:
For More Information:
Best Web Links: Normalization
White paper: Database normalization tips
Tip: Introduction to Oracle design
Discussion forum: Talk about normalization in the Oracle Database Administration discussion forum.
Let us know if you have an idea for a quiz question topic.
This was first published in July 2003