$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 process model help us develop the data model?

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

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?