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`;

SELECT COUNT(PatientID)

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

  1. Command CREATE TABLE
  2. Command that ALTER table by adding column
  3. Command INSERT values for populating table
  4. Perform six (6) queries to the Provider Table:
  5. Command SELECT from Provider Table querying Last Name, Hire Date
  6. Command SELECT from Provider Table querying Hire Date
  7. Command SELECT from Provider Table querying specific Provider by Last Name and First Name
  8. Command SELECT FROM Provider Table querying specific Provider by ID and Last Name
  9. Command SELECT FROM Provider Table querying Hire Dates
  10. Command SELECT FROM Provider Table querying Provider Hire Date is NULL
  11. Command ALTER TABLE and UPDATE to add a new Salary column to the Provider table
  12. Perform three (3) column function queries on the Provider Table:
  13. SELECT SUM
  14. SELECT AVG
  15. SELECT MIN, SELECT AVG, and SELECT MAX
  16. Perform three (3) COUNT queries on the Provider table
  17. SELECT COUNT FROM Provider
  18. SELECT COUNT from HIRE DATE
  19. SELECT COUNT DISTINCT
  20. Command INSERT INTO Provider table adding a new row
  21. Perform two (2) aggregation queries on the Provider table
  22. SELECT HireDate from Provider table
  23. SELECT HireDate COUNT FROM PROVIDER GROUP BY HireDate HAVING COUNT (*)>1;
  24. CREATE PATIENT TABLE with the data values provided in the assignment.
  25. Perform query command SELECT FROM Patient table
  26. Perform three (3) multi-table queries of PROVIDER and PATIENT tables
  27. 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
 ordernowcc-blue