According to Nipun Tomar, writing in his article "Normalization and its Types," [www.c-sharpcorner.com/uploadfile/nipuntomar/normalization-and-its-types], normalization is the process of organizing data into a related table; it also eliminates redundancy and increases the integrity which improves performance of the query. To normalize a database, we divide the database into tables and establish relationships between the tables.

 

Database normalization can essentially be defined as the practice of optimizing table structures. Optimization is accomplished as a result of a thorough investigation of the various pieces of data that will be stored within the database, in particular concentrating upon how this data is interrelated.

 

Tasks:

 

Given the following un-normalized sales database for Coyote Tools, Ltd.

 

 

 

Using MS Word's Table feature, create  and submit the first normal form [1 NF] for this sales database.