Module 3 - SLP Normalization and SQL DDL Statements Name Trident University Date After identifying the preliminary design of the table, I normalized the database to structure the tables. Since there is a need to update and create new records normalizing the database will improve the database. Under the 1NF (first normal form) the cells in the table contained one value, while the 2NF highlights the attributes being directly dependent on the primary key (Allen & Terry, 2005). Since there is emphasis on removing the redundancies in the inventory and sales data the modified data has eliminated deficiencies. Using the 3NF the non-key column is independent of the other columns and the normalization process then r
...
