Databases Reference
In-Depth Information
To refresh, the sample dataset has the following structure:
Name
Callsign
Examiner
ExaminerCallsign
Region
RegionCoordinator
LicenseClass
Frequency1...n
So let's start by organizing these attributes in single-purpose groups. If you don't get it right the first
time, don't worry! You're going to keep doing this until all the tables meet the requirements.
Regroup these attributes as shown in Figure 8-1.
Figure 8-1
Oops! It appears that the operator table is a multi-purpose table. It's currently holding information
for both an operator and an examiner. You know what's next. Subdivide the Operator table into two
single-purpose tables (see Figure 8-2).
Search WWH ::
Custom Search