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)

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.