50.1K

Verified Solution

Link Copied!

The systems development project team at West Star Marinas has been hard at work on a project that eventually will link all the marina's facilities into one unified, networked system. 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 understand 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!" i. Explain your response to the director of operations. ii. Justify the importance of performing data modeling. Outline the benefits of developing a data model of the current system, if any. Describe how does the process model help in developing the data model. iv. 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 0 Item Name o Quantity Ordered 0 Item Unit O Quantity Shipped Item Out o i. ii. o Quantity Received Illustrate 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. Illustrate 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. Illustrate the rule that is applied to place an entity into third normal form. Revise the data model to place it in third normal form. Summarize the other guidelines and rules you can follow to validate that your data model is in good form. iv

Answer & Explanation Solved by verified expert

See Answer