[Solved] quay cooper

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)