Databases Reference
In-Depth Information
H
Salesperson
Number
Salesperson
Name
Commission
Percentage
Office
Number
A
Year of Hire
SALESPERSON
G
Customer
Number
Customer
Name
Salesperson
Number
B
HQ City
CUSTOMER
Customer
Number
Employee
Number
Employee
Name
C
Title
CUSTOMER EMPLOYEE
Product
Number
Product
Name
D
Unit Price
PRODUCT
I
Salesperson
Number
Product
Number
E
Quantity
SALES
Office
Number
F
Telephone
Size
F I G U R E 8.21
The General Hardware Company relational
database with some indexes
OFFICE
Reorganizing Stored Data
The next level of change in physical design involves reorganizing the way data
is stored on the disk without changing the logical design at all and thus without
introducing data redundancy. We present an example of this type of modification.
Search WWH ::
Custom Search