Project 1
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Dec 6, 2023
Type
docx
Pages
7
Uploaded by PresidentMousePerson992
DAD 220 Database Documentation Template
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?
There are 505 customers in Framingham, Massachusetts.
●
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?
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
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
arrow_forward
Which of the follow statement(s) correctly completes the following sentence fragment?
The setup() function in an Arduino sketch ...
(There may be more than one correct answer)
a) is executed only once after a new sketch is uploaded to the Arduino board, or the Arduino
board is reset (user presses "reset" button).
b) can be replaced by a user-defined function like "my_setup()"
c) must always start by making a serial connection to the host computer with Serial.begin().
d) is executed only once when an Arduino board that has been disconnected from the USB
cable is reconnected to that cable. (Assume that the other end of the USB cable is connected
to a computer)
arrow_forward
The following tools / resources may be useful for you to complete the assignment:a. Chatgpt (You may use it to learn Matlab coding or any other computer language. An example is given here: https://shareg.pt/mXHGne9 ). Please take note that code generated by chatgpt can be directly copied and pasted.b. Matlabi) Useful cheat sheet (https://n.ethz.ch/~marcokre/download/ML-CheatSheet.pdf)ii) Getting started with Matlab (https://matlabacademy.mathworks.com/en/details/gettingstarted )iii) Getting 30-day Matlab trial license (https://www.mathworks.com/campaigns/products/trials.html ) iv) Polyfit (https://www.mathworks.com/help/matlab/ref/polyfit.html )v) Exponential Fit (https://www.mathworks.com/matlabcentral/answers/91159-how-do-i-fit-an-exponential-curve-to-my-data)c. PlotDigitizer (https://plotdigitizer.sourceforge.net/ ) or a free online app that does not requires installation (https://plotdigitizer.com/app )You may use your own engineering judgement to make any assumptions on any…
arrow_forward
Suppose your CFD code can handle nonelementary blocks. Combine as many blocks of Fig. as you can. The only restriction is that in any one block, the number of i-intervals and the number of j-intervals must be constants. Show that you can create a structured grid with only three nonelementary blocks. Renumber all the blocks and indicate how many i- and j-intervals are contained in each block. Add up all the cells and verify that the total number of cells does not change.
arrow_forward
Choose the correct answer, please, I need the solution as soon as possible
arrow_forward
Problem 3 (40 points) (CCOs 1 & 3)/MatlabGrader
On Canvas, you will find a Matlab function file process.p that takes as input the variable x and returns as output the result of
a complicated process g (x). Copy the file into your working directory and use it as any other Matlab .m file or build-in intrinsic
Matlab function (just call it using its name process). The only difference between a .p and a .m file is that the source code of the .p
file is not visible.
Find all roots of g(x) in the interval 0 ≤ x ≤ 10 to a tolerance in function of at least 10-10 using mySecant from problem 2.
Recall that any .m or .p function file can be passed as an argument into another function by prefacing the function name by a
@, e.g., @process can be passed as an argument into any Matlab function that uses a function as an input argument, for example
fplot(@process,...) for plotting a function.
Store all found unique roots in a column vector root, the corresponding tolerances in function in a column…
arrow_forward
HW_5_01P.pdf
PDF
File | C:/Users/Esther/Downloads/HW_5_01P.pdf
2 Would you like to set Microsoft Edge as your default browser?
Set as default
To be most productive with Microsoft Edge, finish setting up your
Complete setup
Maybe later
browser.
(D Page view A Read aloud V Draw
7 Highlight
2
of 3
Erase
5. Two cables are tied to the 2.0 kg ball shown below. The ball revolves in a horizontal
circle at constant speed. (Hint: You will need to use some geometry and properties of
triangles and their angles!)
60°
1.0 m
60°
© 2013 Pearson Education, Inc.
(a) For what speed is the tension the same in both cables?
(b) What is the tension?
2.
2:04 PM
O Type here to search
C A
2/9/2021
(8)
arrow_forward
Hartley Electronics, Inc., in Nashville, producesshort runs of custom airwave scanners for the defense industry.The owner, Janet Hartley, has asked you to reduce inventory byintroducing a kanban system. After several hours of analysis, youdevelop the following data for scanner connectors used in onework cell. How many kanbans do you need for this connector?Daily demand 1,000 connectorsLead time 2 daysSafety stock 12 dayKanban size 500 connectors
arrow_forward
In the automotive industry, supercars are highly accredited with how they are manufacture; from the
type of car chassis used to the type of materials employed. Often enough, companies like BMW,
Mercedes & Audi produces supercars that exemplifies a better reliability compared to other automotive
manufacturing companies. This is because they pay close attention to the details on how the car is
manufactured; right from raw materials to a finished supercar. The task given to you is to watch the
video link provided below & explain the electrostatic process acquired for the two different models of
BMW vehicles.
https://www.youtube.com/watch?v=sUqKUbmdOr0
Pls watch the video before answering
arrow_forward
I need help solving this problem.
arrow_forward
my matrix number is 8 , so choose EVEN matrix numbers side
arrow_forward
I want the answer of part c
arrow_forward
This code keeps on generating graphs with different curves. The picture that you see two different graphs comes from the same code but both of them have different curves. I need the curve to look like the picture that only has one graph. I basically need the line to have a slight curve and every time I run the code it will come up as the same graph every time. Use this code on MATLAB and fix it
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Use the 'seed' function instead of 'rng'
seed = 50; % Define your seed here
rand('seed',seed);
% 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 with a reduced degree of 2
pDiesel = polyfit(carPosition, CO2Diesel, 2);
pPetrol = polyfit(carPosition, CO2Petrol, 2);
% Generate points for best fit…
arrow_forward
how do I dimension the object shown below
assume grid spacing is 0.2
arrow_forward
What are the answers in given problem
arrow_forward
I want you to draw HGL& EGL
For the first picture using the same method on the second picture
arrow_forward
Matlab code:
Read images from a folder with the
directory using the MATLAB code.
Be specific and don't write general
answer.
arrow_forward
Make a simulink program turning on the LED on the board for 10sec. Can you write down the steps to create the simulink program because it is my first time using it.
arrow_forward
Q4: Create a Visual Basic Project to find the value of the following series:
h? h4 h3
cos(h) = h –
2!
3!
4!
Write the code program so that the value of angle (h) is entered into inputbox.
Estimate the value of series (cos(h)) so that the absolute value of any term is
greater or equal to 10-6. Display the required number of terms (N) which it used in
this series in a text box and display the result of series (cos(h)) in another separate
text box.
arrow_forward
Draw it on the graph provided please!
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
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
Use MATLAB please make code for this.
arrow_forward
solve this please on ANSYS and give me screenshots how you did it, please
arrow_forward
The picture that has two graphs are generated by this code. Every time I run it on MATLAB it keeps generating graphs with different curves. The picture that shows one graph is the curve that I want to keep. Please keep the color of the lines and the circles and keep the title of the graph the same. I want everything to be the same except I want the line to look exactly like the picture with one graph on it.
Use this code on MATLAB and fix it and then send the correct code back please.
% Sample data for Diesel and Petrol cars
carPosition = linspace(1, 60, 50); % Assumed positions of cars
% Use the 'seed' function instead of 'rng'
seed = 50; % Define your seed here
rand('seed',seed);
% 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 with a reduced degree of 2
pDiesel = polyfit(carPosition,…
arrow_forward
I need help with simulink. It is my first time using simulink. I am trying to make a simulink program turning on the LED on the board for 10sec for an Arduino Mega 2560. I have attached an image of what I tried to do. After I run, it just says no diagnostic. How do I know if I did this correctly or not?
arrow_forward
I need help with the first part and Matlab for this problem
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
- 4. Documents business requirements use-case narratives.for only one process note: please i want Documents like this in picarrow_forwardWhich of the follow statement(s) correctly completes the following sentence fragment? The setup() function in an Arduino sketch ... (There may be more than one correct answer) a) is executed only once after a new sketch is uploaded to the Arduino board, or the Arduino board is reset (user presses "reset" button). b) can be replaced by a user-defined function like "my_setup()" c) must always start by making a serial connection to the host computer with Serial.begin(). d) is executed only once when an Arduino board that has been disconnected from the USB cable is reconnected to that cable. (Assume that the other end of the USB cable is connected to a computer)arrow_forwardThe following tools / resources may be useful for you to complete the assignment:a. Chatgpt (You may use it to learn Matlab coding or any other computer language. An example is given here: https://shareg.pt/mXHGne9 ). Please take note that code generated by chatgpt can be directly copied and pasted.b. Matlabi) Useful cheat sheet (https://n.ethz.ch/~marcokre/download/ML-CheatSheet.pdf)ii) Getting started with Matlab (https://matlabacademy.mathworks.com/en/details/gettingstarted )iii) Getting 30-day Matlab trial license (https://www.mathworks.com/campaigns/products/trials.html ) iv) Polyfit (https://www.mathworks.com/help/matlab/ref/polyfit.html )v) Exponential Fit (https://www.mathworks.com/matlabcentral/answers/91159-how-do-i-fit-an-exponential-curve-to-my-data)c. PlotDigitizer (https://plotdigitizer.sourceforge.net/ ) or a free online app that does not requires installation (https://plotdigitizer.com/app )You may use your own engineering judgement to make any assumptions on any…arrow_forward
- Suppose your CFD code can handle nonelementary blocks. Combine as many blocks of Fig. as you can. The only restriction is that in any one block, the number of i-intervals and the number of j-intervals must be constants. Show that you can create a structured grid with only three nonelementary blocks. Renumber all the blocks and indicate how many i- and j-intervals are contained in each block. Add up all the cells and verify that the total number of cells does not change.arrow_forwardChoose the correct answer, please, I need the solution as soon as possiblearrow_forwardProblem 3 (40 points) (CCOs 1 & 3)/MatlabGrader On Canvas, you will find a Matlab function file process.p that takes as input the variable x and returns as output the result of a complicated process g (x). Copy the file into your working directory and use it as any other Matlab .m file or build-in intrinsic Matlab function (just call it using its name process). The only difference between a .p and a .m file is that the source code of the .p file is not visible. Find all roots of g(x) in the interval 0 ≤ x ≤ 10 to a tolerance in function of at least 10-10 using mySecant from problem 2. Recall that any .m or .p function file can be passed as an argument into another function by prefacing the function name by a @, e.g., @process can be passed as an argument into any Matlab function that uses a function as an input argument, for example fplot(@process,...) for plotting a function. Store all found unique roots in a column vector root, the corresponding tolerances in function in a column…arrow_forward
- HW_5_01P.pdf PDF File | C:/Users/Esther/Downloads/HW_5_01P.pdf 2 Would you like to set Microsoft Edge as your default browser? Set as default To be most productive with Microsoft Edge, finish setting up your Complete setup Maybe later browser. (D Page view A Read aloud V Draw 7 Highlight 2 of 3 Erase 5. Two cables are tied to the 2.0 kg ball shown below. The ball revolves in a horizontal circle at constant speed. (Hint: You will need to use some geometry and properties of triangles and their angles!) 60° 1.0 m 60° © 2013 Pearson Education, Inc. (a) For what speed is the tension the same in both cables? (b) What is the tension? 2. 2:04 PM O Type here to search C A 2/9/2021 (8)arrow_forwardHartley Electronics, Inc., in Nashville, producesshort runs of custom airwave scanners for the defense industry.The owner, Janet Hartley, has asked you to reduce inventory byintroducing a kanban system. After several hours of analysis, youdevelop the following data for scanner connectors used in onework cell. How many kanbans do you need for this connector?Daily demand 1,000 connectorsLead time 2 daysSafety stock 12 dayKanban size 500 connectorsarrow_forwardIn the automotive industry, supercars are highly accredited with how they are manufacture; from the type of car chassis used to the type of materials employed. Often enough, companies like BMW, Mercedes & Audi produces supercars that exemplifies a better reliability compared to other automotive manufacturing companies. This is because they pay close attention to the details on how the car is manufactured; right from raw materials to a finished supercar. The task given to you is to watch the video link provided below & explain the electrostatic process acquired for the two different models of BMW vehicles. https://www.youtube.com/watch?v=sUqKUbmdOr0 Pls watch the video before answeringarrow_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