DAD 220 Module One Lab Template
docx
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
200
Subject
Mechanical Engineering
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by ConstableSalamander3199
DAD 220 Module One Lab Template
Overview
To complete this lab, go to your Codio virtual lab environment and start a new terminal session. Once there, perform the steps below to complete this activity. Manually enter any commands you are asked to write.
At the end of each step in the activity, replace the bracketed text with a screenshot, brief explanation, or
both, as indicated. Size each screenshot and its explanation to fit about one-quarter of the page with the
description written below the screenshot. Review the Template Screenshot Example linked in the guidelines and rubric for this assignment to see an example of how screenshots for your assignment should look. Create a Database
1.
Create a new database
and update the name to your last name; then connect to it. Type the following commands after the prompt mysql>:
A.
CREATE DATABASE last_name_here;
i.
For example, if your database is going to be named Jetson, then substitute "Jetson" for "last_name_here".
ii.
Press Enter
.
B.
SHOW DATABASES;
i.
Press Enter
.
ii.
You should see a listing of all of the databases (or schemas) in MySQL, including the one you just created.
C.
USE last_name_here;
i.
Press Enter
.
ii.
Substitute the name of your database (for example, "Jetson") for "last_name_here". This SQL statement connects your MySQL session to the database you just created.
D.
Capture a screenshot of the results of this action.
[Insert screenshot here.]
2.
Create a table
called tb2
and list out the tables in your database with one field by typing the following commands after the prompt mysql>:
A.
CREATE TABLE tb2 (user_id VARCHAR( 50 ));
i.
Press Enter
.
B.
SHOW TABLES; i.
Press Enter
.
C.
DESCRIBE tb2; i.
Press Enter
.
D.
Capture a screenshot of the results of this action.
[Insert screenshot here.]
3.
Add a second field into the table and describe it
. Do this by entering the following commands after mysql>: A.
ALTER TABLE tb2 ADD newfield VARCHAR(25);
i.
Press Enter
.
B.
DESCRIBE tb2;
i.
Press Enter
.
C.
Capture a screenshot of the results of this action.
[Insert screenshot here.]
4.
Organize your work
to match the screenshot example and guidelines in the example document linked in the Supporting Materials section of the guidelines and rubric. Your submission should show that your work is original and the commands you have written for this lab worked correctly.
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
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
The first photo is the question, where the 2nd shows some problem solving strategies
arrow_forward
Draw it on the graph provided please!
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
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
Please show work in a handwritten format.
Don't use chatgpt.
Mechanics of materials/design.
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
Using a AutoCAD drawing the section view for the following multiview drawing
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
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
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
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
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
arrow_forward
I need problems 6 and 7 solved.
I got it solved on 2 different occasions and it is not worded correctly.
NOTE: Problem 1 is an example of how it should be answered. Below are 2 seperate links to same question asked and once again it was not answered correctly. 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
2. 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/bd5390f0-3eb6-41ff-81e2-8675809dfab1
arrow_forward
I think I drew it wrong but can it please be drawn on the isometric paper on my image!
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
Hi, I need help with the first part of the problem below because I'm very confused about how P1 and P2 should be calculated. If you look at my notes to solve the problem there is already a formula in place as I always thought the Patm should also be multiplied by the Area in the numerator, but it's not if I look at this specific tutorial solution given by my course but it's not explained why. I have done a while ago a very similar problem with using that formula in my notes and it gave me the right results, but it's not working for this one. Could you please help me understand why as I have a test coming soon?
Figure Q3 (see image attached) shows a cylinder and pistonenclosing air, the movement of the pistonbeing restrained by a compression spring ofstiffness 20 kN/m. The air is heated andexpands, the piston moving 0.3 m. Thefree length of the spring is 1.0 m.Calculate the work done by the air duringthe process.If the pressure , volume and internal energyof air are related by the…
arrow_forward
please help solve A-F. thank you
You are an engineer working on a project and your prototype has failed prematurely. You question whether or not a key component of the prototype was manufactured with the correct material. There are two way to check for the material properties. The first way is to have a material certification done to confirm the exact material composition. This will take some time. The second method to confirm the material properties is to make an ASTM test sample and test for the material properties. This tensile test was completed on a test sample with an initial diameter of .501” and an initial length of 2”. The Load-Deflection data for this tensile test is below. Use this data to answer the first set of questions on the Final Exam in eLearning. A. Determine the Ultimate Tensile Strength B. Determine the 0.2% Offset Yield Strength C. Determine the value of the Proportional Limit D. Determine the Modulus of Elasticity E. Determine the Strain at Yield F. Calculate %…
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
Keep the same colors the same graph, basically keep everything the same just make the line with a small curve just as shown on the picture
Keep everything the same just make the line less curvy please do not change the colors of the line and the circles do not change anything besides the curve of the line.
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 lines
fitDiesel = polyval(pDiesel, carPosition);…
arrow_forward
Please use the isometric graph paper in my picture to draw it to scale!
arrow_forward
question in the picture
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
Please make this on MATLAB, make the graph shown on the picture, copy the orange and blue circles and the line please make sure that they are on the exact same spots. Make the exact copy of the graph please. Nothing different, just make the same graph and put the orange and blue circles on the exact spots and make sure the lines are the same and make sure the title of the graph is their as well. They rest of the pictures that has numbers are the data that is believed to be the orange and blue dots . Take your time please. I need help with this.
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
- 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_forwardThe first photo is the question, where the 2nd shows some problem solving strategiesarrow_forwardDraw it on the graph provided please!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_forwardAstronomy 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_forwardPlease show work in a handwritten format. Don't use chatgpt. Mechanics of materials/design.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_forwardUsing a AutoCAD drawing the section view for the following multiview drawingarrow_forwardEvery 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
- 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_forwardI 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_forwardThere 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
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