Related Experiment Videos
Relational database design: evaluation of the recognition, isolation and treatment of hospitalized patients with
1Duke-UNC Training Program in Medical Informatics, University of North Carolina School of Medicine, Chapel Hill 27594.
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.