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$.$