Topic 4: Data Manipulation and Querying With SQL

Topic 4: Data Manipulation and Querying With SQL

Feb 3, 2022 – Feb 9, 2022 Max Points: 150
Resources
Is Query Reuse Potentially Harmful? Anchoring and Adjustment in Adapting Existing Database
Queries
Read “Is Query Reuse Potentially Harmful? Anchoring and Adjustment in Adapting Existing Database Queries,”
by Allen and Parsons, from Information Systems Research (2008).
https://lopes.idm.oclc.org/login?url=https://search.ebscohost.com/login.aspx?
direct=true&db=edsjsr&AN=edsjsr.23015519&site=edslive&scope=site&custid=s8333196&groupid=main&profle=eds1
Early History of SQL
Page 9 Grand Canyon University 2022 © Prepared on: Jan 10, 2022
Read “Early History of SQL,” by Chamberlin, from IEEE Annals of the History of Computing (2012).
https://doi-org.lopes.idm.oclc.org/10.1109/MAHC.2012.61
SQL Fiddle
Explore the SQL Fiddle website for assistance with the topic assignment.
http://sqlfddle.com/
Handy MySQL Commands
Refer to the “Handy MySQL Commands” resource to assist you with completing the topic assignment.
http://g2pc1.bu.edu/~qzpeng/manual/MySQL%20Commands.htm
Assessments
Data Manipulation and Querying With SQL
Start Date & Time Due Date & Time Points
Feb 3, 2022, 12:00 AM Feb 9, 2022, 11:59 PM 120
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