Purchase Solution

Database 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 (2-3 paragraphs) 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

Please consider the following functional dependencies (FDs):
Order_Id -> Customer_id, Order_date, Order_total_price
Item_Id, Order_Id -> Item_Qty, Item_total_price, Item_description, Item_Price
Customer_id -> Customer_Name, Customer_Address, Customer_City, Customer_State
Item_Id -> Item_description, Item_price
You will use these FDs as you analyze the table for normalization.
Also, we do not want to loose any information (e.g. Order_total_price is potential derivable from other pieces of data, we want that field to show up in one of the resulting tables).

Purchase this Solution

Solution Summary

This solution clearly explains Database Normalization concepts using an example.

Solution Preview

The above columns can be divided into 4 tables of each in 3 NF as shown below. Check the attached document for ...

Purchase this Solution


Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Basic Networking Questions

This quiz consists of some basic networking questions.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.