Database Reference
In-Depth Information
Figure 9.11. Field specifications for the P
RODUCT
D
ESCRIPTION
field
Now you meet with Mike and his staff to discuss the field specifications you've defined.
No one seems to have problems with any of the specifications; everyone confirms that all
oftheelementsettingsseemsuitableandcorrect.Youdohaveaquestion,however,regard-
ingtheC
ATEGORY
field inthePRODUCTS table: Youwant toknowtheappropriate setting
for the Range of Values element. The response to your question is mixed—no one seems
to know the complete list of categories that are valid for the field, so you decide to specify
a general range of values for now.
Figure 9.12
shows the revised logical elements for the
C
ATEGORY
field.
Figure 9.12. The logical elements for the C
ATEGORY
field in the PRODUCTS table
You'll revisit this field (and its elements) again when you establish business rules for the
database. With this problem solved, your meeting—as well as the process of establishing
field specifications—is complete.
