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 following class and its attributes:

Quantity Ordered

Item Unit

Quantity Shipped

Item Out

Quantity Received

a$.$ State the rule that is applied to place a class in first

normal form. Based on the above class, create a

class diagram that will be in $1NF.$

b$.$ State the rule that is applied to place a class into

second normal form. Revise the class diagram for

the Wilcon Company using the class and attributes

described $($if necessary$)$ to place it in $2NF.$

c$.$ State the rule that is applied to place a class into

third normal form. Revise the class diagram to

place it in $3NF.$

d$.$ When planning for the physical design of this data$-$

base, can you identify any likely situations where

the project team might choose to denormalize the