Database Reference
In-Depth Information
4.
Compose a suitable description for the data table and then add it to the Final Table
List. Indicate the table type as “Data.”
Figure 7.31
shows the results of using these steps on the FULL-TIME EMPLOYEES and
PART-TIME EMPLOYEES tables.
Figure 7.31. The results of refining the subset tables
At this point, all of your table structures should be in pretty good shape. You will need to
refine them even further, however, as you learn about primary keys, foreign keys, relation-
ships, and business rules.
Case Study
You're now going to define the
Preliminary Table List
for Mike's Bikes. As you know, the
first thing you need to do is review the Preliminary Field List to determine what subjects
you can infer from the fields on the list.
Figure 7.32
shows a
partial
sample of that list.
