Purchase Solution

Sales Invoice Normalisation

Not what you're looking for?

Ask Custom Question

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

A word document file containing the answer to the given question. It show step by step instructions on how to design a table to store an invoice information provided in the question, and to bring the table from its first normal form into third normal form. The solution also identifies the primary keys and the foreign keys, marked as bold in the attached document.

Purchase this Solution
Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Introduction to Finance

This quiz test introductory finance topics.

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.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

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

  • NORMALISATION

    21897 NORMALISATION Transform the following entities into 3NF entities. Draw the original and final data models, and state any reasonable assumptions.

  • Account Receivable-Gross method and Net Method of recording sales discount.

    104336 Account Receivable-Gross method and Net Method of recording sales discount. Explain Gross method and Net method of recording sales discount allowed to account receivables.

  • Bottom-up vs Top-down Database Design

    This method is characterised by normal forms, or de-composition using normalisation theory. Normalisation arranges relationships into appropriate forms using decompositions (Lewis et.al, 2001).

  • Sales Journal - perpetual

    SALES JOURNAL Date Account Debited Invoice Number PR Accounts Receivable Dr. Sales Cr. Cost of Goods Sold Dr. Inventory Cr. Mar. 7 J. Dryer 5704 1,150 800 12 R. Land 5705 320 200 25 T.

  • The Blue Moon Motel

    The invoice includes the price of the computer, the sales tax, and maintenance.

  • Designing a Sales Invoice Table and Applying Normalization

    498261 Designing a Sales Invoice Table and Applying Normalization Consider a typical sales invoice that would include the following information.

  • Auditing and Assurance Services

    (1) Pre-numbered sales invoices in a sales journal where the lowest invoice number is 1 and the highest is 6211. As the pre-numbered sales invoices start from 1 and reach 6211, I divided 6211 by 50 since we require 50 items. I got 124.22.

  • Journalize Hutton Company Transactions

    Burton for $550, terms n_30, invoice no. 5706. Prepare headings for a sales journal. Journalize the March transactions that should be recorded in this sales journal. Thanks for using BrainMass.com. Have a great day.

View More Related Solutions