DAD 220 Module Four Major Activity Database Documentation Template-Makenna McLeod
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Jan 9, 2024
Type
docx
Pages
5
Uploaded by DukeWaterDragonfly18
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.
I used
LOAD DATA INFILE ‘/home/codio/workspace/customers.csv’ INTO TABLE Customers
FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’;
LOAD DATA INFILE ‘/home/codio/workspace/orders.csv’ INTO TABLE Orders FIELDS
TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’;
LOAD DATA INFILE ‘/home/codio/workspace/rma.csv’ INTO TABLE RMA FIELDS
TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’;
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?
[
There are 505 rows returned from the customer orders from Framingham, Massachusetts]
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
only those that are located in Massachusetts.
ii.
Record an answer to the following question: How many records were returned?
[982 records were returned from Massachusetts.]
C.
Write an SQL query to insert four new records into the Orders and Customers tables
using the following data:
i.
Customers Table
CustomerID
FirstName
Lastname
StreetAddress
City
State
ZipCode
Telephone
100004
Luke
Skywalker
17 Maiden Lane
New York
NY
10222
212-555-1234
100005
Winston
Smith
128 Sycamore Street
Greensboro
NC
27401
919-555-6623
100006
MaryAnne
Jenkins
2 Coconut Way
Jupiter
FL
33458
321-555-8907
100007
Janet
Williams
58 Redondo Beach
Blvd
Torrence
CA
90501
310-555-5678
[Insert screenshot and brief explanation here.]
ii.
Orders Table
OrderID
CustomerID
SKU
Description
1204305
100004
ADV-24-10C
Advanced Switch 10GigE Copper 24 port
1204306
100005
ADV-48-10F
Advanced Switch 10 GigE Copper/Fiber 44 port
copper 4 port fiber
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
The first photo is the question, where the 2nd shows some problem solving strategies
arrow_forward
7
Create your own 3 unique problems on the First Law of Thermodynamics/Forms of Energy and Equations of State with detailed Solutions. Include diagrams as much as possible
arrow_forward
Please draw the right side view.
Don't copy from anywhere else. Please write the dimensions as well.
arrow_forward
Create an illustration or diagram of the amusement park ride called THE BUMPER CAR RIDE, then proceed to add labels based on the guidelines provided within the image.
The screenshot is the example of the diagram BUT THAT IS A DIAGRAM OF THE GRAVITRON RIDE. I need an illustration DIAGRAM OF THE BUMPER CAR RIDE, do not answer using AI.
arrow_forward
Don't use chatgpt will upvote
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
Draw it on the graph provided please!
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 do only C part with breif explanation. I want typed solution. Not hand written
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 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
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
I need help solving this problem.
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
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
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
David is working on her farming business and faces the challenge of watering her plants daily,which is a tedious and time-consuming task, especially under the scorching sun. The path shefollows for watering the plants is illustrated in figure 1.David's son has taken on the task of designing a prototype to automate the watering process forher. Figure 2 depicts the design, featuring a set of rods. The curved path represents David'stypical watering route, and the straight rod AB AB is confined to move along the path due to the pinsat its ends. Water sprinklers will be positioned at points A and B to efficiently water the plants.At the instant shown in figure 2, point A has the motion shown while its at the edge of the path.Determine the velocity and acceleration of point B at this instant.
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
Please Asap
arrow_forward
For the air compressor shown in Figure below, the air enters from a large area and
exit from small one, explain why?
Instructions for answering this question: The answer to this questian is required as handwritten where you are
aiso required to add a Handwritten integrity Statement. Pieose follow the below steps:
1 Write on a blank poper your AUM student ID, full name, course code, section and date
2 Write the following integrity statement and sign:
"7 offirm that I have neither given nor received any help on this assessment and that personally compieted it
on my own."
3. Write your onswer to the obove question as required
4. Put your Original Civil ID card or AUM ID card on the poper
5 Toke o picture or scan, and uplood
Important note: if handwritten document is submitted without the integrity stotement including ID (Civil ID or
AUM ID), then the related handwritten question(s) will not be groded.
arrow_forward
Important instruction: These questions use the last three-digit value (L3D) of individual student matrix numbers. For example, if the matrix number is CD180264 then the L3D value is 264 (since the last three digits is 264). Some data require multiplication of the L3D value, for example, 10(L3D) means 10 x L3D
subject name is INDUSTRIAL ENGINEERING
arrow_forward
Don't Use Chat GPT Will Upvote And Give Handwritten Solution 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
WILL SURELY GIVE AN UPVOTE IF ANSWEREDSUBJECT: THERMODYNAMICSINSTRUCTION: FOLLOW THE SET OF INSTRUCTIONS THAT IS LISTED IN THE IMAGE.
Will Not Violate The Academic Integrity/Honor Code Violation.
arrow_forward
WILL SURELY GIVE AN UPVOTE IF ANSWEREDSUBJECT: THERMODYNAMICSINSTRUCTION: FOLLOW THE SET OF INSTRUCTIONS THAT IS LISTED IN THE IMAGE.
Will Not Violate The Academic Integrity/Honor Code Violation.
arrow_forward
AutoSave
STATICS - Protected View• Saved to this PC -
O Search (Alt+Q)
Off
ERIKA JOY DAILEG
EJ
File
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Help
Acrobat
O Comments
E Share
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
Situation 9 - A 6-m long ladder weighing 600 N is shown in the Figure. It is required to determine
the horizontal for P that must be exerted at point C to prevent the ladder from sliding. The
coefficient of friction between the ladder and the surface at A and B is 0.20.
25. Determine the reaction at A.
26. Determine the reaction at B.
27. Determine the required force P.
4.5 m
1.5 m
H=0.2
30°
Page 5 of 5
671 words
D. Focus
100%
C
ЕPIC
GAMES
ENG
7:24 pm
w
US
16/02/2022
IZ
arrow_forward
Please draw 5 and 6
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
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
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 detailed and neat hand written solution on pages in 2 hour . i will give you positive feedback.
Do not give me typed solution or copy paste work i need unique solution
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
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 first photo is the question, where the 2nd shows some problem solving strategiesarrow_forward7 Create your own 3 unique problems on the First Law of Thermodynamics/Forms of Energy and Equations of State with detailed Solutions. Include diagrams as much as possiblearrow_forwardPlease draw the right side view. Don't copy from anywhere else. Please write the dimensions as well.arrow_forward
- Create an illustration or diagram of the amusement park ride called THE BUMPER CAR RIDE, then proceed to add labels based on the guidelines provided within the image. The screenshot is the example of the diagram BUT THAT IS A DIAGRAM OF THE GRAVITRON RIDE. I need an illustration DIAGRAM OF THE BUMPER CAR RIDE, do not answer using AI.arrow_forwardDon't use chatgpt will upvotearrow_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
- Draw it on the graph provided please!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 do only C part with breif explanation. I want typed solution. Not hand writtenarrow_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 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_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
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