Hour 4. The Normalization Process In this hour, you learn the process of taking a raw database and breaking it into logical units called tables. This process is referred to as normalization . The normalization process is used by database developers to design datsabases in which it is easy to organize and manage data while ensuring the accuracy of data throughout the database. The advantages and disadvantages of both normalization and denormalization of a database are discussed, as well as data integrity versus performance issues that pertain to normalization. The highlights of this hour include -
What normalization is -
Benefits of normalization -
Advantages of denormalization -
Normalization techniques -
Guidelines of normalization -
The three normal forms -
Database design |