tem development team at the Wilcon developing a new customer order entry is working orn Company stem. lin dentified the following class and its attributes:Item Out the process of designing the new me Quantity Ordered Item Unit system, the ass and itsattribuQuantity Shipped on Inventory Order Order Number (PK) Order Date Customer Name Street Address City State Quantity Received a. State the rule that is applied to place a class in first normal form. Based on the above class, createa class diagram that will be in INF 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 Customer Type Initials District Number 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- Region Number l to 22 occurrences of base, can you identify any likely situations where the project team might choose to denormalize the Item Name