FIT 100
© Copyright University of
Washington 1999-2000
Recall The CDC Design ...
vAs it exists so far, the CDC database system has the following
components:
oClients Table and Clients Form with Queue
mechanism
oMedPros Table and MedPros Form
oVisits Table and Visits Form with Order button to set
the tracking
number
vWhat remains is to prepare for the “post visit” processing
vThe main idea in “post visit” processing is to build new tables from the data in the Visits table
vThese derived tables are produced by queries