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 class and its attributes:

a. State the rule that is applied to place a class in first normal form. Based on the above class, create a class diagram that will be in 1NF.

b. State the rule that is applied to place a class into second normal form. Revise the class diagram for the Wilcon Company using the class and attributes described (if necessary) to place it in 2NF.

c. State the rule that is applied to place a class into third normal form. Revise the class diagram to place it in 3NF.

d. When planning for the physical design of this database, can you identify any likely situations where the project team might choose to denormalize the class diagram? After going through the work of normalizing, why would this be considered?

Transcribed Image Text:

Inventory Order Order Number (PK) 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