6-1 Project One Creating a Database and Querying Data
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
200
Subject
Mechanical Engineering
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by BarristerAardvarkPerson1031
Laticia Edwards
DAD 220 Database Documentation Template
Complete these steps as you work through the directions for Project One. 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 located in the Project One Supporting Materials for assistance.
Step One: Create a Database
1.
Navigate to your online integrated development environment (IDE). List and record the SQL commands that you used to complete this step here: 2.
Create a database schema called QuantigrationUpdates. List out the database name. Provide the
SQL commands you ran against MySQL to successfully complete this in your answer:
3.
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 QuantigrationUpdates database, as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
b.
A table named Orders in the QuantigrationUpdates database, as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
c.
A table named RMA
in the QuantigrationUpdates database, as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
Step Two: Load and Query the Data
1.
Import the data from each file into tables.
Use the QuantigrationUpdates database, the three tables you created, and the three CSV files preloaded into Codio.
Use the import utility of your database program to load the data from each file into the table of the same name. You will perform this step three times, once for each table.
2.
Write basic queries against imported tables to organize and analyze targeted data. For each query, replace the bracketed text with a screenshot of the query and its output. You should also include a 1- to 3-sentence description of the output.
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
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 who are located in Massachusetts.
ii.
Record an answer to the following question: How many records were returned? There were 982 records returned.
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
I need help solving these 3 simple parts, if you can not answer all 3 parts then please leave it for another tutor, thank you.
arrow_forward
Draw it on the graph provided please!
arrow_forward
Choose the correct answer, please, I need the solution as soon as possible
arrow_forward
Astronomy Question:
Read the questions slowly and answer with precise and long details about each of the questions. Answer correctly and follow my guidelines for a long and wonderful review after results. Your target/main observable galaxy is the whirlpool galaxy. Target: Whirlpool Galaxy Object Type: Galaxy Distance: 37 million light-years Constellation: Canes Venatici. DO NOT COPY AND PASTE OTHER WORK OR THINGS FROM THE INTERNET, use your own words.Provide refernces if used
In 500 words, please explain the relevance of this object to the physics course material in university andits importance to astronomy. (Some question you may seek to answer are: What beyond the objectitself is learned by studying this class of objects? What sorts of telescopes and observations would beneeded for more detailed, broader reaching studies of this source and objects of its nature?)
arrow_forward
You are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:
arrow_forward
I drew it but I don't know where I have to connect it. Where do I put dashed lines (if needed) where are the solid lines? Did I do it right?
arrow_forward
Please draw the right side view.
Don't copy from anywhere else. Please write the dimensions as well.
arrow_forward
Please do only C part with breif explanation. I want typed solution. Not hand written
arrow_forward
I need parts 3 and 4 answered pertaining to the print provided.
I asked this question previously on here and I received the wrong answers to the 2 parts Im asking about, so I am reposting the question again to have another tutor answer it.
Part 3: I need to tell what was ommited.
Part 4: I need to tell what the triangle equals? Lower right or J1 zone has the answer.
arrow_forward
You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture
fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates
implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial
weight bearing activities.
Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to
verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into
solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending
test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the
yield stress for the Ti-6Al-4V…
arrow_forward
Don't use chatgpt will upvote
arrow_forward
Please solve the question on the sheet and get a clear picture and submit the picture.
thankyou
arrow_forward
Don't copy paste someone else answer if I get to know I'll report and downvote too do on your own and only handwritten with proper steps not that handwritten only
arrow_forward
need some help on this please
arrow_forward
arrow_forward
Oh no! Our expert couldn't answer your question.
Don't worry! We won't leave you hanging. Plus, we're giving you back one question for the inconvenience.
Here's what the expert had to say:
Hi and thanks for your question! Unfortunately we cannot answer this particular question due to its complexity. We've credited a question back to your account. Apologies for the inconvenience.
Ask Your Question Again
5 of 10 questions left
until 8/10/20
Question
Asked Jul 13, 2020
1 views
An air conditioning unit uses Freon (R-22) to adapt an office room at temperature 25 oC in the summer, if the temperature of the evaporator is 16 oC and of the condenser is 48 oC. The reciprocating compressor is single acting, number of cylinders are 2, the volumetric efficiency is 0.9, number of revolutions are 900 r.p.m. and L\D= 1.25. If the compressor consumes a power of 3 kW and its mechanical efficiency is 0.9. Find the following:
(A) Flow rate of the refrigerant per…
arrow_forward
Every time I use this code the two lies come up but they keep on showing up separately. I need one line on top of the other or make it look like one line just like it’s shown on the picture I need the two line together and make it one line. If you can please make the lines less curved make it look line the line on the picture.
With what I’m asking from you please fix it using this code using MATLAB and send back the code.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Fix the random seed for reproducibility
rng(45);
% Assumed positions of cars
CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel
CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol
% Fit polynomial curves
pDiesel = polyfit(carPosition, CO2Diesel, 3);
pPetrol = polyfit(carPosition, CO2Petrol, 3);
% Generate points for best fit lines
fitDiesel = polyval(pDiesel, carPosition);
fitPetrol =…
arrow_forward
What are the answers in given problem
arrow_forward
Q \Fill in the blank the correct word or phrase which is showing reason or result.
1) Large numbers of people from all over the world visit Petra, in Jordan,
its
beauty.
A).so
B).because of
C).as a result
D).because
2) One of the greatest achievements of Emperor Qin Shi Huang was the building of the first
Great Wall of China to protect China from its enemies. Not all of his achievements were military,
however, as he . introduced a common form of writing throughout the country.
a.)in addition
b.)plus
c.)add
d.)also
3) In ancient China, more than 700,000 workers and craftsmen took 38 years to complete the
huge imperial palace, offices, and halls, all surrounded by a wall.
Qin Shi Huang ordered an army to be built so that his palace would be protected.
Emperor
a.)add
b.)also
c.)plus
d.)in addition
4 ) Historians are often required to learn languages such as latin
read ancient
manuscripts and inscriptions.
a.)thus
b.)as a result
c.)in order to
d.)therefore
5) In 79 CE Pompeii was covered…
arrow_forward
I need the answers to this part, I have submitted this question three times on this site and all three times received way different answers...as I am unsure which tutor to listen to, I am uploading this question for the third time and I am asking a very highly knowledgable tutor to help me solve this. If you are uncertain, please leave it for another tutor.
arrow_forward
Please type out and or diagram Your solution in a way that is easy to read I have bad eyesight
arrow_forward
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
arrow_forward
There is a small space between the orange and purple line could you please connect the two lines together also can you please make the purple line shorter and then connect the purple line to the orange line, please take out the box that says “Diesel, petrol, Diesel best fit, petrol best fit”. Also when ever I run this code the graph shows up but there are still errors that comes up could you please fix them when you are running this on MATLAB.
Please use this code on MATLAB and fix it.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Fix the random seed for reproducibility
rng(50);
% Assumed CO2 emissions for Diesel and Petrol
CO2Diesel = 25 + 5*cos(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Diesel
CO2Petrol = 20 + 5*sin(carPosition/60*2*pi) + randn(1, 50)*5; % Random data for Petrol
% Fit polynomial curves
pDiesel = polyfit(carPosition, CO2Diesel, 3);
pPetrol = polyfit(carPosition, CO2Petrol, 3);
% Generate…
arrow_forward
I need the answer as soon as possible
arrow_forward
I need the answers to this part, I have submitted this question twice on this site and both times received way different answers...as I am unsure which tutor to listen to, I am uploading this question for the third time and I am asking a very highly knowledgable tutor to help me solve this. If you are uncertain, please leave it for another tutor.
arrow_forward
I am attaching both questions for 4 and 5 with the question in the image. thank you.
NOTE : So the last person answered this question WITHOUT refencing the answer for whether question 4 or 5 answeres were given, so i am asking for question 5(or the answer for the question that was NOT solved because it was not referenced.) These were the following answers given to me from the last person on bartleby who answered my question without referencing whether it was the answer for question 4 or 5.
1 pass
2 fail
3 fail
4 pass
arrow_forward
The class I'm taking is physics for scientists and engineers!
**** I need help with part D only*****
Can you please write out the solution and not type out the solution? I had to reask this question because the last tutor typed out the solution and it was very hard for me to follow . Please and thank you for the special request.
I have attached the problem. Please view attachment before answering. Thank you!
arrow_forward
AutoCAD is one of the ready-made
programs that help workers in the field
of design and engineering drawing
because
OThe possibilities it provides to facilitate the
design process.
OThe non-possibilities it provides to facilitate the
design process.
OThe possibilities it non-provides to facilitate the
design process.
arrow_forward
Document1 - Word
File
Home
Insert
Design
Layout
References
Mailings
Review
View
O Tell me what you want to do...
Sign in 2 Share
X Cut
Calibri (Body)
- A A
今し
P Find -
11
Aa -
AaBbCcDc AaBbCcDc AaBbC AABBCCC AaB AaBbCcC AaBbCcD AaBbCcD AaBbCcD AaBbCcDc AaBbCcD AaBbCcD AABBCCD AABBCCDI AaBbCcD
Ee Copy
ab. Replace
Paste
B I U - abe x,
A - aly - A -
1 Normal 1 No Spac. Heading 1
Heading 2
Title
Subtitle
Subtle Em. Emphasis
Intense E.
Strong
Quote
Intense Q. Subtle Ref.. Intense Re. Book Title
x'
Format Painter
A Select -
Clipboard
Font
Paragraph
Styles
Editing
At a hydraulic plant the propeller type turbine are rated at 48,000 HP at 82 rpm under a 14 meters head, the
diameter is 7 meters, for a geometrical similar turbine to develop 36,000 HP under a 11 meters head.
After resolving the percentage change in probable flow, determine the following:
What diameter, in meter, of the impeller to be used?
O 70.00
O 22.86
O 40.00
O 7.25
O 13.06
What is the speed, in RPM, should be used?
O 40.00
O…
arrow_forward
I asked for problems 6 and 7 to be answered, but I did not get a properly structured answered as the example shows on problem number 1. Here is the link to the questions I already had answered, could you please rewrite the answer so its properly answered as the example shows (Problem 1)?
https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857
arrow_forward
INSTRUCTIONS:
Please write clearly and understandable way.
Write all the corresponding GIVEN with their corresponding symbols and units.
List all the MISSING/REQUIRED, and list all the FORMULA that will be used.
• DRAW/ILLUSTRATE THE DIAGRAM/CIRCUIT OR DRAWINGS that is related to the
problem, IF POSSIBLE, which is HIGHLY REQUIRED.
The CONVERSION calculations with their corresponding symbols and units is
required.
The problem's SOLUTION must be solved in a step-by-step, no shortcut, again, with
their corresponding symbols and units.
• BOXED the Final Answer.
PROBLEM:
The compressor of a large gas turbine power plant receives 12kg/s of surrounding air at
95kPa and 20°C. At the compressor outlet, air exits at 1.52MPa, 430°C, Determine the
flow energy requirements in MW.
a) 1.412
b) 2.42
c) 1.01
d) 1.614
arrow_forward
A Team of Engineers asked for an internal combustion engine to use it in a designed car. Your role is to describe the operation sequence of different types of available engines, explain their mechanical efficiency, and deliver a detailed technical report to show your approach in solving and discussing the following tasks and issues.
You must follow the following steps to help the team:
STEP 1
Describe the operational sequence of four-stroke spark ignition and four-stroke compression ignition engines with the aid of sketches by constructing simple sketch representing the operation and plotting the P-V diagrams for each process during the cycle to show the following:
The input and output heat and net output work
The expansion and compression strokes
The air-fuel mixture intake and exhaust gasses
The spark plug when it is in the active mode
The complete cycle of ideal Otto and Diesel cycles that shows the input and output heat and net output work.
STEP 2
Explain the mechanical…
arrow_forward
Your choices from the drop down menu are "1, 2.5, and 3.5" Please see both images for reference. Thanks!
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Related Questions
- Astronomy Question: Read the questions slowly and answer with precise and long details about each of the questions. Answer correctly and follow my guidelines for a long and wonderful review after results. Your target/main observable galaxy is the whirlpool galaxy. Target: Whirlpool Galaxy Object Type: Galaxy Distance: 37 million light-years Constellation: Canes Venatici. DO NOT COPY AND PASTE OTHER WORK OR THINGS FROM THE INTERNET, use your own words.Provide refernces if used In 500 words, please explain the relevance of this object to the physics course material in university andits importance to astronomy. (Some question you may seek to answer are: What beyond the objectitself is learned by studying this class of objects? What sorts of telescopes and observations would beneeded for more detailed, broader reaching studies of this source and objects of its nature?)arrow_forwardYou are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:arrow_forwardI drew it but I don't know where I have to connect it. Where do I put dashed lines (if needed) where are the solid lines? Did I do it right?arrow_forward
- Please draw the right side view. Don't copy from anywhere else. Please write the dimensions as well.arrow_forwardPlease do only C part with breif explanation. I want typed solution. Not hand writtenarrow_forwardI need parts 3 and 4 answered pertaining to the print provided. I asked this question previously on here and I received the wrong answers to the 2 parts Im asking about, so I am reposting the question again to have another tutor answer it. Part 3: I need to tell what was ommited. Part 4: I need to tell what the triangle equals? Lower right or J1 zone has the answer.arrow_forward
- You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial weight bearing activities. Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the yield stress for the Ti-6Al-4V…arrow_forwardDon't use chatgpt will upvotearrow_forwardPlease solve the question on the sheet and get a clear picture and submit the picture. thankyouarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY