Database Reference
In-Depth Information
Customer
CustomerNum CustomerName
Street
City
State
Zip
Balance
CreditLimit
RepNum
148
Al's Appliance
2837 Greenway
Fillmore
FL
33336
$6,550.00
$7,500.00
20
and Sport
282
Brookings
3827 Devon
Grove
FL
33321
$431.50
$10,000.00
35
Direct
356
Ferguson's
382 Wildwood
Northield
FL
33146
$5,785.00
$7,500.00
65
408
The Everything
1828 Raven
Crystal
FL
33503
$5,285.25
$5,000.00
35
Shop
462
Bargains Galore
3829 Central
Grove
FL
33321
$3,412.00
$10,000.00
65
271
524
Kline's
838 Ridgeland
Fillmore
FL
33336
$12,762.00
$15,000.00
20
608
Johnson's
372 Oxford
Sheldon
FL
33553
$2,106.00
$10,000.00
65
Department
Store
687
Lee's Sport and
282 Evergreen
Altonville
FL
32543
$2,851.00
$5,000.00
35
Appliance
725
Deerield's
282 Columbia
Sheldon
FL
33553
$248.00
$7,500.00
35
Four Seasons
842
All Season
28 Lakeview
Grove
FL
33321
$8,221.00
$7,500.00
20
FIGURE 8-10
Customer table for Premiere Products
If some users access address data from the Customer table and other users access balances and credit
limits, the DBA can split the Customer table into two tables, as shown in Figure 8-11, to improve perfor-
mance. Users needing data from both tables can obtain that data by joining the two split tables on the
CustomerNum field.
