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. Revise this data model so that it is in first normal form.
b. 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.
c. 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.
d. What other guidelines and rules can you follow to validate that your data model is in good form?
Step by Step Solution
3.48 Rating (171 Votes )
There are 3 Steps involved in it
a The rule for first normal form is to remove any attributes or groups of attributes that occur more than once for a single occurrence of the entity T... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
237-C-S-S-A-D (753).docx
120 KBs Word File
Study Help