preview

Nursing/Clinical Database Paper

Decent Essays

The scope of this document is to provide a design for relational database model for clinical group of 25 physicians and 1000 patients. All 25 physicians within the Horizon Medical Center will employ the EHR operated on NoSQL to offer optimal care for 1000 patients.
The Database Design for the EHR is composed of definitions for database objects derived by mapping entities to tables, attributes to columns, unique identifiers to unique keys and relationships to foreign keys. During design, these definitions may be enhanced to support the functionality described in the functional specifications and defined in the primary and supporting modules of the application’s High-Level Design. The database design will also use SQL statements that will be used to extract information from the proposed paper (EHR) …show more content…

• Picture Archiving and Communication Systems (PACS): capture and store medical images such as x-rays, Computerized tomography (CT) scans, Magnetic Resonance Imaging (MRI) scans, and other medical diagnostic images (Glandon et al., 2014).
Stage 4
• Computerized Physician Order Entry (CPOE): immediately request medication, clinical laboratory or radiology test, or procedure into the computer by the physician (Glandon et al., 2014).
Stage 5
• Closed-Loop Medication Administration: also known as end-to-end medication administration. According to Glandon, Smaltz and Slovensky (2014), this “includes CPOE with CDS for error checks, bar code or other automated methods for checks during medication administration, and an electronic medication administration record (e-Mar) linked to the pharmacy and the CPOE”.
• Health Insurance: membership/benefits, claims processing, and pricing systems
• Outpatient: scheduling, registration, clinical units, billing
• Inpatient: scheduling, admissions, discharge, transfers, pharmacy, emergency department, operating room, billing
Stage

Get Access