DAD 220 Module Four Major Activity Database Documentation Dylan Roscioli (REVISED)
.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 MagistrateExplorationStarling39
DAD 220 Module Four Major Activity Database Documentation Template
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 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 for assistance.
Follow Steps 1 through 4 from the Module Three Major Activity
only
to generate tables for this
assignment.
1.
Import
the
data
from each file
into tables.
A.
Use the import utility of your database program to load the data from each file into the
table of the same name. You’ll perform this step three times, once for each table.
B.
Provide the SQL commands you ran against MySQL to complete this successfully in your
answer.
Above are the commands used to enter the .csv files into the already established tables I
had. The FIELDS TERMINATED and LINES TERMINATED BY statements both give the tool
the guidelines for how it input the data, making sure two values or more don’t end up in
one column.
Above I used the SELECT COUNT() statement with each tables primary key in order to
pull the total amount of records in each table without having duplicates because of using
the primary key.
2.
Write basic queries
against imported tables to organize and analyze targeted data
.
3.
For each query, include a screenshot of the query and its output. You should also include a 1- to
3-sentence description of the output.
A.
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?
I got 505 records using the SELECT COUNT clause I was able to just be returned a
total number rather than all 505 rows of data. From there I just put the WHERE
clause to narrow my results to the city and state that I wanted results for.
B.
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
Record an answer to the following question: How many records were returned?
I got 982 records here using the same clause from before, but instead of specifying the
city I only did the state to get me everyone in that state.
C.
Write an SQL query to insert four new records into the Orders and Customers tables
using the following data:
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
Please draw the right side view.
Don't copy from anywhere else. Please write the dimensions as well.
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
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
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
arrow_forward
Below is problem MV1 from the course pack. In an earlier assignment, you created a
multiview drawing of this part.
Model this part with SolidWorks, with each grid spacing equal to one inch. Create a
SolidWorks drawing of this part, with Front, Top, and Right Views. Import dimensions
from the SolidWorks part file, and place them on the drawing so that they can be
easily read. Add a note that all dimensions are inches. Add your personalized title
block that you created in Chapter 2 to this drawing.
*Important: Save the drawing first as SolidWorks Drawing (filetype *.slddrw) and
then as an eDrawing (filetype *.edrw)! You will upload the eDrawing in Blackboard, not
the SolidWorks Drawing - the SolidWorks drawing is associated with the part file, I
cannot open the sw drawing unless you also send the part file; however, l can open the
eDrawing without the part file.
arrow_forward
Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example
Thank you.
arrow_forward
I need answers for problems 13, 14, and 15 pertaining to the print provided.
NOTE: If you refuse to answers all 3 parts and insist on wasting my question by breaking down 1 simple question into 3 parts, then just leave it for someone else to answer. Thank you.
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
Q1: write a program to enter any text and compute its length.
Q2: Design a form with a text box. Use select statement so
that when user enters g, b, r and y then form colored to
green, blue, red, and yellow respectively.
Q3: Write a program to print multipliers of 5 (from 5 to 50)
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
Note: Round your final answer to 2 decimal places if it is not a whole number.
Note:-
Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
Answer completely.
You will get up vote for sure.
arrow_forward
I need answers to questions 1, 2, and 3 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
arrow_forward
Please solve the following parts a) b) c) and show the detail work for each part.
arrow_forward
Hand written plz asap... I'll give you multiple upvote if hand written
arrow_forward
Engineering Management :
Please Read your Reference: www.bigrentz.com for your own. Topic is " Top 10 Construction
Industry Trends To Watch For In 2022" Answer The following this.
Make a reaction paper of the statement. In precisely five paragraphs,
minimum of five sentences per paragraph, discuss your stand regarding
the statement with at least 5 reliable references supporting your reaction.
CONSTRUCTION
Top 10 Construction
Industry Trends To
Watch For In 2022
By: BigRentz, Inc. on December 13,
2021
in
2022
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
I need answers to problems 7, 8, and 9.
NOTE: Please stop wasting my time and yours by rejecting my question because it DOES NOT REQUIRE YOU TO DRAW anything at all. They are simple questions pertaining to the print provided. READ THE INSTRUCTIONS of the assignment before you just reject it for a FALSE reason or leave it for someone to answer that actually wants to do their job. Thanks.
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
Please solve the question on the sheet and get a clear picture and submit the picture.
thankyou
arrow_forward
I need the answer quickly
arrow_forward
Department of Mechanical Engineering
PRINCIPLES OF COMPUTER AIDED ENGINEERING – MENG303
Please solve the problem by keupordDepartment of Mechanical Engineering
PRINCIPLES OF COMPUTER AIDED ENGINEERING – MENG303
Please solve the problem by keupord
arrow_forward
Please show your solution and at the same time BOX and SPECIFY the answers that corresponds to each blank on the question. Make sure to fill all the blanks. Thank you.
STRICKLY FOLLOW THIS:
Calculated Answers
Express your answers without rounding off and without scientific notation unless instructed otherwise.
Multiple Blanks
Write powers or subscript as is. Ex: Use b2 if you mean b2 or b2
Spell out Greek letters. Ex: Use pi if you mean greek letter pi
Write answers without spaces. Ex: Use 2epsilon0r3 if you mean 3e0r3
Write fractions with a slash. Ex: Use 1/2
arrow_forward
Can someone please help to solve all of the following problem showing all work and include a load chart. Thank you!
arrow_forward
Do not give answer in image and hand writing
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
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 air-fuel mixture intake and exhaust gasses
The spark plug when it is in the active mode
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
I need the answer as soon as possible
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
Create a list of operations for the blueprint provided below. The list of operations must be in chronological order. Upload a PDF file of your answers to the same assignment tab.
arrow_forward
I want the answer of part c
arrow_forward
I need answers to questions 13, 14, and 15 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
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
- Please draw the right side view. Don't copy from anywhere else. Please write the dimensions as well.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_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_forward4. Documents business requirements use-case narratives.for only one process note: please i want Documents like this in picarrow_forwardBelow is problem MV1 from the course pack. In an earlier assignment, you created a multiview drawing of this part. Model this part with SolidWorks, with each grid spacing equal to one inch. Create a SolidWorks drawing of this part, with Front, Top, and Right Views. Import dimensions from the SolidWorks part file, and place them on the drawing so that they can be easily read. Add a note that all dimensions are inches. Add your personalized title block that you created in Chapter 2 to this drawing. *Important: Save the drawing first as SolidWorks Drawing (filetype *.slddrw) and then as an eDrawing (filetype *.edrw)! You will upload the eDrawing in Blackboard, not the SolidWorks Drawing - the SolidWorks drawing is associated with the part file, I cannot open the sw drawing unless you also send the part file; however, l can open the eDrawing without the part file.arrow_forward
- Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example Thank you.arrow_forwardI need answers for problems 13, 14, and 15 pertaining to the print provided. NOTE: If you refuse to answers all 3 parts and insist on wasting my question by breaking down 1 simple question into 3 parts, then just leave it for someone else to answer. Thank you.arrow_forwardI 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-5a84bf505857arrow_forward
- Q1: write a program to enter any text and compute its length. Q2: Design a form with a text box. Use select statement so that when user enters g, b, r and y then form colored to green, blue, red, and yellow respectively. Q3: Write a program to print multipliers of 5 (from 5 to 50)arrow_forwardQ \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_forwardNote: Round your final answer to 2 decimal places if it is not a whole number. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.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