The system development team at the XYZ Company is working on developing a new cu
ID: 3827451 • Letter: T
Question
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 into third normal form. Revise the data model to place it in third normal form.
(2) What other guidelines and rules can you follow to validate that your data model is in good form?
Explanation / Answer
Storing the entity in following three tables will follow third normal form:
Customer Table
1.Customer Name
2.Stree Address
3.Customer Type Initials
4.Zip
Zip table
1.Zip
2.City
3.State
3.District Number
4.Region Number
Order Table
1.Order Number
2.Order Date
3.Customer Name
Item table
1.Item Name
2.Order Number
3.Quantity
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.