Lesson 9
Relational Database Review
In this module, you learned the difference between
You also learned what normalization is and saw an example of how to normalize a table. Now you should be able to normalize your own tables.
Normalization is beneficial in many ways, but the most important reason to normalize your databases is to be able to update changes in one location and have those changes reflected throughout the entire system.
This module has shown how tables are related in a database system like those that support SQL. Since these systems are relational, it's important to understand how table relationships are organized. In the case of the overall project for this course, you will apply this approach in determining the way you will get the customer and Green Snarfle Widget information from the database.
- relational and
- flat file databases
You also learned what normalization is and saw an example of how to normalize a table. Now you should be able to normalize your own tables.
Normalization is beneficial in many ways, but the most important reason to normalize your databases is to be able to update changes in one location and have those changes reflected throughout the entire system.
This module has shown how tables are related in a database system like those that support SQL. Since these systems are relational, it's important to understand how table relationships are organized. In the case of the overall project for this course, you will apply this approach in determining the way you will get the customer and Green Snarfle Widget information from the database.
