week 1

Associate Level Material

Week One—Normalization Worksheet

1. Explain the purpose of data normalization.

2. Using the attached Excel® spreadsheet, develop a simple entity relationship diagram (ERD) of sales and operational data normalized to the fifth normal form. Copy and paste your ERD into the space provided below. The ERD may be created using Microsoft® Word® or Microsoft® PowerPoint® before it is pasted into this worksheet.