Preparatory Instructions:

Please be sure to read Chapter 6 – Data Modeling (pp 187 – 213, Systems Analysis & Design text).

Entity Relationship Diagrams (known as ERDs) depict the data that will be used and created in a system and provides business requirements details such as the type and amount of each data element as well as the relationships between data entities.

This week we will practice creating ERDs. You will find that ERDs are very commonly used and can be a critical tool used during requirements analysis and design phases.

Objectives:

This week’s assignment is to apply each Normalization rule to the Inventory Order model to reach the 3rd 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 3rd Normal form.

Apply first normal form rules and provide result as 1st normal form. Provide a brief description of what was applied to reach 1st normal form as well as the model in 1st normal form.
Apply second normal form rules and provide result as 2nd normal form. Provide a brief description of what was applied to reach 2nd normal form as well as the model in 2nd normal form.
Apply third normal form and provide result as 3rd normal form. Provide a brief description of what was applied to reach 3rd normal form as well as the model in 3rd normal form.
Submit your Entity Relationship Models (1st thru 3rd normal form) as Visio, Word or image files to Canvas

Last Completed Projects