Designing a Sales Invoice Table and Applying Normalization
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 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.