Creating a single table to hold the information

Assignment Help Data Structure & Algorithms

Reference no: EM1380297

Think about a typical sales invoice that would include the given information. Create a single table to hold all of the information needed 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: EM1380297

Questions Cloud

List a professional value that is important to you : List a professional value that is important to you. Then, list an alternative to your value (i.e., How would someone else disagree or have a different perspective).

Question about data model : Create a simple data model that outlines a database management system. This model requires to track people's participation in several fitness activities at a fitness center.

Normalized relations for a database : Suppose that a information communications network links a computer at corporate headquarters with a computer in each retail outlet. The chain includes fifty stores with an average of 75 workers per store.

Fire in a bangladesh garment factory : CASE STUDY - FIRE IN A BANGLADESH GARMENT FACTORY -What would you advise your staff to do when faced with local expectations of "payoffs" and bribery?

Creating a single table to hold the information : Think about a typical sales invoice that would include the given information. Create a single table to hold all of the information needed to store an invoice including this information.

Creating an idef1x diagram : Construct an IDEF1X diagram that demonstrate only entities and relationships. Name each relationship and specify its cardinalities.

Detailed strategies to recruit : What are the qualifications of a trained Mechanical Engineer and what selection methods are best to assess whether or not an applicant meets or exceeds those qualifications

Create an idef1x entity relationships diagram : The Metropolitan Housing Agency is a non profit corporation that advocates the development and improvement of low income housing.

Separate inventory database : A 20-year old corporation, SewWorld, comprised of 6-locations in three states, sells sewing machines, sewing related software, and accessories. Each store sells between 3-5 different brands of sewing equipments.

User Account

All Pages