Third Normal Form
The rules for the Third Normal Form are:
-
It must meet the requirements of the Second Normal Form;
-
Any attributes that don't depend on the primary key, but instead rely on other non-key attributes, should be moved to a different table.
Sometimes, you might want to add a new attribute to a table. But doing so could bloat the table's size considerably, especially if these attributes aren't related to the primary key. Such additions are not logical!
Consider this example:
In this case, Designer Grade and Designer Country aren't really attributes of the Project. They're specific to the Designer. As in the previous example, if we were to remove the first row, we'd lose vital information about Robert Jarry's Designer Grade and Designer Country.
It's time to normalize!
Great! We now have distinct tables for each entity:
- The Project table with attributes specific to the project;
- The Designer table with attributes specific to the designer.
Thanks for your feedback!
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 8.33
Third Normal Form
Swipe to show menu
The rules for the Third Normal Form are:
-
It must meet the requirements of the Second Normal Form;
-
Any attributes that don't depend on the primary key, but instead rely on other non-key attributes, should be moved to a different table.
Sometimes, you might want to add a new attribute to a table. But doing so could bloat the table's size considerably, especially if these attributes aren't related to the primary key. Such additions are not logical!
Consider this example:
In this case, Designer Grade and Designer Country aren't really attributes of the Project. They're specific to the Designer. As in the previous example, if we were to remove the first row, we'd lose vital information about Robert Jarry's Designer Grade and Designer Country.
It's time to normalize!
Great! We now have distinct tables for each entity:
- The Project table with attributes specific to the project;
- The Designer table with attributes specific to the designer.
Thanks for your feedback!