Establishing Table Structures - Database Design for Mere Mortals - page 186

Figure 7.32. The Preliminary Field List for Mike's Bikes
AftercarefullyreviewingtheentirePreliminary FieldList,youdetermine thatthefieldson
the list suggest these subjects: customers, employees, invoices, products, and vendors. You
then compile these items into the first version of your Preliminary Table List.
Now you create a second version of the list by merging the current Preliminary Table List
with the list of subjects you created during the analysis process. Keep the following steps
in mind as you merge the two lists together.
1. Resolve items that are duplicated on both lists. Remember that a single item can
appear on both lists yet represent different subjects. When you identify such items,
use the appropriate techniques to resolve this problem.
2. Resolve items that represent the same subject but have different names. You want
to ensure that only one table represents a particular subject.
3. Combine the remaining items together into one list. The combined list becomes the
second version of the Preliminary Table List.
After following these steps, your Preliminary Table List should look similar to the one
shown in Figure 7.33 .