DAD 220 Module Two Activity Template
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Chemistry
Date
Feb 20, 2024
Type
docx
Pages
1
Uploaded by Mastersteel03
DAD 220 Module Two Activity Template
Replace the bracketed text in this template with your answers and any supporting screenshots. Then submit it for the Module Two table and SQL identification activity. You’ll need to download this template, save it as a unique file, and then submit it for grading. Rename this document to include your last name and remove these instructions before submitting. Using the tables and SQL statements from the prompt for Module Two Activity, answer the following questions. Replace the bracketed text with your answers and any supporting screenshots.
1.
How many records are shown in the Employee table?
Five.
2.
How many attributes are there in the Branches table?
Two.
3.
Which attribute could be a primary key for the Employee table?
Employee ID
4.
How many decimal places (maximum) can be stored in an employee’s salary field?
Two, by the decimal.
5.
How many decimal places (maximum) can a Department_ID have?
One.
6.
What three rules do tables obey?
One value allowed in each cell; duplicate column names not allowed in one table. No two rows may
have the same values.
7.
Is the Employee table normalized? How do you know?
Yes, it is normalized due to the fact that the value in that cell only.
8.
What is the result of the following query?
Select sum(Salary) from Employee where Department_ID=3;
80000+90000= 1700000
9.
Identify the Employee ID(s) that would be returned as a result of the following query.
Select * from Employee where Classification <> 'Exempt';
Two.
10.
What is the result of the following query?
Select max(Salary) from Employee;
9000
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
[References]
Use the References to access important values if needed for this question.
Taking logarithms and antilogarithms is necessary to solve many chemistry problems. For practice, complete the following table, where N is a number.
log N
7.92
1.867
-1.402
Submit Answer
Retry Entire Group
4 more group attempts remaining
Previous
Next
Save and Exit
arrow_forward
omfg answer this
arrow_forward
口
A docs.google.com
Classroom | Google for Education
Alchemy Lesson 20 & 21 Worksheet
Andres Carrill
Andres Carrillo - Alchemy Lessons 20 & 21 Worksheet
Update Apple ID S
Some account servi
available until you sig
File Edit View Insert Format Tools Add-ons Help
Last edit was 2 days ago
100%
Normal text
Arial
11
BIUA
E = E = EE E - E E X
1
2
3
4
.. 6 I 7 O 8 1 IC
5
AIV-20: Getting Connected (Writing lonic Compounds)
Part 1: Putting together lonic Compounds
lonic compound
Metal
Number of
cation
nonmetal
number of
anion
total
total charge = 0
valence
valence
number of
electrons
electrons
valence
electrons
NaF, sodium fluoride
Na
Na +
(+1)+(-1) = 0
F-
8.
MgO, magnesium oxide
Mg
02-
(+2) + (-2) = 0
MgCl2, magnesium
chloride
Mg
CI
7
16
(+2) + 2(-1) = 0
Ne, neon
Ne
8
BeF2, beryllium fluoride
Be
MgS, magnesium sulfide
CaCl,, calcium chloride
Na
Br
K
Se
Al
Al203, aluminum oxide
Al
Al
F
arrow_forward
Methods of Analysis
Test #1: Polarity, or Effect of a charged rod on a stream of liquid:
This test was used to determine the relative polarity of the unknown liquid. The liquid was allowed to run out of a buret and a charged rod was brought up next to the stream. The observations were reported as to whether or not the stream of liquid responded to the charged rod and to what degree.
Try this at home with water and a plastic spoon. Rub the plastic spoon against a sweater and move it close to a small stream of water running out of your faucet!
Test #2: Volatility, or Rate of Evaporation:
A thermometer probe was wrapped with a strip of filter paper. This assembly was soaked in one of the liquids for one minute. The probe was removed, and the temperature change was monitored as the liquid evaporated. The results are given in Graph 1 below. (See Graph)
Graph 1: The curves generated of the change in temperature over time for the substances acetone, hydrogen monoxide, ethylene glycol,…
arrow_forward
In general,the color that we see is __to the color absorbed.
What words should be put in the blank?
arrow_forward
Pls help ASAP
arrow_forward
Complete the table below. Round each of your entries to 2 significant digits. You may assume the temperature is 25 °C.
formula
$
4
conjugate acid
0
Hạ BO,
HCH, CO₂
S
R
Explanation
*
25
%
K₁
0
-10
5.8 × 10
T
1.8 × 10
Check
80
6
Y
formula
CIO
conjugate base
K₂
0
&
MacBook Pro
7
3.3 × 10
-7
1.72 × 10
8
-5
00
(
9
X
➡
C
)
3
O
x10
© 2023 McGraw Hill LLC. All Rights Reserved. Terms of t
-
D
O
+
arrow_forward
I'm resending this question because the image on the last one was blurry. I wrote the prompt and steps and helpful conversions to figuring out the real world problem on my scratch paper, how do I solve for this problem?
arrow_forward
PLEASE ANSWER ALL OF THE QUESTIONS ON THE PICTURE, PLEASE.
arrow_forward
I need help understanding how to do this, can you please show me how you get the CFU/mL
arrow_forward
phs.blackboard.com/webapps/assessment/take/take.jsp?course_assessment_id%3D 36688_1&course_id%3D_31958 1&content_id%3_1130567_1&-
8r
10
13 140 15
16
20
11
12
17
18
19
20
A Moving to another question will save this response.
Quèstion 6
Select the statement that is not supported by the following equation:
q=0=(mwater)(Cwater)(ATwater)+ (mmetal)(Cmetal)( ATmetal)
The total change in heat is the sum of the changes in heat of water and a metal.
Energy is conserved.
Energy is transferred between water and a metal.
Energy is lost during a calorimetry experiment.
A Moving to another question will save this response.
hp
&
%23
9.
6.
00
进3
arrow_forward
Please mark the correct charges on my picture directly, and post in the answer column. I'll give a thumb up.Thank you very much.
arrow_forward
Please let me know which 2 answers are correct, an explanation including evidence
arrow_forward
Part A
transcript When glucose (C6H12O6 (s)) is consumed, it reacts with O₂ gas in the body to produce gaseous carbon dioxide and liquid water. Enter the balanced chemical equation for the reaction.
Express your answer as a chemical equation including phases.
0
ΑΣΦ
?
A chemical reaction does not occur for this question.
Submit Previous Answers Request Answer
arrow_forward
Name the following compounds based on their stock and classical method
Stock Method Classical Method
Ex. CuI Copper (I) Iodide Cuprous Iodide
Chemical Formula Stock Method
Fe(CIO3)2
Sn₂SiO4
AUPO3
TIIO
NIBO3
MnC204
Cr2(CO3)3
CoMnO4
Sb₂(SO3)5
Classical Method
arrow_forward
Drag and drop each term to correctly complete the prompt.
Compounds are formed when two or more
substance is formed with new chemical and physical
simpler substances by
elements.
are chemically combined. When these elements are
d. Terms | Privacy PHONE 1-877-377-9537 | FAX 1-877-816-0808 Blog
An element is a
:: chemically :: elements :: physical :: pure
hp
or chemical means. A compound is two or more elements
substance. When two or more elements chemically combine, the compound has new properties, different from the chemical and physical properties of the
8 of 8
substance that cannot be separated into
:: original :: properties
combined, a new
chemically to produce a new
:: combined
C
arrow_forward
Part B
il
Spell out the full name of the compound.
Submit Previous Answers Request Answer
X Incorrect; Try Again
Part C
Spell out the full name of the compound.
Submit Request Answer
Part D
CI
Spell out the full name of the compound.
Submit Request Answer
arrow_forward
x
Spell out the full name of the compound.
Submit Request Answer
Part B
Spell out the full name of the compound.
Submit Request Answer
Part C
Spell out the full name of the compound.
Submit Request Answer
Br
Part D
Spell out the full name of the compound.
arrow_forward
Answer question 7 please
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you


