DAD 220 Module Four Major Activity = Long (1)
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Chemistry
Date
Dec 6, 2023
Type
docx
Pages
5
Uploaded by JusticeMetalQuetzal31
DAD 220 Module Four Major Activity
DAD 220
Instructor Brian Myers
Briah Long
5/27/2023
Complete these steps as you work through the directions for this activity. Replace the bracketed text with your screenshots and brief explanations of the work they capture. Each screenshot and its explanation should be sized to approximately one quarter of the page, with the description written below the screenshot. Follow these rules for each of the prompts and questions below. Review the example document for assistance.
Follow Steps 1 through 4 from the Module Three Major Activity only to generate tables for this assignment.
1.
Import the
data from each file
into tables. A.
Use the import utility of your database program to load the data from each file into the table of the same name. You’ll perform this step three times, once for each table.
B.
Provide the SQL commands you ran against MySQL to complete this successfully in your answer.
The above commands allowed me to load the data from the preexisting files into the tables. 2.
Write basic queries against imported tables to organize and analyze targeted data
. 3.
For each query, include a screenshot of the query and its output. You should also include a 1- to 3-sentence description of the output.
A.
Write an SQL query that returns the count of orders for customers located only in the city of Framingham, Massachusetts. i.
How many records were returned? 505
I used the COUNT(*) command to and used the INNER JOIN command to join Orders and
Customers to count the records only from Framingham, MA.
B.
Write an SQL query to select all of the customers located in the state of Massachusetts.
i.
Use a WHERE clause to limit the number of records in the Customers table to only those that are located in Massachusetts.
ii.
Record an answer to the following question: How many records were returned? 982
I used the COUNT(*) command to get a count of customers in the Customers table stthat are located
only in MA.
C.
Write an SQL query to insert four new records into the Orders and Customers tables using the following data:
i.
Customers Table
CustomerID
FirstName
Lastname
StreetAddress
City
State
ZipCode
Telephone
100004
Luke
Skywalker
17 Maiden Lane
New York
NY
10222
212-555-1234
100005
Winston
Smith
128 Sycamore Street
Greensboro
NC
27401
919-555-6623
100006
MaryAnne
Jenkins
2 Coconut Way
Jupiter
FL
33458
321-555-8907
100007
Janet
Williams
58 Redondo Beach Blvd
Torrence
CA
90501
310-555-5678
Using the INSERT INTO command allowed me to insert new values into the Customers table. The values
for each component of Customer information are written in parentheses, separated by commas, in the
order they will appear in according to the column order.
ii.
Orders Table
OrderID
CustomerID
SKU
Description
1204305
100004
ADV-24-10C
Advanced Switch 10GigE Copper 24 port
1204306
100005
ADV-48-10F
Advanced Switch 10 GigE Copper/Fiber 44 port copper 4 port fiber
1204307
100006
ENT-24-10F
Enterprise Switch 10GigE SFP+ 24 Port
1204308
100007
ENT-48-10F
Enterprise Switch 10GigE SFP+ 48 port
Using the INSERT INTO command allowed me to insert new values into the Orders table. The values for
each component of order information are written in parentheses, separated by commas, in the order
they will appear in according to the column order.
D.
In the Customers table, perform a query to count all records where the city is Woonsocket, Rhode Island.
i.
How many records are in the customers table where the field “city” equals “Woonsocket”?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
You are working for SETI, the Search for Extraterrestrial Intelligence. One day, you receive a radio communication from an alien intelligence. Although you cannot understand their language, they have included some photos from an ILove Lucy episode. The photos allow you to determine that it is the episode in which Lucy makes a television commercial on Vitameatavegamin. This episode first aired on CBS on May 5, 1952. Before running to your supervisor to tell him the news, you quickly determine how far away in light-years the alien civilization is.
arrow_forward
What is Donnan's theory? What is its importance in biophysical chemistry?
arrow_forward
board
Instructions
Please select the best answer for each of the questions.
This test has a time limit of 2 hours.This test will save and submit automatically when the time expires.
Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain.
Timed Test
Multiple Attempts Not allowed. This test can only be taken once.
Force Completion Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit
This test does not allow backtracking. Changes to the answer after submission are prohibited.
Your answers are saved automatically.
Remaining Time: 1 hour, 34 minutes, 00 seconds.
* Question Completion Status:
A Moving to the next question prevents changes to this answer.
Question 2
What is the pH of the solution which results from mixing 25 mL of 0.20 M CH3CO>H and 25 mL of 0.20 M NAOH? (K, for CH3CO>H = 1.8 x 10-b)
OA 8.87
OB. 10.43
OC7.00
OD.9 02
OE 5.13
A Moving to the next question prevents changes to this answer.
*-
F11…
arrow_forward
Could you please help me format this question, I've been stuck on it for some time now.
arrow_forward
Do question 2 pleas, don’t return the question please
arrow_forward
This assignment is designed to help you learn how to
determine total costs by combining direct and indirect
costs for a particular department.
In this GHA, you will be determining the total costs for
three departments: (1) Physical Therapy (2)
Occupational Therapy and (3) Speech Therapy.
To determine the total costs, you will need to add the
direct costs to the indirect costs using the template
provided below.
Please use the example provided in the assignment
description if you find that you need some support
understanding the required calculations.
DIRECT COSTS
The direct costs for each department are easily
identifiable, because they are the costs that are directly
attributable to the department.
The direct costs are as follows:
Physical Therapy (PT)
Occupational Therapy (OT)
Speech Therapy (ST)
Total Direct Costs
INDIRECT COSTS
The indirect costs will need to be allocated to Physical
Therapy (PT), Occupational Therapy (OT), and Speech
Therapy (ST).
The indirect costs in this…
arrow_forward
text
Roboto
BIUA
12
1三
主
2.
4.
Baking soda is an essential ingredient for most bread recipes. Without baking soda,
describe how bread would be different. You may focus on taste, texture, bake time,
color, size, or any other relevant characteristics in your response.
arrow_forward
PLEASE DO HELP ME.. NO NEED FOR EXPLANATION...THIS IS JUST A PRACTICE EXERCISE FOR OUR UPCOMING ORAL AND THESE ARE THE SAMPLE QUESTIONS..PLEASE ANSWER SHORTER.. I WILL GIVE HELPFUL RATING AFTER
arrow_forward
Scientists study the impact of changing only one component of a cancer treatment in a laboratory. Which of the following describes the study?
controlled experiment
observational study
conceptual model
computational study
arrow_forward
what is the concentration of the unknown sample using serial diluitions: 0.05M 1.7472nm, 0.025M 0.8569nm, 0.0125M 0.4167nm, 0.00625M 0.1958nm the epsilon value is 0.0101 and l is 1 cm
arrow_forward
Read and interpret the following information using the following abstract from a scientific journal article. In 2-3 sentences, summarize what you understand from this research
arrow_forward
Which one is it?
arrow_forward
Which one is it?
arrow_forward
Please do Question 2
arrow_forward
Sign in to edit and save changes to this file.
1. 121
49ln→
121
+
"5oSn
2. 8Be → 2_
3. 1°4BE → °1B +
4. 8437Rb → °+1e +
128
128
5.
55CS→
54Xe
6. 131m
"s6Ba → oy +
7. 23793Np →42HE +
...
arrow_forward
M
Apple Google Disney ESPN Yahoo! Biomedical Careers Program
☆
CATEG WHOS
r
B
r
SLIVET
H₂ (9) + F2(g) → 2HF(g)
PC15 (9) → PC13 (9) + Cl₂ (9)
CO₂(g) + H₂(g) → CO(g) + H₂O(g)
Apple iCloud Yahoo Images Bing Google Wikipedia Facebook Twitter
D2L b
G 3
2H₂O2 (1) → 2H₂O(1) + O2(g)
prod03-cnow-owl.cengagenow.com
2CO2(g) + 5H2(g) → C2H2 (9) + 4H₂O(g)
D2L
VULLI CETURT JU
D2L
LITUNTUT T
Clear All
AS > 0
AS < 0
COWLv2 |... b
too
close to
decide
SISS
LinkedIn The Weather Channel Yelp TripAdvisor
C
M G с
G
C
VVIML.
+ 88
M
arrow_forward
We were given an activity about observing 2 balloons. 1 balloon is in the basin with cold water and the other balloon is in the basin with hot water we were task to observe it after 1 minute and after 3 minutes and wrote our observation which is the balloon in the basin with hot water expanded and the balloon in the basin with cold water shrunk.
The question is how would we apply our learning on this activity in real life?
arrow_forward
please help asap due tonight!!!
arrow_forward
Bucks McGee, after being poisoned, is currently being treated in the hospital with an
antidote- the chemical Fe(CN)18. The compound is so intensely coloured that even a small
amount of it makes for a black or dark blue suspension.
2022-02-0.
Given that this antidote has never before been administered at the hospital, none of the
doctors or nurses have experience with it. There is one very old bottle of Fe>(CN)18 pills in
the medicine store-room, but the label is worn and the units are in the old, archaic British
Apothecaries' system which has unusual units like drachms, scruples, grains, and mites:
453.6 grams (g)
= 1 pound (Ib)
= 12 ounces (3)
= 96 drachms (3)
= 288 scruples (3)
= 5760 grains (gr)
= 115200 mites (m)
ruu useu tnis antidote long
ugu at dnother hospital, and who seemed to remember that they used to make 0.025 M
solutions of this compound in ethanol and give 45 mL of the solution three times daily.
What critical information is missing from the worn label? How many pills…
arrow_forward
Hello, I hope you are doing well on this fine day. For the following quetion please read carefully the question and instruction. PLEASE ANSWER QUESTION IN 20 MINTUES NOT MORE PLEASE AND THANK YOU. If you do answer the question correctly and post it in the next 20 minutes, NO NEED TO SHOW ALL THE WORK, I JUST WOULD LIKE THE CORRECT ANSWER AS SOON AS POSSIBLE. I will write a wonderful and generous feedback/review/rating about you. NOT ONE HOUR!!! THIS IS A TEXTBOOK QUESTION HURRRY UP PLEASE
You perform the conductivity experiment as described in the lab manual using NaCl solutions of known concentrations. You plot the conductivity of your solutions (μS/m) as a function of the concentration (mol/L). You make a trendline with an equation of y = 1.42 x 105 x + 9.94 x 102. You then test the conductivity of an unknown sample of chicken broth. If the chicken broth conductivity is 7.12 x 103 μS/m. What is the concentration of NaCl in the broth in mol/L?
arrow_forward
MRI machines primarily work using ____.a. The nuclei of carbons in fatty acid chainsb. The nuclei of oxygen atoms from water molecules in the bodyc. The nuclei of hydrogen atoms from water molecules in the bodyd. The nuclei of radioactive isotopes injected into the body
arrow_forward
haspi chemical reactions for living systems supplement
arrow_forward
tes.You will be notified when time expires, and you may continue or submit.
Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain.
Multiple Atternpts Not allowed. This test can only be taken once.
Force Completion Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit.
Remaining Time: 34 minutes, 54 seconds.
Question Completion Status:
A Moving to another question will save this response.
Question 11
The following question pertain to the charting of NMR spectra. MATCH the correct term to the description below.
The exact place on the chart at which a nucleus absorbs (i.e. where the peaks are located) is called its
high-field or upfield side
delta (6)
Chemical shift
МHZ
TMS
A Moving to another question will save this response.
MacBook Air
II
F8
000
O00
F9
F7
F6
F5
F4
F3
F2
&
$
%
#
8
7
6
5
tA4
OOO
arrow_forward
a. What instrument was used to discover the structure of DNA?
b. What shape was expected from the instruments output? VWhy?
c. Who were the four main scientists involved in discovering the structure
of DNA?
d. What did you notice about the process of science represented in the
video? Name at least three things that you noticed.
Edit View Insert
Format
Tools Table
12pt v
Paragraph v
BI
Address
DELL
F4
F5
F6
F7
F8
F9
F10
F11
II
88888:
$
&
4.
6.
7
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Read the buret
arrow_forward
Chapter #3, Question #13:
Consider the following data for total atmospheric column ozone measurements (as DU) at three locations around the Earth, obtained using the TOMS in 2001.
January 15
april 15
july 15
october 15
Tierra del fuego (Chilie, argentina)
323
261
339
206
Nairobi (Kenya)
234
273
266 (Aug. 15)
266
Kiev (Ukraine)
321
420
314
273
Assume that these are typical of values that might be obtained in any other year, and discuss the trends as you move down the columns and along the rows, in terms of your knowledge of stratospheric ozone behavior.
arrow_forward
if you could please help! i submitted this previously and was told that it looks incomplete. the questions are complete and there is no additional information to upload with the questions. again there are 6 questions and i have done a majority of them. i really just need help with question 2 and 3, however, if you could look at my answers for the questions i did and tell me if they are correct i will gladly rate you! thank you so much. I apologize if it is small, i made the font smaller to fit everything on one picture
arrow_forward
Read the following short piece titled "The
Status of Qualitative Research in
Criminology." by Jody Miller, read pages 69-
72.
Discuss the validity and reliability issues in
relation to qualitative studies.
arrow_forward
Dangerous Paint Stripper Jessica has a summer job working for the
city parks program. She has been using a cleaner called “Graffiti Gone” to
remove graffiti from the bathrooms. She has to take a lot of breaks, because
the chemical makes her throat burn. It also makes her feel dizzy sometimes,
especially when the bathrooms don’t have very many windows. On the label, she
sees that the cleaner has methylene chloride in it. She feels like she’s
managing to get the work done, but she is worried about feeling dizzy. She
wants to find out more about this chemical, what harm it can cause, and
whether there are safer ways to do this work.
Questions for following story.
1. What went right in this situation?
2. What went wrong in this situation?
3. What steps should be taken in this workplace to make sure employees are
better protected and prepared the next time?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Chemistry & Chemical Reactivity
Chemistry
ISBN:9781337399074
Author:John C. Kotz, Paul M. Treichel, John Townsend, David Treichel
Publisher:Cengage Learning
Chemistry & Chemical Reactivity
Chemistry
ISBN:9781133949640
Author:John C. Kotz, Paul M. Treichel, John Townsend, David Treichel
Publisher:Cengage Learning
Living By Chemistry: First Edition Textbook
Chemistry
ISBN:9781559539418
Author:Angelica Stacy
Publisher:MAC HIGHER
Introductory Chemistry: A Foundation
Chemistry
ISBN:9781337399425
Author:Steven S. Zumdahl, Donald J. DeCoste
Publisher:Cengage Learning
Related Questions
- You are working for SETI, the Search for Extraterrestrial Intelligence. One day, you receive a radio communication from an alien intelligence. Although you cannot understand their language, they have included some photos from an ILove Lucy episode. The photos allow you to determine that it is the episode in which Lucy makes a television commercial on Vitameatavegamin. This episode first aired on CBS on May 5, 1952. Before running to your supervisor to tell him the news, you quickly determine how far away in light-years the alien civilization is.arrow_forwardWhat is Donnan's theory? What is its importance in biophysical chemistry?arrow_forwardboard Instructions Please select the best answer for each of the questions. This test has a time limit of 2 hours.This test will save and submit automatically when the time expires. Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain. Timed Test Multiple Attempts Not allowed. This test can only be taken once. Force Completion Once started, this test must be completed in one sitting. Do not leave the test before clicking Save and Submit This test does not allow backtracking. Changes to the answer after submission are prohibited. Your answers are saved automatically. Remaining Time: 1 hour, 34 minutes, 00 seconds. * Question Completion Status: A Moving to the next question prevents changes to this answer. Question 2 What is the pH of the solution which results from mixing 25 mL of 0.20 M CH3CO>H and 25 mL of 0.20 M NAOH? (K, for CH3CO>H = 1.8 x 10-b) OA 8.87 OB. 10.43 OC7.00 OD.9 02 OE 5.13 A Moving to the next question prevents changes to this answer. *- F11…arrow_forward
- Could you please help me format this question, I've been stuck on it for some time now.arrow_forwardDo question 2 pleas, don’t return the question pleasearrow_forwardThis assignment is designed to help you learn how to determine total costs by combining direct and indirect costs for a particular department. In this GHA, you will be determining the total costs for three departments: (1) Physical Therapy (2) Occupational Therapy and (3) Speech Therapy. To determine the total costs, you will need to add the direct costs to the indirect costs using the template provided below. Please use the example provided in the assignment description if you find that you need some support understanding the required calculations. DIRECT COSTS The direct costs for each department are easily identifiable, because they are the costs that are directly attributable to the department. The direct costs are as follows: Physical Therapy (PT) Occupational Therapy (OT) Speech Therapy (ST) Total Direct Costs INDIRECT COSTS The indirect costs will need to be allocated to Physical Therapy (PT), Occupational Therapy (OT), and Speech Therapy (ST). The indirect costs in this…arrow_forward
- text Roboto BIUA 12 1三 主 2. 4. Baking soda is an essential ingredient for most bread recipes. Without baking soda, describe how bread would be different. You may focus on taste, texture, bake time, color, size, or any other relevant characteristics in your response.arrow_forwardPLEASE DO HELP ME.. NO NEED FOR EXPLANATION...THIS IS JUST A PRACTICE EXERCISE FOR OUR UPCOMING ORAL AND THESE ARE THE SAMPLE QUESTIONS..PLEASE ANSWER SHORTER.. I WILL GIVE HELPFUL RATING AFTERarrow_forwardScientists study the impact of changing only one component of a cancer treatment in a laboratory. Which of the following describes the study? controlled experiment observational study conceptual model computational studyarrow_forward
- what is the concentration of the unknown sample using serial diluitions: 0.05M 1.7472nm, 0.025M 0.8569nm, 0.0125M 0.4167nm, 0.00625M 0.1958nm the epsilon value is 0.0101 and l is 1 cmarrow_forwardRead and interpret the following information using the following abstract from a scientific journal article. In 2-3 sentences, summarize what you understand from this researcharrow_forwardWhich one is it?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Chemistry & Chemical ReactivityChemistryISBN:9781337399074Author:John C. Kotz, Paul M. Treichel, John Townsend, David TreichelPublisher:Cengage LearningChemistry & Chemical ReactivityChemistryISBN:9781133949640Author:John C. Kotz, Paul M. Treichel, John Townsend, David TreichelPublisher:Cengage LearningLiving By Chemistry: First Edition TextbookChemistryISBN:9781559539418Author:Angelica StacyPublisher:MAC HIGHER
- Introductory Chemistry: A FoundationChemistryISBN:9781337399425Author:Steven S. Zumdahl, Donald J. DeCostePublisher:Cengage Learning
Chemistry & Chemical Reactivity
Chemistry
ISBN:9781337399074
Author:John C. Kotz, Paul M. Treichel, John Townsend, David Treichel
Publisher:Cengage Learning
Chemistry & Chemical Reactivity
Chemistry
ISBN:9781133949640
Author:John C. Kotz, Paul M. Treichel, John Townsend, David Treichel
Publisher:Cengage Learning
Living By Chemistry: First Edition Textbook
Chemistry
ISBN:9781559539418
Author:Angelica Stacy
Publisher:MAC HIGHER
Introductory Chemistry: A Foundation
Chemistry
ISBN:9781337399425
Author:Steven S. Zumdahl, Donald J. DeCoste
Publisher:Cengage Learning