Discussion: Security Breaches in Data Related to Health Care

Discussion: Security Breaches in Data Related to Health Care

Start Date & Time Due Date & Time Points
Feb 3, 2022, 12:00 AM Feb 7, 2022, 11:59 PM 5
Find two examples of data/ theft/loss/exposure of confidential data,
preferably data related to health care. Describe the incidents and explain what could have been done to
prevent or mitigate them.

The purpose of this assignment is to give learners an opportunity to write and execute MySQL commands
utilizing SQL Fiddle. SQL Fiddle is a cloud-based application that allows database designers to write syntax and
share data with other professionals.
For this assignment, begin by reviewing the attached resource, “Data Manipulation and
Querying With SQL Resource” for assistance in completing this assignment.
Part 1
Log onto SQL Fiddle and execute the SQL commands listed, in the order provided, in the attached resource,
“Data Manipulation and Querying With SQL Assignment Instructions.” Use the information found in the
“Provider Table” that is located within the resource to build the database.
Part 2
Write a 500-750-word essay that includes the following:
1. The history of SQL language
2. The purpose of SQL language
3. A statement and screenshot of each executed command.
4. Discussion of deletion and marker columns (50-75 words)
General Requirements
The bulk of this essay should focus on the history and purpose of SQL language.
Page 10 Grand Canyon University 2022 © Prepared on: Jan 10, 2022
Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student
Success Center.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar
with the expectations for successful completion.
You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is
located in Class Resources if you need assistance.

CAHIIM
This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the
master’s degree level:
F2: Information Science and Technology: Does
Topic 4 DQ 1
Start Date & Time Due Date & Time Points
Feb 3, 2022, 12:00 AM Feb 5, 2022, 11:59 PM 5
Protecting data security, privacy, and integrity are important database functions. What activities are required
in the DBA’s managerial role of enforcing these functions? Using SQL statements, give some examples of how
you would use the data dictionary to monitor the security of the database.