DATABASE DESIGN 1: NORMALIZATION - Concepts of Database Management - page 171

There is another decomposition that you might choose, and that is to replace

Customer (CustomerNum, CustomerName, Balance, CreditLimit, RepNum, LastName, FirstName)

with

Customer (CustomerNum, CustomerName, Balance, CreditLimit, LastName, FirstName)
Rep (RepNum, LastName, FirstName)

171

Samples of these tables appear in Figure 5-14.

Customer

CustomerNum CustomerName Balance CreditLimit RepNum LastName FirstName

148 Al's Appliance $6,550.00 $7,500.00 20 Kaiser Valerie

and Sport

282 Brookings Direct $431.50 $10,000.00 35 Hull Richard

356 Ferguson's $5,785.00 $7,500.00

$5,000.00

65 Perez Juan

408 The Everything $5,285.25 35 Hull Richard

Shop

462 Bargains Galore $3,412.00 $10,000.00 65

20

Perez Juan

524 Kline's $12,762.00 $15,000.00 Kaiser Valerie

608 Johnson's $2,106.00 $10,000.00 65 Perez Juan

Department
Store

687 Lee's Sport $2,851.00 $5,000.00 35 Hull Richard

and Appliance

725 Deerield's $248.00 $7,500.00 35 Hull Richard

Four Seasons

842 All Season $8,221.00 $7,500.00 20 Kaiser Valerie

Customer Rep

CustomerNum CustomerName Balance CreditLimit LastName FirstName RepNum LastName FirstName

20 148 Al's Appliance $6,550.00 $7,500.00 Kaiser Valerie Kaiser Valerie

and Sport

35 Hull Richard

282 Brookings Direct $431.50 $10,000.00 Hull Richard

65 Perez Juan

356 Ferguson's $5,785.00 $7,500.00 Perez Juan

408 The Everything $5,285.25 $5,000.00 Hull Richard

Shop

462 Bargains Galore $3,412.00 $10,000.00 Perez Juan

524 Kline's $12,762.00 $15,000.00 Kaiser Valerie

608 Johnson's $2,106.00 $10,000.00 Perez Juan

Department Store

687 Lee's Sport $2,851.00 $5,000.00 Hull Richard

and Appliance

725 Deerield's $248.00 $7,500.00 Hull Richard

Four Seasons

842 All Season $8,221.00 $7,500.00 Kaiser Valerie

FIGURE 5-14 Second incorrect decomposition of the Customer table