Garcia Module Three Major Activity Database Documentation
.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
4
Uploaded by MajorIce7236
DAD 220 Module Three Major Activity Database Documentation Template DAD 220
Professor Gross
Jarrod Garcia
10 November 2023
Overview
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 show. 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 help. Create a Database
1.
In your integrated development environment (IDE), create a database schema called QuantigrationRMA. List out the database name. Provide the SQL commands you ran to successfully complete this in your answer, then connect to it:
[Code used: Create database QuantigrationRMA, show database, use QuantigrationRMA]
2.
Using the entity relationship diagram (ERD) as a reference, create the following
tables with the appropriate attributes and keys
:
a.
A table named customers in the QuantigrationRMA database as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
[Code Used: CREATE TABLE Customers (
Customer_ID INT,
First_Name VARCHAR(25),
Last_Name VARCHAR(25),
Street VARCHAR(50),
City VARCHAR(50),
State VARCHAR(25),
ZipCode VARCHAR(10),
Telephone VARCHAR(15),
PRIMARY KEY (Customer_ID));]
b.
A table named orders in the QuantigrationRMA database as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
[Code Used: CREATE TABLE Orders (Order_ID INT, Customer_ID INT, SKU VARCHAR(20), Description
VARCHAR(50), PRIMARY KEY (Order_ID), FOREIGN KEY (Customer_ID) REFERENCES
Customers(Customer_ID));
c.
A table named rma
in the QuantigrationRMA database as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
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
3) Carbon-14 is constantly being produced in the upper atmosphere, and the amount is in
equilibrium. As long as an organism is alive, it keeps its carbon isotopes in balance with the
atmosphere, but at soon as it dies, it stops taking up new 14C, and so the geologic clock starts.
You found a shell buried in sedimentary layers, which has 6% of its original 14C left.
Determine the age of the shell. Show your work.
arrow_forward
SS C
cm 1 GtG tC
FCX
in
SH
U njmpLGQQmzAe4FI77iAeY/edit#slide%-id.g112e600b836_0_44
个
Help Accessibility
Last edit was 2 hours ago
Arial
21
BIUA
work Day 1-
18
What were some potential
human errors that could
have occurred when
calculating the mass before
and after the reaction?
Add these to your drawing
on page 60.
arrow_forward
Hydrochloric acid can be prepared by the following reaction:
2NACI(s) + H2SO4(aq)2HCI(g) + Na2SO4(s)
What mass of HCI can be prepared from 2.00 mol H SO4 and 150. g NaCl?
Multiple Choice
2.57 g
167 g
93.6 g
11
asus COLLECTION
prt sc
delete
112/A
insert
f7
f8
f11
arrow_forward
Question : Some deposits were observed in water preserved in aluminum containers after two to three days. What could the deposit be ? What is the reason for the formation of these deposits ?
Kindly Do not Spam or Copy from Other Websites
Give Proper Answer with Correct Explanation
Asking this Question with a hope to get correct answer
Bored of Seeing Internet Answers
All the Best for Solving this Question
arrow_forward
Which one is it?
arrow_forward
A Water Quality Standard will be developed for radioactive isotope “Iron-55” which has physical (radioactive) and biological half-lives of 2.7 and 1.6 years, respectively. Through toxicological studies scientists decided “spleen” as the critical organ and the critical accumulation of Iron-55 in spleen has been determined to be 0.5 gram. Assuming radioactive exposure is only due to drinking water consumption and average life expectancy is 75 years.
a) What should be the Maximum Concentration Level (MCL) as mg/L for Iron-55 in drinking water.
b) How long does it take to eliminate 95% of this radioactive isotope from human spleen after the person gives up on drinking water contaminated with Iron-55?
arrow_forward
Part A
Which route would be better: one that produces a small amount of hazardous waste or one that produces a large amount of nonhazardous waste? Which green chemistry metric accounts for this dilemma?
Match the items in the left column to the appropriate blanks in the sentences on the right.
Reset Help
minimize
The best route is
because it should
the E-factor and
maximize
the effective mass yield.
the one that produces a small
The
accounts for this dilemma as it looks at the amount of
relative to
amount of hazardous waste
the amount of
E-factor
product made
the one that produces a large
amount
nonhazardous
waste
materials used
difficult to choose
hazardous reagents used
waste produced
Submit
Previous Answers Request Answer
arrow_forward
Create a model that explains a nuclear reaction within the context of its application :
Nuclear fission reactors
An equation for the nuclear reaction in your model
A visual representation of the nuclear reaction occurring
A written explanation of the reaction and how energy and matter are transformed and conserved throughout the reaction
The context and/or application of the nuclear reaction
Where does the reaction occur?
What impact or relevance does this reaction have to society?
arrow_forward
You will research how the energy is extracted or produced and try to be very
detailed about the process and the chemistry involved (stating equations and
reactions). You will also research the impact on the environment when using
or producing fuels.
Investigating fossil fuel: How is it produced? What is the chemistry involved
(stating equations and reactions)? What is the impact on the environment?
300-400 words
Investigating nuclear energy: How is it produced? What is the chemistry
involved (stating equations and reactions)? What is the impact on the
environment? 300-400 words
Investigating biofuel: How is it produced? What is the chemistry involved
(stating equations and reactions)? What is the impact on the environment?
300-400 words
arrow_forward
Answer question 1 please
arrow_forward
+
terface/acellus_engine.htm?ClassID=1467683063
Use the data below to determine the
mass ratio of iron to oxygen for
compound 2.
Compound
1
2
Et
onal Academy of Science. All Rights Reserved.
Mass Fe
(grams)
15.55
20.98
[20:1
Enter the answer that belongs in the green box.
Iron Ratio Cmpd 2
Mass O
(grams)
4.45
9.02
Sh
Enter
arrow_forward
Dr. X claims that she has found a new remedy (carrot extract) to cure acne. She scores an interview with the science writer for a local newspaper, and gets a brief article written about her and her claims in that newspaper. The article does not contain any experimental evidence, but mentions that Dr. X accidentally splashed some carrot extract on her face and found that the acne was reduced a few days later. Student Y finds the article and cites it as a source for a paper he is writing for class, as evidence that acne has been cured.
(a) Is this finding a fact, a theory, a hypothesis, or an observation? Explain why you think so.
(b) Was it OK for Student Y to use the newspaper article as evidence for his paper? Explain why or why not.
arrow_forward
Firefox
File
Edit
View
History
Bookmarks
Tools
Window Help
my.CSMD.edu
I
Module 12 HW Chi
wr NWP Assessme X
De Module 9 HW Cha
W NWP Assessment
I Module 11 HW Che
w NWP Assessment
O 8 https://education.wiley.com/was/ui/v2/assessment-player/index.html?launchld=b0085ec6-77d3-4053-89d4-c26a8188beb3-
E Module 12 HW Chapter 21 - Selected Exercises
Question 5 of 8
-/1 E
Starting with diethyl malonate, and using any other reagents of your choice, show how you would prepare the following
compound:
Fill
1) ?
2) ?
Que
Multi
EtO
3)?
4) ?
5) ?
Choose from the following list of reagents:
OEt
HO.
Ques
Multipa
Questi
A
B
D
Multistep
CH3Br
LIAIH4
LDA
NaOEt / EtOH
Viewing
Multipart
Question
E
G
H.
Molecular Dra
NaOH
EtBr
MgBr, H,O
H20, heat
heat
Question 7
Multipart
Question 8
Multistep
MacBook Air
esc
F2
F3
F4
FS
F10
@
23
$
%
&
1
2
3
4
7
8
W
E
R
Y
tab
A
S
D
F
caps lock
C
V
shift
alt
coms
control
option
command
arrow_forward
What Do you think the old stuff and the new stuff on the chemical reaction it makes a sparker light up
arrow_forward
CD Page view
O₂N
A Read aloud
1015MSC Chemistry of Biological Systems II 2020
OH
TAdd text
Dra
arrow_forward
It is found that 2.0 x 10-5 mol 222Rn (t/2 = 3.82 d, atom mass = 222) has seeped into a closed
%3D
%3D
basement with a volume of 2.0 x 103 m3.
How many atoms of 222Rn will remain after 24 hours?
A. 2.5 x 1018
B. 1.0 x 1019
C. 8.5 x 1018
D. 4.3 x 1020
arrow_forward
3) You're wandering around and come upon an interesting looking rock. The rock is slightly
radioactive, so you analyze it. The resulting data is as follows:
Elapsed Time
(s)
Counts
962
50
891
100
718
150
598
200
531
250
448
300
413
350
334
400
308
450
287
500
202
550
178
600
154
a. Calculate the value of k using any two of the above data points.
b. Use your value of k to determine the half-life of this sample.
arrow_forward
Compare and contrast acid rain with the concept of acid mine drainage. How are these similar and different in terms of sources, environmental impact, and remediation?
encoded answers please
arrow_forward
Only 100% sure experts solve it correct complete solutions each okk take 24hrs but solve all okkk must accurate students own words okk don't use Ai okk.
arrow_forward
12-15 please
arrow_forward
View
History
Bookmarks
People
Tab
Window
Help
S, Amaya K - Outlo x
B Chapter 5- CHEM-1110-941- x
Question 20 - Chapter 5- Con x
education.com/ext/map/index.html?_con%3con&external_browser%3D0&launchUrl=https%253A%252F%252Flms
Saved
3 attempts left
Check my work
Enter your answer in the provided box.
It takes 155 s for an unknown gas to effuse through a porous wall and 97 s for the same volume of N2
gas to effuse at the same temperature and pressure. What is the molar mass of the unknown gas?
g/mol
...
115
MAR
1664
18
ottv A
arrow_forward
The above solution was wrong when entered into homework site
arrow_forward
Unit 3: Energy Changes & Rates of Reaction
Topic 1: "Nuclear reactors should be used instead of burning fossil fuels to supply electrical
energy". Do you agree or disagree? Justify your answer from economic, environmental, and scientific
perspectives. Be sure to include a description of how nuclear reactors work.
arrow_forward
In 2021, Beta Corporation earned gross profits of $790,000.
a. Suppose that Beta was financed by a combination of common stock and $1.03 million of debt. The interest rate on the debt was
9%, and the corporate tax rate in 2021 was 21%. How much profit was available for common stockholders after payment of
interest and corporate taxes?
b. Now suppose that instead of issuing debt, Beta was financed by a combination of common stock and $1.03 million of preferred
stock. The dividend yield on the preferred was 7%, and the corporate tax rate was still 21%. Recalculate the profit available for
common stockholders after payment of preferred dividends and corporate taxes.
Note: Do not round intermediate calculations. Enter your answers in dollars not millions and round your answers to the
nearest whole dollar amount.
arrow_forward
I Write a balanced equation for *
106 pd(a,p)
109
46
47
arrow_forward
A population numbers 16,000 organisms initially and decreases by 8.9% each year.please type answer in words don't image upload thank you.
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
Show complete solution.
arrow_forward
Please do question 5 for me and please don’t return in it just write one sentence for each box
arrow_forward
Activity 3
Evidences of Chemical Change
Objective: Identify signs that chemical changes are taking place.
Write down the evidences which prove that the chemical change occurs in each
process. You can use Google or YouTube to search for the possible results of the given
chemical system.
Chemical System
1. Decaying of food.
Evidence of Chemical Change
2. A silver spoon tarnishes.
3. An iron nail rusts.
4. Cooking of adobo.
5. Lithium in cell phone battery
6. Coconut water turning sour.
7. Pineapple juice ferments.
8. Ripening of green mango.
9. Liquid milk is added to vinegar in
a glass.
10.A firecracker explodes.
7
arrow_forward
Dear tutor please reword whats writeen and add more details to the explanation
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Chemistry for Engineering Students
Chemistry
ISBN:9781285199023
Author:Lawrence S. Brown, Tom Holme
Publisher:Cengage Learning
Related Questions
- 3) Carbon-14 is constantly being produced in the upper atmosphere, and the amount is in equilibrium. As long as an organism is alive, it keeps its carbon isotopes in balance with the atmosphere, but at soon as it dies, it stops taking up new 14C, and so the geologic clock starts. You found a shell buried in sedimentary layers, which has 6% of its original 14C left. Determine the age of the shell. Show your work.arrow_forwardSS C cm 1 GtG tC FCX in SH U njmpLGQQmzAe4FI77iAeY/edit#slide%-id.g112e600b836_0_44 个 Help Accessibility Last edit was 2 hours ago Arial 21 BIUA work Day 1- 18 What were some potential human errors that could have occurred when calculating the mass before and after the reaction? Add these to your drawing on page 60.arrow_forwardHydrochloric acid can be prepared by the following reaction: 2NACI(s) + H2SO4(aq)2HCI(g) + Na2SO4(s) What mass of HCI can be prepared from 2.00 mol H SO4 and 150. g NaCl? Multiple Choice 2.57 g 167 g 93.6 g 11 asus COLLECTION prt sc delete 112/A insert f7 f8 f11arrow_forward
- Question : Some deposits were observed in water preserved in aluminum containers after two to three days. What could the deposit be ? What is the reason for the formation of these deposits ? Kindly Do not Spam or Copy from Other Websites Give Proper Answer with Correct Explanation Asking this Question with a hope to get correct answer Bored of Seeing Internet Answers All the Best for Solving this Questionarrow_forwardWhich one is it?arrow_forwardA Water Quality Standard will be developed for radioactive isotope “Iron-55” which has physical (radioactive) and biological half-lives of 2.7 and 1.6 years, respectively. Through toxicological studies scientists decided “spleen” as the critical organ and the critical accumulation of Iron-55 in spleen has been determined to be 0.5 gram. Assuming radioactive exposure is only due to drinking water consumption and average life expectancy is 75 years. a) What should be the Maximum Concentration Level (MCL) as mg/L for Iron-55 in drinking water. b) How long does it take to eliminate 95% of this radioactive isotope from human spleen after the person gives up on drinking water contaminated with Iron-55?arrow_forward
- Part A Which route would be better: one that produces a small amount of hazardous waste or one that produces a large amount of nonhazardous waste? Which green chemistry metric accounts for this dilemma? Match the items in the left column to the appropriate blanks in the sentences on the right. Reset Help minimize The best route is because it should the E-factor and maximize the effective mass yield. the one that produces a small The accounts for this dilemma as it looks at the amount of relative to amount of hazardous waste the amount of E-factor product made the one that produces a large amount nonhazardous waste materials used difficult to choose hazardous reagents used waste produced Submit Previous Answers Request Answerarrow_forwardCreate a model that explains a nuclear reaction within the context of its application : Nuclear fission reactors An equation for the nuclear reaction in your model A visual representation of the nuclear reaction occurring A written explanation of the reaction and how energy and matter are transformed and conserved throughout the reaction The context and/or application of the nuclear reaction Where does the reaction occur? What impact or relevance does this reaction have to society?arrow_forwardYou will research how the energy is extracted or produced and try to be very detailed about the process and the chemistry involved (stating equations and reactions). You will also research the impact on the environment when using or producing fuels. Investigating fossil fuel: How is it produced? What is the chemistry involved (stating equations and reactions)? What is the impact on the environment? 300-400 words Investigating nuclear energy: How is it produced? What is the chemistry involved (stating equations and reactions)? What is the impact on the environment? 300-400 words Investigating biofuel: How is it produced? What is the chemistry involved (stating equations and reactions)? What is the impact on the environment? 300-400 wordsarrow_forward
- Answer question 1 pleasearrow_forward+ terface/acellus_engine.htm?ClassID=1467683063 Use the data below to determine the mass ratio of iron to oxygen for compound 2. Compound 1 2 Et onal Academy of Science. All Rights Reserved. Mass Fe (grams) 15.55 20.98 [20:1 Enter the answer that belongs in the green box. Iron Ratio Cmpd 2 Mass O (grams) 4.45 9.02 Sh Enterarrow_forwardDr. X claims that she has found a new remedy (carrot extract) to cure acne. She scores an interview with the science writer for a local newspaper, and gets a brief article written about her and her claims in that newspaper. The article does not contain any experimental evidence, but mentions that Dr. X accidentally splashed some carrot extract on her face and found that the acne was reduced a few days later. Student Y finds the article and cites it as a source for a paper he is writing for class, as evidence that acne has been cured. (a) Is this finding a fact, a theory, a hypothesis, or an observation? Explain why you think so. (b) Was it OK for Student Y to use the newspaper article as evidence for his paper? Explain why or why not.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Chemistry for Engineering StudentsChemistryISBN:9781285199023Author:Lawrence S. Brown, Tom HolmePublisher:Cengage Learning
Chemistry for Engineering Students
Chemistry
ISBN:9781285199023
Author:Lawrence S. Brown, Tom Holme
Publisher:Cengage Learning