(Solved): text : The project team has developed a logical process model of the current system. This model h ...

text :

The project team has developed a logical process model of the current system. This model has been carefully checked for syntax errors. Last week, the team invited a number of system users to role-play the various data flow diagrams, and the diagrams were refined to the users' satisfaction. Right now, the project manager feels confident that the as-is system has been adequately represented in the process model.
The director of operations for West Star is the sponsor of this project. He sat in on the role-playing of the process model and was very pleased by the thorough job the team had done in developing the model. He made it clear to you, the project manager, that he was anxious to see your team begin work on the process model for the to-be system. He was a little skeptical that it was necessary for your team to spend any time modeling the current system in the first place, but grudgingly admitted that the team really seemed to under- stand the business after going through that work.
The methodology that you are following, however, specifies that the team should now turn its attention to developing the logical data model for the as-is system. When you stated this to the project sponsor, he seemed confused and a little irritated. "You are going to spend even more time looking at the current system? I thought you were done with that! Why is this necessary? I want to see some progress on the way things will work in the future!"
The system development team at the Wilcon Company is working on developing a new customer order entry system. In the process data entity attributes: of designing the new system, the team has identified the following
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
196
DATA MODELING
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?