Database Reference
In-Depth Information
Views
Although views are not directly connected to any component of data integrity, you should
nevertheless review all of your view structures. As you examine each view, make certain
you've addressed these items.
• Each view contains the base tables necessary to provide the required information.
• You've assigned the appropriate fields to each view.
• Each calculated field provides pertinent information or enhances the manner in
which the view presents its data.
• Each filter returns the appropriate set of records.
• Each view has a view diagram.
• Each view diagram is accompanied by a View Specifications sheet.
If you encounter problems with any view, resolve them by using the techniques discussed
in
Chapter 12
,
“
Views
.”
Once you've completed this entire review, you can be confident that the database structure
is sound, the data within the database is consistent and valid, and the information you re-
trieve from the database will be accurate.
Assembling the Database Documentation
Throughout the database design process, you've generated a number of lists, specification
sheets,anddiagramsusedtorecordvariousaspectsofthedatabasedesign.Youshouldnow
assemble them intoacentral repository,preferably inasetofbinders orinanorganized set
of folders and files on a computer. The design repository should consist of the following
sets of documents:
• Final table list
• Field Specifications sheets
• Calculated field list
• Table structure diagrams
• Relationship diagrams
• Business Rule Specifications sheets
• View diagrams
• And View Specifications sheets
Two additional sets of items you may consider keeping with this documentation are the
notesyoucompiledduringthedesignprocessandthesamplesyougatheredduringtheana-
