Database Reference
In-Depth Information
only product associated with a given vendor.
Figure 11.22
shows the results of your modi-
fications.
Figure 11.22. The revised relationship diagram for the VENDORS and PRODUCTS
tables
You already know that this type of business rule will be tested when a user attempts to in-
sert a record into or delete a record from the PRODUCTS table, so you complete this pro-
cess by filling out a Business Rule Specifications sheet for this rule.
Figure 11.23
shows
the completed specification sheet.
