The system development team at the XYZ 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
1) State the rule that is applied to place an entity in first normal form. Revise this data model so that it is in first normal form.
2) State the rule that is applied to place an entity into second normal form. Revise the data model (if necessary) to place it in second normal form.