Purchase Solution

An explanation of database normalization with and example

Not what you're looking for?

Ask Custom Question

1. What is normalization? Why is it important?

2. What is functional dependency?

3. Why is this table NOT in First Normal Form (1NF) normalization? What can you do to put it in 1NF?

ORDERS
OrderNum OrderDate PartNum NumOrdered
21608 10/20/2007 AT94 11
21617 10/23/2007 BV06 2
CD52 4
21619 10/25/2007 DR93 1

Purchase this Solution

Solution Summary

This solution explains what database normalization is and provides an example.

Solution Preview

Database normalization is the process of modifying the database schema (structure) to improve efficiency when doing general queries against the database. Normalization also eliminates bad or difficult database issues that make it difficult to find data in a database. For example, one normalization rule says that every row in a database table must have a unique key that identifies that row. This ensures that it is possible to efficiently retrieve data based on that key. Consider if a table of employees used the employee last name as the key. If there are two employees named Mary Smith and Jane Smith then it will not be possible to identify each ...

Purchase this Solution


Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

C# variables and classes

This quiz contains questions about C# classes and variables.

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.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.