Laboratory Database



Independent Laboratory C receives specimens from many sources. Patient ID numbers and the name of the submitting clinic are used for identification along with the date of the specimen. In a real system, a specimen number would also be assigned, but here we are using ID, CLINIC, and DATE to identify the results and match them to the patient records after they are sent to the submitting clinic.

In most systems, the laboratory would select results belonging to a particular clinic and send only those to the clinic, but here, for demonstration purposes, we “send” the entire laboratory database and allow each clinic to match results with the patient records. Results for other clinics will not match and will therefore be ignored.

Exit from the browser (red X in the upper right corner) to see the laboratory database after results have been entered by the lab staff.