Question: 2. The system development team at the Wilcon Com- pany is working on developing a new customer order entry system. In the process of designing

2. The system development team at the Wilcon Com- pany 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 nec- essary) 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

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Systems Analysis And Design Using MATLAB Questions!

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...

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 class...

2 . What is your response to the director of operations? a . Why do we perform data modeling? b . Is there any benefit to developing a data model of the current system at all? c . How does the...

Only do D,no need to do A,B ,and C MINICASES 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,...

QUESION 1:) A:)- Draw an entity relationship diagram (ERD) for the following situations: 1. Whenever new patients are seen for the rst time, they complete a patient information form that asks their...

MINICASES 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...

Objectives: This week's assignment is to apply each Normalization rule to the Inventory Order model to reach the 3 rd Normal Form. The system development team at the Wilcon Company is working on...

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...

A firm is experiencing a temporary period of financial distress as the result of a hurricane that has hit its local area. Because many of the firms customers have been severely hurt by the hurricane,...

Provide the Liquidation Statement for each cases and their Journal Entries. Attach on the picture are the format for the Liquidation Report and General Journal. Anita, Banana and Carla are partners...

Mr . Marina has called on you to conduct a systems survey of this situation. You are to assume that a request for systems development has been prepared and approved. The information system at TM...

Consider the assignment problem having the following cost table. (a) Draw the network representation of this assignment problem. (b) Formulate this problem as a transportation problem by constructing...