26 Mar Create an Entity-Relationship Diagram (ERD) that represents a secure patient information database.
Log In info EHRGo Clinical Reminder Data Visualization V (https://web21.ehrgo.com/activity/index/id/13403#!/step10 ) username: QuayCooper password: Beautiful1!!
Scenario
Healthcare organizations rely on well-designed databases to support secure, accurate, and reliable management of patient information. In this assignment, you will design a secure patient information database model, evaluate its suitability for healthcare use, and analyze how data modeling decisions impact data integrity, confidentiality, and system security.
You have been hired as a Health Informatics Specialist at VitalCare Institute, a healthcare organization seeking to modernize its patient data management system. Leadership wants a secure, scalable, and well-structured database design that supports patient care while protecting sensitive health information.
Instructions
Your task is to design a database model, create a sample implementation, and evaluate its effectiveness from a data security and management perspective.
Part 1: Database Design
Create an Entity-Relationship Diagram (ERD) that represents a secure patient information database.
Your ERD must include:
· At least three (3) entities (e.g., Patient, Provider, Encounter)
· At least four (4) attributes per entity
· Clearly defined relationships (one-to-many, many-to-many)
· Primary keys for each entity
· Identification of sensitive data elements (e.g., PHI)
In your ERD:
· Indicate where access controls or restricted data elements would be required
· Clearly label attributes that represent protected health information (PHI)
· Demonstrate how thoughtful data modeling supports data integrity and security
You may use tools such as:
· Lucidchart
· Draw.io
· PowerPoint or Word drawing tools
Write a one-page summary explaining the key design and security principles reflected in your database model.
Part 2: Database Creation in Excel
Using Microsoft Excel, create a sample version of your database design.
Requirements:
· Create three related tables based on your ERD
· Demonstrate relationships using lookup functions (e.g., VLOOKUP or XLOOKUP)
· Apply at least one data validation or conditional formatting rule to reduce data entry errors
📌 Note: This database is a conceptual demonstration and is not intended to function as a production healthcare system.
Part 3: Security and Data Management Analysis
Write a 2–3 page analysis that connects your database design to security and data management principles.
A. Security Considerations
· Identify security risks associated with storing patient data in a database
· Explain how your data model supports:
· Confidentiality
· Integrity
· Controlled access
· Describe recommended safeguards such as:
· Role-based access
· Audit trails
· Data minimization
· Encryption (conceptually)
B. Tool Evaluation
· Critically evaluate the limitations of using Excel as a healthcare database
· Discuss scalability, compliance, and security concerns
· Recommend features a healthcare-grade database system should include (e.g., access controls, audit logging)
Support your analysis with at least two (2) peer-reviewed sources.
Part 4: Presentation or Written Report
Choose one format:
Option 1: PowerPoint Presentation
· Minimum of 10 content slides
· Include:
· ERD overview
· Database design explanation
· Security considerations
· Recommendations
· Include detailed presenter notes
Option 2: Written Report
· Combine all assignment components into one cohesive report
· Include clear section headings
· APA formatting required
Submission Requirements
Submit one file containing:
· ERD (embedded or attached)
· Excel database (embedded screenshots or uploaded file, if required)
· Analysis and recommendations
· References (APA 7th edition)
