Freire, Veronica_DAD 220 Module Two Activity
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
2
Uploaded by PrivateIce3976
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?
There are 5 records shown in the Employee table.
2.
How many attributes are there in the Branches table?
There are 2 attributes in the Branches table: Department_ID and Department_Name.
3.
Which attribute could be a primary key for the Employee table?
The “Employee_ID” attribute could be a primary key for the Employee table since it appears to uniquely
identify each employee.
4.
How many decimal places (maximum) can be stored in an employee’s salary field?
The employee’s salary field can store a maximum of 2 decimal places.
5.
How many decimal places (maximum) can a Department_ID have?
The Department_ID does not have any decimal places because it is a type of SMALLINT.
6.
What three rules do tables obey?
Tables obey three rules: each column must have a unique name, the order of columns is not significant,
and each row must be unique. 7.
Is the Employee table normalized? How do you know?
The Employee table does not seem to be fully normalized. One indication is that the “Classification”
column contains NULL values. NULL values are typically avoided in a fully normalized table. 8.
What is the result of the following query?
Select sum(Salary) from Employee where Department_ID=3;
The results of the query”Select sum(Salary) from Employee where Department_ID=3;”
would be the sum of the salaries of employees belonging to the department
with ID 3.
9.
Identify the Employee ID(s) that would be returned as a result of the following query.
Select * from Employee where Classification <> 'Exempt';
The Employee ID(s) that would return as a result of “
Select * from Employee where
Classification <> 'Exempt';” are 101,103, and 104.
10.
What is the result of the following query?
Select max(Salary) from Employee;
The result of the query “
Select max(Salary) from Employee;” would be the
maximum value among the salaries of all employees.
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 Documents
Related Questions
lithium hydrogen sulfite
Express your answer as a chemical formula.
ΑΣφ
A chemical reaction does not occur for this question.
Submit
Previous Answers Request Answer
X Incorrect; Try Again; 5 attempts remaining
Part B
sodium permanganate
Express your answer as a chemical formula.
?
arrow_forward
+
du/ultra/courses/_514124_1/cl/outline
1 →
Remaining Time: 56 minutes, 57 seconds.
Question Completion Status:
QUESTION 1
Match the name with the formula. You will need to determine FIRST if the name/formula is IONIC of
COVALENT (Simple Binary Molecular). Then name from there. It is easy to get confused so determine WHICH
category it is in first and go from there.
✓p 3-
✓ PO43-
✓ NH4NO3
✓ KNO3
✓KCI
✓ H₂CO3
- H3PO4
QUESTION 2
A. carbonic acid
B. nitrogen nitrate
C. None of these
D. nitric acid
E. phosphide
F. nitrogen ammonium
G. phosphate
H. potassium coride
1. ammonium nitrate
J. phosphoric acid
K. trinitrogen hydride
▬▬
L. ammonium nitrogen trioxide
M. potassium nitrate
Click Save and Submit to save and submit. Click Save All Answers to save all answers.
1.
Save All Answv
arrow_forward
Can you answer a and b please?
arrow_forward
Sea X
Assignments: ANATO X Gi
0220907135028396%20(1).pdf
2
CD Page view
Human Anatomy X
A Read aloud
*20220907135028396 X
TAdd text
Draw
4 You prepare four solutions:
Solution 1: Reactants + enzyme at #0 (about 100°F) and pH 7
Chemistry
Check your recall lab. x
V
Highlight
UNIT 2 65
3 Decompression sickness (also known as the bends) is a condition that affects divers and others operating under
pressurized conditions. It occurs when gases such as nitrogen (N₂) come out of solution in the blood. This can
lead to symptoms including joint pain, shortness of breath, and paralysis. Severe cases may result in death.
a What type of molecule (ionic, polar covalent, nonpolar covalent) is nitrogen gas?
b The liquid medium of blood is water. What type of compound (ionic, polar covalent, nonpolar covalent) is
water?
c What happens when molecules such as nitrogen gas mix with water? How does this explain the problems we
see with decompression sickness?
arrow_forward
Please do Question 2
arrow_forward
I need answers for # 2-9 on this worksheet
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
student found a bottle of unknown origin in the basement of an
"CAUTION—contains С₁H₁O.” No other
A
old house. The bottle was labelled
information was given, but inside the bottle were some white crystals.
The student took the bottle to a chemistry laboratory, where she analyzed the
crystals with the help of the laboratory staff. C₁2H₁6O reacted with Br₂ in CCl4
adding one mole of Br, and forming C₁₂H₁OB2₂.
When a sample of C₁₂H₂O was reacted with O3 followed by Zn/H₂O, two
different samples, J and K, were obtained. Compound J had a molecular formula
of C.HgO₂, and its NMR is shown below.
Compound K had a molecular formula of C₂H₂O, and it could be oxidized to
compound L, with a molecular formula of C₂H₂O₂. The IR spectrum of L showed
a very wide, strong band centred around 3000 cm*¹. The NMR spectrum of L
showed only two different absorptions: a doublet (6H) at 0.9 ppm and a septet
(1H) at 3.6 ppm. There was also a singlet (1H) off the scale at 11.8 ppm.
students, deduce possible…
arrow_forward
PLEASE ANSWER ALL OF THE QUESTIONS ON THE PICTURE, PLEASE.
arrow_forward
Cla
Unit 1 Review Answer KEY- Goo X
it 1 Quiz #4 Properties of MathX
cl.castlelearning.com/Review/CLO/Student/Assignment/Questi
Home - Hudl
M East Rochest
Quizlet Live Quizlet
schools.org bookmarks
Unit 1 Quiz #4 Pro
1 of 10
Question 1
Review
Which statement describes a chemical property of hydrogen gas?
1.
Hydrogen gas burns in air.
2.
Hydrogen gas is colorless.
3.
Hydrogen gas has a density of 0.000 09 g/cm at STP.
4.
Hydrogen gas has a boiling point of 20. K at standard pre
Standard
arrow_forward
Here are the formulas for each substance:
Sucrose: C12H22O11C_{12}H_{22}O_{11}C12H22O11
Copper (I) Chloride: CuClCuClCuCl
Iodine: I2I_2I2
Potassium Iodide: KIKIKI
Our goal is to try to find a pattern for which compounds conduct electricity when dissolved in water, and which don't.
One hint is to look for patterns in which kinds of atoms form substances that conduct when dissolved, and which kinds of atoms form substances that don't conduct when dissolved.
Here is a periodic table you can use.
Let's start by finding the location on the periodic table for the atoms for substances that conduct when dissolved. What do you notice about where the atoms are?
arrow_forward
How can I solve this question? I need full detail and accurate answer.
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
Fill in the blanks. Since you cannot input superscripts and subscripts directly, please follow this
format:
e.g. H20 should be written as H>2O; Fe3+ should be written as Fe^3+; Cr,0,2- should be written
as Cr>20>7^2-
*> to denote subscript, ^to denote superscript
*This is just implemented in our class, for canvas to recognize your answers. You must still
understand that superscripts and subscripts are the proper way of writing chemical formulas
Please take note of the numbers in the answer box.
Formula of Formula of Chemical Formula
Name of Compound
Cation
Anion
of Compound
K+
Cr20,2-
Mg2+
CN
Ca2+
PO43-
arrow_forward
Use the data listed in the supporting materials to calculate the equilibrium constant, Kp, for the synthesis of HCI at 298.15 K.
H2(g) + Cl2(g) =2 HCI(g)
4.0
2.47e33
What is the value of Kp if the equilibrium is expressed as below?
1/2 H2(g) + 1/2 Cl2(g) = HCI(g)
4.0
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
Which statement about detecting temperature is TRUE?
Nociceptors detect small changes in temperature.
Your skin has an equal distribution of temperature receptors.
There are separate receptors for hot and cold.
There are over 20 types of temperature receptors.
arrow_forward
Use the acidity model
pH = −log[H+],
where acidity (pH) is a measure of the hydrogen ion concentration [H+] (measured in moles of hydrogen per liter) of a solution.Find the pH when
[H+] = 4.7 × 10−5.
(Round your answer to two decimal places.)pH =
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
- lithium hydrogen sulfite Express your answer as a chemical formula. ΑΣφ A chemical reaction does not occur for this question. Submit Previous Answers Request Answer X Incorrect; Try Again; 5 attempts remaining Part B sodium permanganate Express your answer as a chemical formula. ?arrow_forward+ du/ultra/courses/_514124_1/cl/outline 1 → Remaining Time: 56 minutes, 57 seconds. Question Completion Status: QUESTION 1 Match the name with the formula. You will need to determine FIRST if the name/formula is IONIC of COVALENT (Simple Binary Molecular). Then name from there. It is easy to get confused so determine WHICH category it is in first and go from there. ✓p 3- ✓ PO43- ✓ NH4NO3 ✓ KNO3 ✓KCI ✓ H₂CO3 - H3PO4 QUESTION 2 A. carbonic acid B. nitrogen nitrate C. None of these D. nitric acid E. phosphide F. nitrogen ammonium G. phosphate H. potassium coride 1. ammonium nitrate J. phosphoric acid K. trinitrogen hydride ▬▬ L. ammonium nitrogen trioxide M. potassium nitrate Click Save and Submit to save and submit. Click Save All Answers to save all answers. 1. Save All Answvarrow_forwardCan you answer a and b please?arrow_forward
- Sea X Assignments: ANATO X Gi 0220907135028396%20(1).pdf 2 CD Page view Human Anatomy X A Read aloud *20220907135028396 X TAdd text Draw 4 You prepare four solutions: Solution 1: Reactants + enzyme at #0 (about 100°F) and pH 7 Chemistry Check your recall lab. x V Highlight UNIT 2 65 3 Decompression sickness (also known as the bends) is a condition that affects divers and others operating under pressurized conditions. It occurs when gases such as nitrogen (N₂) come out of solution in the blood. This can lead to symptoms including joint pain, shortness of breath, and paralysis. Severe cases may result in death. a What type of molecule (ionic, polar covalent, nonpolar covalent) is nitrogen gas? b The liquid medium of blood is water. What type of compound (ionic, polar covalent, nonpolar covalent) is water? c What happens when molecules such as nitrogen gas mix with water? How does this explain the problems we see with decompression sickness?arrow_forwardPlease do Question 2arrow_forwardI need answers for # 2-9 on this worksheetarrow_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_forwardstudent found a bottle of unknown origin in the basement of an "CAUTION—contains С₁H₁O.” No other A old house. The bottle was labelled information was given, but inside the bottle were some white crystals. The student took the bottle to a chemistry laboratory, where she analyzed the crystals with the help of the laboratory staff. C₁2H₁6O reacted with Br₂ in CCl4 adding one mole of Br, and forming C₁₂H₁OB2₂. When a sample of C₁₂H₂O was reacted with O3 followed by Zn/H₂O, two different samples, J and K, were obtained. Compound J had a molecular formula of C.HgO₂, and its NMR is shown below. Compound K had a molecular formula of C₂H₂O, and it could be oxidized to compound L, with a molecular formula of C₂H₂O₂. The IR spectrum of L showed a very wide, strong band centred around 3000 cm*¹. The NMR spectrum of L showed only two different absorptions: a doublet (6H) at 0.9 ppm and a septet (1H) at 3.6 ppm. There was also a singlet (1H) off the scale at 11.8 ppm. students, deduce possible…arrow_forwardPLEASE ANSWER ALL OF THE QUESTIONS ON THE PICTURE, PLEASE.arrow_forward
- Cla Unit 1 Review Answer KEY- Goo X it 1 Quiz #4 Properties of MathX cl.castlelearning.com/Review/CLO/Student/Assignment/Questi Home - Hudl M East Rochest Quizlet Live Quizlet schools.org bookmarks Unit 1 Quiz #4 Pro 1 of 10 Question 1 Review Which statement describes a chemical property of hydrogen gas? 1. Hydrogen gas burns in air. 2. Hydrogen gas is colorless. 3. Hydrogen gas has a density of 0.000 09 g/cm at STP. 4. Hydrogen gas has a boiling point of 20. K at standard pre Standardarrow_forwardHere are the formulas for each substance: Sucrose: C12H22O11C_{12}H_{22}O_{11}C12H22O11 Copper (I) Chloride: CuClCuClCuCl Iodine: I2I_2I2 Potassium Iodide: KIKIKI Our goal is to try to find a pattern for which compounds conduct electricity when dissolved in water, and which don't. One hint is to look for patterns in which kinds of atoms form substances that conduct when dissolved, and which kinds of atoms form substances that don't conduct when dissolved. Here is a periodic table you can use. Let's start by finding the location on the periodic table for the atoms for substances that conduct when dissolved. What do you notice about where the atoms are?arrow_forwardHow can I solve this question? I need full detail and accurate answer.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