Relational database design: evaluation of the recognition, isolation and treatment of hospitalized patients with tuberculosis.
Hospitals have been charged with the the evaluation of their abilities to identify, diagnose, isolate and treat individuals with active tuberculosis. This evaluation can be facilitated by a properly designed relational database. Using Entity Relationship diagrams, a relational data model, and the process of normalization, a database was designed that will contain the information gathered in prospective surveillance of tuberculosis in a community hospital. Although the authors' intent is to implement the design using a personal computer and a commercially available relational database management tool (Microsoft Access), the design is independent of the management tool and can be applied to other systems.
Robinson
E N
EN
Duke-UNC Training Program in Medical Informatics, University of North Carolina School of Medicine, Chapel Hill 27594.
Beard
D
D
D003628:Database Management Systems; D016208:Databases, Factual; D006801:Humans; D014376:Tuberculosis / Q000175:diagnosis / Q000628:therapy