Data Manipulation and Querying With SQL Assignment Instructions

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.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 Spock123457 Albert Schweitzer 1990-05-09123458 Derek Shepherd 2005-03-27123459 Mark Sloan 2005-03-27Command      CREATE TABLECommand that      ALTER table by adding columnCommand      INSERT values for populating tablePerform six      (6) queries to the Provider Table:a. Command SELECT from Provider Table querying Last Name, Hire Dateb. Command SELECT from Provider Table querying Hire Datec. Command SELECT from Provider Table querying specific Provider by Last Name and First Named. Command SELECT FROM Provider Table querying specific Provider by ID and Last Namee. Command SELECT FROM Provider Table querying Hire Datesf. Command SELECT FROM Provider Table querying Provider Hire Date is NULLCommand ALTER      TABLE and UPDATE to add a new Salary column to the Provider tablePerform three      (3) column function queries on the Provider Table:a. SELECT SUMb. SELECT AVGc. SELECT MIN, SELECT AVG, and SELECT MAXPerform three      (3) COUNT queries on the Provider tablea. SELECT COUNT FROM Providerb. SELECT COUNT from HIRE DATEc. SELECT COUNT DISTINCTCommand      INSERT INTO Provider table adding a new rowPerform two      (2) aggregation queries on the Provider tablea. SELECT HireDate from Provider tableb. 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 tablePerform      three (3) multi-table queries of PROVIDER and PATIENT tablesModify      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?

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post Data Manipulation and Querying With SQL Assignment Instructions appeared first on The Nursing Hub.