Databases Reference
In-Depth Information
Rep
RepNum
LastName
FirstName
Street
City
State
Zip
Commission
Rate
20
Kaiser
Valerie
624 Randall
Grove
FL
33321
$20,542.50
0.05
35
Hull
Richard
532 Jackson
Sheldon
FL
33553
$39,216.00
0.07
65
Perez
Juan
1626 Taylor
Fillmore
FL
33336
$23,487.00
0.05
Access
denied
DBMS
255
Access
permitted
Sam
Part
PartNum
Description
OnHand
Class
Warehouse
Price
AT94
Iron
50
HW
3
$24.95
BV06
Home Gym
45
SG
2
$794.95
CD52
Microwave Oven
32
AP
1
$165.00
DL71
Cordless Drill
21
HW
3
$129.95
DR93
Gas Range
8
AP
2
$495.00
DW11
Washer
12
AP
3
$399.99
FD21
Stand Mixer
22
HW
3
$159.95
KL62
Dryer
12
AP
1
$349.95
KT03
Dishwasher
8
AP
3
$595.00
KV29
Treadmill
9
SG
2
$1,390.00
FIGURE 8-2
Permitted and denied access privileges for Sam
Paige, whose responsibility is customer mailings at Premiere Products, clearly requires access to custom-
ers' names and addresses; but what about their balances or credit limits? Should she be able to change an
address? Should she be able to retrieve customers' balances or credit limits? Figure 8-3 illustrates the permit-
ted and denied access privileges for Paige.
