Assignment Prompt & Instructions
Please see attachment
**files (1)**
– ## QuayCooperassignment3.docx
**## QuayCooperassignment3.docx**
Log In info
[**EHRGo Clinical Reminder Data Visualization V**](https://web21.ehrgo.com/rd/?courseActivityId=13699) **(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)
**## QuayCooperassignment3.docx**
Log In info
[**EHRGo Clinical Reminder Data Visualization V**](https://web21.ehrgo.com/rd/?courseActivityId=13699) **(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)