CDC Database Queries

• The CDC retains its data in the three basic tables, Clients , Doctors and Visit

• Other tables are needed for information system operation

  • Lab Manifests are derived from the Visit table
  • Labels are derived from the Lab Manifest tables
  • A table is needed as input to the letter creation operation, which is built from the Visit and the Clients tables
  • A table of summary statistics must be created from Visit records

Previous slide

Next slide

Back to first slide

View graphic version