Kenneth C. Laudon,Jane P. Laudon Management Information System 12th Edition pdf

normalization

.

Figures 6-9 and 6-10 illustrate this process. 

In the particular business modeled here, an order can have more than one

part but each part is provided by only one supplier. If we build a relation called

ORDER with all the fields included here, we would have to repeat the name and

address of the supplier for every part on the order, even though the order is for

parts from a single supplier. This relationship contains what are called repeating

data groups because there can be many parts on a single order to a given

supplier. A more efficient way to arrange the data is to break down ORDER into

smaller relations, each of which describes a single entity. If we go step by step

and normalize the relation ORDER, we emerge with the relations illustrated in

Figure 6-10. You can find out more about normalization, entity-relationship

diagramming, and database design in the Learning Tracks for this chapter.

Relational database systems try to enforce