DAD 220 Module One Lab Template
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
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
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
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
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 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
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 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
1) A low-friction cart is placed between two identical springs attached to rigid walls.
If you push the cart against one of the springs and release it, it will continue to
move back and forth between the springs.
www
Draw a force-time graph showing the sum of the horizontal forces exerted on the
cart as it moves back and force between the springs.
Scientific Abilities
Is able to construct a
force diagram
Missing
No representation is
constructed.
Inadequate
FD is constructed but
contains major errors such
as incorrect mislabeled or
not labeled force vectors,
length of vectors, wrong
direction, extra incorrect
vectors are added, or
vectors are missing.
Needs Improvement
FD contains no errors in
vectors but lacks a key
feature such as labels of
forces with two subscripts or
vectors are not drawn from
single point, or axes are
missing.
Adequate
The diagram contains no
errors and each force is
labeled so that it is clearly
understood what each force
represents.
Explain whether or not this…
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
Solve correctly
arrow_forward
I need help solving this problem.
arrow_forward
Hello tutors, help me. Just answer "Let Us Try"
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
Please make the exact graph that you see in the picture, along with the graph are numbers that are data. Please make the exact graph do not make anything thing different, the blue and orange circles should be there and the lines should be the same including the titles. Please make sure everything is exactly the same. Use MATLAB, and send the code and please make sure no error signs comes up. Take your time please I need help.
arrow_forward
I thought the letters represented the connection between the forces and magnitude. Can you help me truly understand how to evaluate this correctly? Thanks
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
Please type out and or diagram Your solution in a way that is easy to read I have bad eyesight
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
solve this please on ANSYS and give me screenshots how you did it, please
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
- 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_forwardThe 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_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_forwardPlease show work in a handwritten format. Don't use chatgpt. Mechanics of materials/design.arrow_forwardI 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
- 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_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_forward1) A low-friction cart is placed between two identical springs attached to rigid walls. If you push the cart against one of the springs and release it, it will continue to move back and forth between the springs. www Draw a force-time graph showing the sum of the horizontal forces exerted on the cart as it moves back and force between the springs. Scientific Abilities Is able to construct a force diagram Missing No representation is constructed. Inadequate FD is constructed but contains major errors such as incorrect mislabeled or not labeled force vectors, length of vectors, wrong direction, extra incorrect vectors are added, or vectors are missing. Needs Improvement FD contains no errors in vectors but lacks a key feature such as labels of forces with two subscripts or vectors are not drawn from single point, or axes are missing. Adequate The diagram contains no errors and each force is labeled so that it is clearly understood what each force represents. Explain whether or not this…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_forwardHelp me solve this ENGINEERING GRAPHICS question Use 0.25 cartesian paper or 0.25 Isometric paper please.arrow_forwardSolve correctlyarrow_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