Prepare a word document showing the original and final table

Assignment Help Database Management System
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).

Reference no: EM13949902

Questions Cloud

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?

Reviews

Write a Review

 

Database Management System Questions & Answers

  Sketch object-oriented model for private airport database

Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Discuss likely data integrity constraints on attributes

Write an SQL query to find out how many Computer Science departments are not in Victoria. Return the number -  Discuss likely data integrity constraints on attributes and specify all candidate keys and the primary key for each relation based on the..

  Granting privileges to the new user

Issue an INSERT statement to insert a new record in new user session - Login to the Oracle server using SQL Developer and write and execute the SQL command needed to create a new user with a username and password of your choosing.

  Describe technology options associated with an edms

Identify and describe the technology options and functionality associated with an EDMS. describe EHR functionality for ambulatory care facilities, considering the key clinical processes performed and data needed in such a facility.

  Baxter aviation database

ER diagram for the Baxter Aviation database

  How the design of a database can affect data quality

Evaluate how the design of a database can affect data quality. Discuss the role of a data dictionary in ensuring both the quality of enterprise-wide data and data within a specific database application.

  Design of the premiere products database

Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep but can be represented by several sales reps.

  Database for the application

After creating the correct structure of the required tables, you need to perform the following tasks to create a database for the application: 1. Create a database for the application.

  How is the logical-to-physical address mapping accomplished

If we are currently at logical block 10 (the last block accessed was block 10 ) and want to access logical block 4, how many physical blocks must be read from the disk?

  What is the purpose of a cross join in mdx

What is the purpose of a cross join in MDX? Specifically, what gets returned as the result of a cross join.

  How many of the artist works have been sold

List the names of the deceased artists and the number of years of age they were when they died (for example, an artist born in 1950 and deceased in 2001 has an age of 51).

  Create a dtd file and an xsd file that specify the schemas

Create an XML file that describes 3 product elements; each product has three sub-elements: id, name, and description.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd