Purchase Solution

Custom order entry system

Not what you're looking for?

Ask Custom Question

The system development team at Wilson Company is working on developing a new customer order entry system. In the process on designing the new system, the team has identified the following class and its attributes:

- Inventory order
- Order number,
- Order Date
- Street address
- City
- State
- Zip
- Customer type
- Initials
- District number
- Region number
...1 to 22 occurrences of: Item Name, Quantity order, Item Unit, Quantity, Item out, Quantity Received

State the rule that is applied to place a class in first normal form revise the above class diagram so that it is in INF.

State the rule that is applied to place a class into second normal form. Create a class diagram for the Wilson
Company using the class and attributes described to place it in.

Purchase this Solution

Solution Summary

The solution discusses the custom order entry system.

Solution Preview

See the attached file.

<b>Solution</b>

Let us start with a single table with all columns in it. Let's remember that, in all tables candidate keys (also known as Primary Keys) are in BOLD

Let's call the below table OrderInfo table:

Table OrderInfo:

Order_id
Order_date
Order_Number
Customer_id
Customer_name
Customer_address
Customer_city
Customer_state
Customer_zip
Customer_type

Item_id
Item_Name
Item_qty
Item_unit
Item_out
Item_received

The following FDs (functional dependencies) hold on the above table:

Order_Id -> Customer_id, Order_date, Order_number
Item_Id, Order_Id -> Item_Name, Item_Qty, Item_Unit, Item_out, Item_received
Customer_id -> Customer_Name, Customer_Address, Customer_City, Customer_State, Customer_zip
Item_Id -> Item_name, Item_qty, Item_unit..,

Primary key of the above table is a composite candidate key Order_id and Item_id

Clearly, this table is in 1 NF, but it is not in 2NF, so obviously not in 3 NF.

The table is not in 2 NF because we have FDs with part of candidate key Order_id and Item_id and also Customer_id

So, we have to separate the fields according to the FDs and create more tables.

Hence, at first we take the FD

Customer_id -> Customer_Name, Customer_Address, Customer_City, Customer_State, ...

Then, we need to put the below fields in Customer table

Customer_id ...

Purchase this Solution


Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C# variables and classes

This quiz contains questions about C# classes and variables.