Database Reference
In-Depth Information
Figure 8.13. Establishing the primary key for the SERVICES subset table
The last order of business is to conduct interviews with Mike and his staff and review all
the work you've performed on the tables in the database. As you conduct these interviews,
make certain you check the following.
• The appropriate subjects are represented in the database.
• The table names and descriptions are suitable and meaningful to everyone.
• The field names are suitable and meaningful to everyone.
• All the appropriate fields are assigned to each table.
By the end of the interview, everyone agrees that the tables are in good form and that all
thesubjectswithwhichtheyareconcernedarerepresentedinthedatabase.Onlyoneminor
point came up during the discussions: Mike wants to add a C
ALL
P
RIORITY
field to the
VENDORS table. There are instances in which more than one vendor supplies a particular
product,andMikewantstocreateawaytoindicatewhichvendorheshouldcallfirstifthat
product is unexpectedly out of stock. So you add the new field to the VENDORS table and
bring the interview to a close.
