HIM 650 Data Manipulation and Querying With SQL
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.
Write a 500-750 word essay that introduces the history and purpose of SQL language, including a statement and a screenshot of each executed command.
Data Manipulation and Querying With SQL Assignment Instructions
The purpose of this assignment is to learn how to write and execute the following SQL data definition and data manipulation commands based on the data provided in the assignment supplement:
SELECT * FROM `Doctor`;
FROM `Patient`
WHERE DOB < 01/01/1994;
SELECT P.*, S.PrescriberID
FROM `Patient P`
INNER JOIN `Prescription S`
ON
P.PatientID=S.PatientID;
SELECT S.*, P.Name, P.DOB, M.BrandName, D.Name
FROM `Prescription S`
INNER JOIN `Patient P` ON P.PatientID=S.PatientID
INNER JOIN `Doctor D` ON D.DoctorID=S.PrescriberID
INNER JOIN `Medication M` ON M.MedicationID=S.MedicationID
ORDER BY S.Date DESC;
SELECT TOP 1 COUNT(GenericName), GenericName
FROM `Medication`
INNER JOIN `Prescription` ON Medication.MedicationID=Prescription.MedicationID
GROUP BY GenericName
ORDER BY COUNT(PrescriptionID) DESC;
Log onto http://sqlfiddle.com/ and execute the SQL commands listed in the order provided in this document. Reference the Provider Table below and use its information to build the database. Refer to the “Data Manipulation and Querying With SQL Resource” document for assistance in completing this assignment.
Log onto http://sqlfiddle.com/ and execute the SQL commands listed in the order provided in the attached document, ”Data Manipulation and Querying With SQL Assignment Instructions.” Reference the ”Provider Table” in the document and use its information to build the database. In addition, refer to the attached document, ”Data Manipulation and Querying With SQL Resource” for assistance in completing this assignment.
Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: HIM 650 Data Manipulation and Querying With SQL
Copy and paste a screenshot of each executed command and the populated data onto a document and submit for grading.
Provider Table:
ProviderID FirstName LastName HireDate
———- ———- ———- ———-
123456 Ben Spock
123457 Albert Schweitzer 1990-05-09
123458 Derek Shepherd 2005-03-27
123459 Mark Sloan 2005-03-27
- Command CREATE TABLE
- Command that ALTER table by adding column
- Command INSERT values for populating table
- Perform six (6) queries to the Provider Table:
- Command SELECT from Provider Table querying Last Name, Hire Date
- Command SELECT from Provider Table querying Hire Date
- Command SELECT from Provider Table querying specific Provider by Last Name and First Name
- Command SELECT FROM Provider Table querying specific Provider by ID and Last Name
- Command SELECT FROM Provider Table querying Hire Dates
- Command SELECT FROM Provider Table querying Provider Hire Date is NULL
- Command ALTER TABLE and UPDATE to add a new Salary column to the Provider table
- Perform three (3) column function queries on the Provider Table:
- SELECT SUM
- SELECT AVG
- SELECT MIN, SELECT AVG, and SELECT MAX
- Perform three (3) COUNT queries on the Provider table
- SELECT COUNT FROM Provider
- SELECT COUNT from HIRE DATE
- SELECT COUNT DISTINCT
- Command INSERT INTO Provider table adding a new row
- Perform two (2) aggregation queries on the Provider table
- SELECT HireDate from Provider table
- SELECT HireDate COUNT FROM PROVIDER GROUP BY HireDate HAVING COUNT (*)>1;
- CREATE PATIENT TABLE with the data values provided in the assignment.
- Perform query command SELECT FROM Patient table
- Perform three (3) multi-table queries of PROVIDER and PATIENT tables
- Modify the database by adding an additional column (”Deleted_Date”) to a table. Justify your rationale in a short paragraph by explaining what the tradeoffs are in using a marker-column for deletion, as opposed to deleting a row from a table?
RUBRIC
Data Manipulation and Querying With SQL
No of Criteria: 12 Achievement Levels: 5
Criteria
Achievement Levels
DescriptionPercentage
1: Unsatisfactory
0.00 %
2: Less Than Satisfactory
74.00 %
3: Satisfactory
79.00 %
Unsatisfactory
87.00 %
5: Excellent
100.00 %
Criteria
100.0
Six Queries of Data to the Provider Table
10.0
The six queries of data to the provider table are not present.
The six queries of data to the provider table are present but lack detail or are incomplete.
The six queries of data to the provider table are present.
The six queries of data to the provider table are detailed.
The six queries of data to the provider table are thorough and without errors.
Salary Column Update to the Provider Table
10.0
The salary column update to the provider table is not present.
The salary column update to the provider table is present but lacks detail or is incomplete.
The salary column update to the provider table is present.
The salary column update to the provider table is detailed.
The salary column update to the provider table is thorough and without errors.
Three Column Function Queries to the Provider Table
10.0
The three column function queries to the provider table are not present.
The three column function queries to the provider table are present but lack detail or are incomplete.
The three column function queries to the provider table are present.
The three column function queries to the provider table are detailed.
The three column function queries to the provider table are thorough and without errors.
Three Count Queries to the Provider Table
10.0
The three count queries to the provider table are not present.
The three count queries to the provider table are present but lack detail or are incomplete.
The three count queries to the provider table are present.
The three count queries to the provider table are detailed.
The three count queries to the provider table are thorough and without errors.
Two Aggregation Queries to the Provider Table
10.0
The two aggregation queries to the provider table are not present.
The two aggregation queries to the provider table are present but lack detail or are incomplete.
The two aggregation queries to the provider table are present.
The two aggregation queries to the provider table are detailed.
The two aggregation queries to the provider table are thorough and without errors.
Patient Table With Three Multi-Table Queries
10.0
The patient table with three multi-table queries is not present.
The patient table with three multi-table queries is present but lacks detail or is incomplete.
The patient table with three multi-table queries is present.
The patient table with three multi-table queries is detailed.
The patient table with three multi-table queries is thorough and without errors.
Rationale for Using Marker-Column vs. Row Deletion
10.0
The rationale for using marker-column vs. row deletion is not present.
The rationale for using marker-column vs. row deletion is present but lacks detail or is incomplete.
The rationale for using marker-column vs. row deletion is present.
The rationale for using marker-column vs. row deletion is detailed.
The rationale for using marker-column vs. row deletion is thorough and without errors.
Thesis Development and Purpose
7.0
Paper lacks any discernible overall purpose or organizing claim.
Thesis is insufficiently developed or vague. Purpose is not clear.
Thesis is apparent and appropriate to purpose.
Thesis is clear and forecasts the development of the paper. Thesis is descriptive and reflective of the arguments and appropriate to the purpose.
Thesis is comprehensive and contains the essence of the paper. Thesis statement makes the purpose of the paper clear.
Argument Logic and Construction
8.0
Statement of purpose is not justified by the conclusion. The conclusion does not support the claim made. Argument is incoherent and uses noncredible sources.
Sufficient justification of claims is lacking. Argument lacks consistent unity. There are obvious flaws in the logic. Some sources have questionable credibility.
Argument is orderly but may have a few inconsistencies. The argument presents minimal justification of claims. Argument logically, but not thoroughly, supports the purpose. Sources used are credible. Introduction and conclusion bracket the thesis.
Argument shows logical progressions. Techniques of argumentation are evident. There is a smooth progression of claims from introduction to conclusion. Most sources are authoritative.
Clear and convincing argument that presents a persuasive claim in a distinctive and compelling manner. All sources are authoritative.
Mechanics of Writing (includes spelling, punctuation, grammar, language use)
5.0Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed.
Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used.
Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied.
Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed.
Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech.
Writer is clearly in command of standard, written, academic English.
Paper Format (use of appropriate style for the major and assignment)
5.0
Template is not used appropriately, or documentation format is rarely followed correctly.
Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent.
Appropriate template is used. Formatting is correct, although some minor errors may be present.
Appropriate template is fully used. There are virtually no errors in formatting style.
All format elements are correct.
Documentation of Sources (citations, footnotes, references, bibliography, etc., as appropriate to assignment and style)
5.0
Sources are not documented.
Documentation of sources is inconsistent or incorrect, as appropriate to assignment and style, with numerous formatting errors.
Sources are documented, as appropriate to assignment and style, although some formatting errors may be present.
Sources are documented, as appropriate to assignment and style, and format is mostly correct.
Sources are completely and correctly documented, as appropriate to assignment and style, and format is free of error.
Total Percentage 100
PLACE THIS ORDER OR A SIMILAR ORDER WITH ONLINE NURSING PAPERS TODAY AND GET AN AMAZING DISCOUNT