|
|
In this appendix, we demystified the concepts of normalization, the process of optimizing database tables to avoid redundancy and waste of space that may affect read and write procedures and result in bad performance.
The normalization process has three main forms:
The First Normal Form eliminates repetition and attempts to create a table for each entity type.
The Second Normal Form removes the functional dependency of any column on part of a composite primary key.
The Third Normal Form removes the functional dependency of any column on any other non-key column.
|
|