Normalize a Table: Sales Invoice Information
Not what you're looking for?
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.