Purchase Solution

Normalize a Table: Sales Invoice Information

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 solution is for a specific given problem of sales invoice. A single table is given as part of the question. The solution explains and show steps how to normalize the given sales table into third normal form.

Solution Preview

Normalization of a table refers to accessing and modifying a table so that there is no redundant information in the table and the organization of the data inside the table is maintained in such a way that any kind of data management and/or future modifications of the structure of the table becomes simpler.

The following steps show the different steps of normalization on the given set of information fields.

First Normal Form:

A relation R is in first normal form if and only if all underlying domains contain atomic values only. A table is considered to be at first normal form when each field contains the smallest meaningful data and the table contains ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Motivation

This tests some key elements of major motivation theories.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.