Only do D,no need to do A,B ,and C

MINICASES 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: I. Quantity Ordered Item Unit Quantity Shipped Item Out Quantity Received 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 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 data base, can you identify any likely situations where the project team might choose to denormalize the Item Name