Objectives:

This week's assignment is to apply each Normalization rule to the Inventory Order model to reach the 3^rd Normal Form.

The system development team at the Wilcon Company is working on developing a new customer order entry system. In the process of designing the new system, the team has identified the following data entity attributes:

Inventory Order

• Order Number (identifier)
• Order Date
• Customer Name
• Street Address
• City
• State
• Zip
• Customer Type
• Initials
• District Number
• Region Number

1 to 22 occurrences of:

• Item Name
• Quantity Ordered
• Item Unit
• Quantity Shipped
• Item Out
• Quantity Received

Example:

Entity Relationship Diagram for Music CD Information

Deliverables:

Apply each normalization rule in order (1 to 3) to reach the 3^rd Normal form. Review the demonstration in the video for help on getting started.

1. Apply first normal form rules and provide result as 1^st normal form. Provide a brief description of what was applied to reach 1^st normal form as well as the model in 1^st normal form.
2. Apply second normal form rules and provide result as 2^nd normal form. Provide a brief description of what was applied to reach 2^nd normal form as well as the model in 2^nd normal form.
3. Apply third normal form and provide result as 3^rd normal form. Provide a brief description of what was applied to reach 3^rd normal form as well as the model in 3^rd normal form.