Database Reference
In-Depth Information
Figure 12.12. Report sample requiring a view
The notes you've taken throughout the design process become useful once again. You re-
viewed this report during the analysis stage of the design process, and you've noted that
thisreportrepresentsinformationaboutcustomersandtheirorders;itisfromtheorderdata
that you can determine when a given customer made his last purchase. Now, review the re-
lationshipdiagramfortheCUSTOMERSandORDERStables;you'llusefieldsfromthese
tables to create the CUSTOMER CALL LIST view.
Figure 12.13
shows the relationship
diagram for these tables.
