| Lesson 5 | Normalization |
| Objective | Gain an overview of normalization. |
When you create new databases, you will often hear phrases such as
This fact is key to why a normalized database structure will be used, in most of the work you do with SQL.
When you normalize a table, you take out the duplicate information and place it in a related table. Consider the example in the next lesson.
- This database really needs to be normalized
- We need to split up these tables.
- This table needs to be dissected into component parts.
This fact is key to why a normalized database structure will be used, in most of the work you do with SQL.
When you normalize a table, you take out the duplicate information and place it in a related table. Consider the example in the next lesson.