Purchase Solution

Designing a Sales Invoice Table and Applying Normalization

Not what you're looking for?

Ask Custom Question

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 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

Purchase this Solution
Solution Summary

The solutions contains a detailed step by step instruction on how to normalize the given sales invoice table. A word document file containing the solution is provided.

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

View More Free Quizzes
Related BrainMass Solutions

  • Sales Invoice Normalisation

    506097 Sales Invoice Normalisation Consider a typical sales invoice that would include the information below. Design a single table to hold all of the information required to store an invoice including this information.

  • Database Normalization

    129583 Database Normalization 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.

  • Normalize a Table: Sales Invoice Information

    509753 Normalize a Table: Sales Invoice Information 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.

  • Normalization

    Design a single table to hold all the information required to store a job order including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing your original and final tables.

  • Improving Table Designs Using Normalization.

    500907 Improving Table Designs Using Normalization. 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.

  • functional dependencies

    For a given invoice (identified by the InvoiceNum), there will be a single customer. The customer's number, name, and complete address appear on invoice, as does the date. Also, there may be several different parts appearing on the invoice.

  • Normalization Techniques a Database

    Normalization is a process of reducing redundancies of data in a database; it has its disadvantages like everything else, but seems to have more benefits. Normalization is a technique that is used when designing and redesigning a database.

  • Domain/Key Normal Form

    One sales person could be involved with many Invoice records but one Invoice is handled by only one sales person. In this case Invoice table will store FK to Sales Person table. 3) 'Invoice' to 'Line Items' relationship is 1:M.

  • Discussing the Concept of Normalization

    Normalization usually involves dividing a database into two or more tables and defining relationships between the tables.

View More Related Solutions