title: Relational database design: evaluation of the recognition, isolation and treatment of hospitalized patients with tuberculosis.
abstract: 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.
authors.affiliation: Duke-UNC Training Program in Medical Informatics, University of North Carolina School of Medicine, Chapel Hill 27594.
authors.forename: E N
authors.initials: EN
authors.lastname: Robinson
authors.forename: D
authors.initials: D
authors.lastname: Beard
mesh_terms: D003628:Database Management Systems; D016208:Databases, Factual; D006801:Humans; D014376:Tuberculosis / Q000175:diagnosis / Q000628:therapy