Body substances include serum, plasma, urine, and whole blood. Units include milliequivalents per dl, thousands of cells per cc, and percentage. Specimens are collected by phlebotamists and analyzed by laboratory technicians. The laboratory assigns a unique identifier to every specimen. The time that is most important to clinicians is the time when a specimen was collected.
Queries Determine the sex and date of birth for a given patient.
Determine possible unique identifiers for patients with a given name. Determine measurements and times for given analyte in a given substance for given patient. Determine white blood count for female patients born before 1960. Querying Queries can be expressed as conceptual graphs, using concepts and relations from the conceptual schema. Restrictions are expressed by specifying particular referents for concepts.