Question
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
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 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 a. State the rule that is applied to place an entity in first normal form. Describe how the data would change when in first normal form. b. State the rule that is applied to place an entity into second normal form. Describe how the data would change when in second normal form. c. State the rule that is applied to place an entity into third normal form. Describe how the data would change when in third normal form. d. What other guidelines and rules can you follow to validate that your data model is in good form?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started