Make a single table to hold all of the information

Assignment Help Computer Engineering

Reference no: EM1335928

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing the original and final tables. Include a short summary (2-3 paragraphs) of the problems with the original single table design and how normalization improved the design.
Orders:
? Order_id
? Order_date
? Customer_id
? Customer_name
? Customer_address
? Customer_city
? Customer_state
? Item_id
? Item_description
? Item_qty
? Item_price
? Item_total_price
? Order_total_price

Please consider the following functional dependencies (FDs):
Order_Id -> Customer_id, Order_date, Order_total_price
Item_Id, Order_Id -> Item_Qty, Item_total_price, Item_description, Item_Price
Customer_id -> Customer_Name, Customer_Address, Customer_City, Customer_State
Item_Id -> Item_description, Item_price
You will use these FDs as you analyze the table for normalization.
Also, we do not want to loose any information (e.g. Order_total_price is potential derivable from other pieces of data, we want that field to show up in one of the resulting tables).

Reference no: EM1335928

Questions Cloud

Restructuring a diversified company''s business : Restructuring a diversified company's business lineup involves?

Description of victims'' rights : Provide a historical description of Victims' Rights and explain how Victims' Rights are considered today?

Illustrate what happens to the money supply : Illustrate what happens to the money supply, interest rates, and the economy in general if the Federal Reserve is a NET BUYER of government bonds.

Critical importance to be managed the first year : Human Resources - Describe why each issue is of critical importance to be managed the first year

Make a single table to hold all of the information : discuss a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information.

The major mistakes a firm can make during the transition : Write the major mistakes a firm can make during the transition industry maturity.

Manage project scope throughout project life cycle : Separate tasks into sub-tasks, and a work package with stated durations and order of precedence. Manage project scope throughout the project life cycle.

Explain why does the government support public : Explain why does the government support public education when the private sector also provides this service.

Show the international hrm : Find different and common classifications of employees when talking about International HRM and why a company might hire one type over another type

User Account

All Pages