Reference no: EM131486143

Senior systems analysis and design

The data inputs and outputs must be taken from the DFDs. The data storage files are taken from the case narrative, since the DFDs do not include data stores. The software must be subdivided in terms of its major functions (input, processing, output, and storage). Complete the following assignment:

• Mini Case #2 on page 211 of your textbook.
• Your assignment should be at least 2 full pages.

Mini case#2

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

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.
3. 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.
4. What other guidelines and rules can you follow to validate that your data model is in good form?