Instructions
Scenario: You have been chosen as the new head of the information technology department at Goddard Hospital. The database
What data base the hospital has been using, eg Microsoft acess was being used. that the hospital has been using has been faulty so far, and as such, the hospital thought it would be recommended to switch to a SQL server. Taking into account that many of the employee from various departments don’t understand how to add and retrieve data in the new database. You should simplify the explanation to suit the language needs of everyone involved. Moreover, you should also \including the select statements to perform their daily tasks, including selecting data, adding, and deleting it from the database.
Example: Create a set of SQL statements that produce the follow output: come uo with list of statement to create a table
Patients | Date of Service | Drug Name | Drug Prescription | Provider Name |
Linda Anie | 6/10/2010 | Amiodarone | 25 mg | Carl Smith |
Idu George | 3/24/2019 | Metoprolol | 12.5 mg | Park Won |
Mini John | 6/10/2020 | Atorvastatin | 40 mg | Parikh Jane |
Yolanda Brown | 4/2/202 | Amiodarone | 5mg | Pool Gray |
- Choose which SQL statement is correct to List all the records in the Patients chart:
- select distinct class
from patients
B.
from Patients
- select name, surname, class
from Patients
Activity: Create a set of SQL statements that produce the follow output: using the table below answer the multiple choice 25 questions.
Customer Name | Address | City | PostalCode | Country |
Betahnia Abay | 13100 pandora dr | Berlin | 12809 | Germany |
Ezra Mekonnen | 11655 audelia dr | México D.F. | 07034 | Mexico |
Luke Ayele | 2213 bronx rd | México D.F. | 06012 | Mexico |
Eldana Mekonnen | 142 nox way | London | WC1 1AP | UK |
Multiple choice questions:
- Which statement below i
- SELECT * FROM Customers
WHERE City=’Berlin’;
B . SELECT * FROM Customers
WHERE CustomerID=1;
- SELECT Count(*) AS DistinctCountries
FROM (SELECT DISTINCT Country FROM Customers);
- The following SQL statement selects the “CustomerName” and “City” columns from the “Customers” table:
- SELECT *
FROM Customers;
- SELECT CustomerName, City
FROM Customers;
- SELECT *
FROM table_name;
,
Learning Outcomes, And Assessment Guide
The learning outcome of this assignment is to ascertain that the students properly understand the use of select statements and how they can be used in real-life settings. Moreover, this assignment will also gauge the ability of the student to simplify and explain basic select statement codes to people who don’t know fully understand the concept of SQL databases. The explanation should address the following elements (but not limited to) the select, from, where and semicolon clauses used in an SQL database for ease of access. As such, the student should illustrate proper mechanisms in selecting columns of information from databases and also explaining the valid exceptions for different means of data retrieval using the select statement.
Question #1
Answer “B”
The key word students must pay attention is “all” . The select statement must include all the record in the chart. Instead of having to write out each individual column which would take quite a while, there is a wildcard that you can use which is the asterisk. So you can put SELECT * and then FROM Products and this is going to go ahead and grab everything from the Products table, each individual column, and put it into your output.
Question #2
Answer “A”
SELECT statement, tell a database what table you want your data FROM, SELECT either all or particular columns from a table in a query, and limit the amount of data that is returned in a query.
Question # 3
Answer “B”
With the SELECT statement you’re going to specify two pieces of information, what you want to select and where you want it from. if you’re selecting something, you need to tell SQL, in the database, where to get it from.
We will discuss this section during our call today. Please do some research on learning outcomes and assessment for information technology courses. Please find scholarly articles on this topic and use those to create a robust section for your Learning Outcomes, Assessment, and Instructor Guide. This section should be at least 750 words and should include:
Findings from the scholarly research on learning assessment
Details on how you plan to assess the students learning (I will provide information on how we assess this at GCU).
Find scholarly articles on how to create a Faculty Instruction for a course and use that as your guide to create this section. Your Instructor guide should include an introduction, an explanation of your topic, our objectives, for the week and how your DQs tie into the topic and a detailed discussion of your activity and how the activity will enhance learning of the topic material for the student. The answers should also be included, your answers explanation format is good, but you need to revise it based on your revision of the statements above.