Database Reference
In-Depth Information
Figure 6.17. Recording characteristics that incorporate value lists
You can be discerning about the characteristics you choose to record. For example, it's un-
necessary for you to record characteristics that accept simple or obvious sets of values,
suchas“yes/no,”“true/false,” or“active/inactive.” Instead, youshouldrecordcharacterist-
ics that accept distinct, specific sets of values.
Set this sheet (or sheets) aside after you've finished recording the appropriate character-
istics. You'll refer to this sheet when you define field specifications for the fields in the
database and again when you define business rules.
The Calculated Field List
There's one final refinement you must make to the Preliminary Field List before you can
consideritcomplete:Youmustremoveevery calculated field andplaceitonaseparatelist.
This new list becomes your Calculated Field List. Recall from Chapter 3 that a calculated
field is one that stores the result of a string concatenation or mathematical expression as
Search WWH ::




Custom Search