Normalization

• A process used to organize a database into tables and columns.
• There are 3 reasons to normalize a database:
  1. To minimize duplicate data.
  2. To minimize data modification issues.
  3. To simplify queries
• Duplicate information increases storage, decreases performance, and makes it difficult to maintain data changes. First Normal Form: The information is stored in a relation table with each column containing atomic values. there are no repeating groups or columns Second Normal Form: The table is in first normal form and all the columns depend on the tables primary key. Third Normal Form: The table is in second normal form and all of its columns are not transitively dependent on the primary key.