Database Reference
In-Depth Information
As it turns out,
all
of the subjects you've identified from the mission objectives for Mike's
Bikes already appear on the Preliminary Table List. This is good news because it allows
you to complete your cross-check quite easily. Satisfied that you've completed the task
thoroughly, you now have the final version of the Preliminary Table List.
Now that the Preliminary Table List is complete, you're ready to transform it into a
Final
Table List.
Keep these steps in mind as you begin this process.
1.
Refine the table names.
Use the appropriate guidelines to ensure that each table
name is clear, unambiguous, descriptive, and meaningful.
2.
Compose a suitable description for each table.
Make certain that the table descrip-
tion explicitly defines the table and states its importance to the organization. Use
the pertinent guidelines to create each table description.
3.
Indicate the table's type.
Remember that a table can be classified in one of four
ways—
data, linking, subset,
or
validation.
At this point, all of your tables are
data
tables.
Figure 7.34
shows a
partial
example of the Final Table List for Mike's Bikes.
Figure 7.34. A partial listing of the Final Table List for Mike's Bikes
