Reference no: EM13949902
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).
|
Age-dependent diseases and age-related diseases
: Distinguish between age-dependent diseases and age-related diseases.
|
|
Find the irr of a project that returns
: Find the IRR of a project that returns $17,000 three years from now if it costs $12,000.
|
|
Problem regarding the ideal gas model
: At steady state, air at 200 kPa, 528C and a mass flow rate of 0.5 kg/s enters an insulated duct having differing inlet and exit cross-sectional areas. At the duct exit, the pressure of the air is 100 kPa, the velocity is 255 m/s, and the cross-sec..
|
|
Determine cost of goods sold
: Using the information given, determine the following missing amounts: Cost of goods sold, Finished goods inventory at the end of the month and Direct material cost
|
|
Prepare a word document showing the original and final table
: 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 no..
|
|
President johnson suffer a credibility gap
: Why did President Johnson suffer a "credibility gap" concerning the Vietnam War? (200 Words)
|
|
Steady state inlet and exit velocities
: Air at 600 kPa, 330 K enters a well-insulated, horizontal pipe having a diameter of 1.2 cm and exits at 120 kPa, 300 K. Applying the ideal gas model for air, determine at steady state (a) the inlet and exit velocities, each in m/s, (b) the mass fl..
|
|
Describe for the students the primary objectives
: Describe for the students the primary objectives of accounting.
|
|
Why wont this query return any results?
: Why wont this query return any results?
|