Assignment:
Log In infoEHRGo Clinical Reminder Data Visualization
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. Need Assignment Help?
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)