Chemistry: The Molecular Science
Chemistry
ISBN:9781285199047
Author:John W. Moore, Conrad L. Stanitski
Publisher:Cengage Learning

Introductory Chemistry: A Foundation
Chemistry
ISBN:9781337399425
Author:Steven S. Zumdahl, Donald J. DeCoste
Publisher:Cengage Learning
Related Questions
- [References] Use the References to access important values if needed for this question. Taking logarithms and antilogarithms is necessary to solve many chemistry problems. For practice, complete the following table, where N is a number. log N 7.92 1.867 -1.402 Submit Answer Retry Entire Group 4 more group attempts remaining Previous Next Save and Exitarrow_forwardomfg answer thisarrow_forward口 A docs.google.com Classroom | Google for Education Alchemy Lesson 20 & 21 Worksheet Andres Carrill Andres Carrillo - Alchemy Lessons 20 & 21 Worksheet Update Apple ID S Some account servi available until you sig File Edit View Insert Format Tools Add-ons Help Last edit was 2 days ago 100% Normal text Arial 11 BIUA E = E = EE E - E E X 1 2 3 4 .. 6 I 7 O 8 1 IC 5 AIV-20: Getting Connected (Writing lonic Compounds) Part 1: Putting together lonic Compounds lonic compound Metal Number of cation nonmetal number of anion total total charge = 0 valence valence number of electrons electrons valence electrons NaF, sodium fluoride Na Na + (+1)+(-1) = 0 F- 8. MgO, magnesium oxide Mg 02- (+2) + (-2) = 0 MgCl2, magnesium chloride Mg CI 7 16 (+2) + 2(-1) = 0 Ne, neon Ne 8 BeF2, beryllium fluoride Be MgS, magnesium sulfide CaCl,, calcium chloride Na Br K Se Al Al203, aluminum oxide Al Al Farrow_forward
- Methods of Analysis Test #1: Polarity, or Effect of a charged rod on a stream of liquid: This test was used to determine the relative polarity of the unknown liquid. The liquid was allowed to run out of a buret and a charged rod was brought up next to the stream. The observations were reported as to whether or not the stream of liquid responded to the charged rod and to what degree. Try this at home with water and a plastic spoon. Rub the plastic spoon against a sweater and move it close to a small stream of water running out of your faucet! Test #2: Volatility, or Rate of Evaporation: A thermometer probe was wrapped with a strip of filter paper. This assembly was soaked in one of the liquids for one minute. The probe was removed, and the temperature change was monitored as the liquid evaporated. The results are given in Graph 1 below. (See Graph) Graph 1: The curves generated of the change in temperature over time for the substances acetone, hydrogen monoxide, ethylene glycol,…arrow_forwardIn general,the color that we see is __to the color absorbed. What words should be put in the blank?arrow_forwardPls help ASAParrow_forward
- Complete the table below. Round each of your entries to 2 significant digits. You may assume the temperature is 25 °C. formula $ 4 conjugate acid 0 Hạ BO, HCH, CO₂ S R Explanation * 25 % K₁ 0 -10 5.8 × 10 T 1.8 × 10 Check 80 6 Y formula CIO conjugate base K₂ 0 & MacBook Pro 7 3.3 × 10 -7 1.72 × 10 8 -5 00 ( 9 X ➡ C ) 3 O x10 © 2023 McGraw Hill LLC. All Rights Reserved. Terms of t - D O +arrow_forwardI'm resending this question because the image on the last one was blurry. I wrote the prompt and steps and helpful conversions to figuring out the real world problem on my scratch paper, how do I solve for this problem?arrow_forwardPLEASE ANSWER ALL OF THE QUESTIONS ON THE PICTURE, PLEASE.arrow_forward
- I need help understanding how to do this, can you please show me how you get the CFU/mLarrow_forwardphs.blackboard.com/webapps/assessment/take/take.jsp?course_assessment_id%3D 36688_1&course_id%3D_31958 1&content_id%3_1130567_1&- 8r 10 13 140 15 16 20 11 12 17 18 19 20 A Moving to another question will save this response. Quèstion 6 Select the statement that is not supported by the following equation: q=0=(mwater)(Cwater)(ATwater)+ (mmetal)(Cmetal)( ATmetal) The total change in heat is the sum of the changes in heat of water and a metal. Energy is conserved. Energy is transferred between water and a metal. Energy is lost during a calorimetry experiment. A Moving to another question will save this response. hp & %23 9. 6. 00 进3arrow_forwardPlease mark the correct charges on my picture directly, and post in the answer column. I'll give a thumb up.Thank you very much.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Chemistry: The Molecular ScienceChemistryISBN:9781285199047Author:John W. Moore, Conrad L. StanitskiPublisher:Cengage Learning
- Introductory Chemistry: A FoundationChemistryISBN:9781337399425Author:Steven S. Zumdahl, Donald J. DeCostePublisher:Cengage Learning


Chemistry: The Molecular Science
Chemistry
ISBN:9781285199047
Author:John W. Moore, Conrad L. Stanitski
Publisher:Cengage Learning

Introductory Chemistry: A Foundation
Chemistry
ISBN:9781337399425
Author:Steven S. Zumdahl, Donald J. DeCoste
Publisher:Cengage Learning