Databases Reference
In-Depth Information
Figure 8-2
Oops again! By putting the OperatorID in the License and Region tables, I've made those tables
multi-purpose tables. A quick re-shuffling of the key columns will fix that (see Figure 8-3).
Now the tables have been rearranged as single-purpose tables. Next, turn your attention to redundancy.
The Region and License tables have some redundancy in the column values. In Region, the RegionCoor-
dinator can appear more than once. In License, the LicenseClass can appear more than once because of
the multiple values for Frequency. Again, split those tables (see Figure 8-4).
Search WWH ::
Custom Search