Developing a new customer order entry system

Assignment Help Computer Engineering

Reference no: EM131182189

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 (identi?er)
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

Reference no: EM131182189

Questions Cloud

What type of relationship is involved : Are there common activities involved when a person either leases or buys an automobile - What type of relationship is between an employee who is a manager or one who is a sales person?

Identify root cause of problem : Per the textbook, in order to understand the causal relationship in business process, manager often asks "whys" to drill down the root cause of failures. Select one (1) project from your working or educational environment and propose at least thre..

Develop strategy to advance your career using your strengths : Explain why you agree or disagree with your results. Develop strategies to advance your career using your strengths. How can you use goal-setting to increase motivation and improve job performance?

Standard deviations is the data value from the mean : A given data value has a Z-value equal to 1.2. Assuming a normal (i.e., symmetrical) continuous probability distribution, how many standard deviations is the data value from the mean?

Developing a new customer order entry system : 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.

How the ups facilitates the passage of its customers goods : Discuss how the UPS facilitates the passage of its customers' goods through customs, and helps them comply with other trade restrictions. Make full use of relevant sources.

Planning strategies for effective classroom management : Interview a teacher of students with LD. Discuss skills necessary in organizing and planning strategies for effective classroom management, including: grouping scheduling lesson plans homework strategies record keeping selecting instructional mate..

Determine the slope of each of the line : the system of equations under what conditions on the coefficients can we be guaranteed a unique solution?

How much of the variation is explained by diversity : Population Variation = 84.4-0.13×diversity. How much of the variation is explained by diversity? How much of the variation is explained by diversity?

User Account

All Pages