According to Nipun Tomar, writing in his article "Normalization and its Types," [www.c-sharpcorner.com/uploadfileipuntomarormalization-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.

Field Un-Normalized Coyote Tools Ltd. Sales Database Size 8 4 4 30 8 2 30 (length) Date Invoice Product Number Number Unit QTY Customer Description Price Sold Name 05/11/21 4001 T769 Drill Bit 6.00 12 05/11/21 4001 05/11/21 4002 Y143 Drill 45.00 6 McGregor Tool McGregor Tool E349 Saw 39.00 10 Imes Construction Total file size 148 N Bytes 62 Customer Address 123 Main Street, Braintree, MA, 02184-1008 123 Main Street, Braintree, MA, 02184-1008 12 Ocean Rd., Providence, RI, 02906-1103