DAD 220 Module Four Major Activity Database Documentation Template
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
220
Subject
Mechanical Engineering
Date
Feb 20, 2024
Type
docx
Pages
6
Uploaded by DrWillpowerNewt32
DAD 220 Module Four Major Activity Database Documentation Template
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 the command: Load data infile ‘/home/codio/workspace/customers.csv’ into table customers fields terminated by ‘,’ line terminated by ‘\n’; and I repeated the same step for the order and RMA table.
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.
The screenshot above shows the command inner join command where it brings up the order information from customers in Framingham, MA. The command used was SELECT COUNT * as Recordcount FROM Customers INNER JOIN Orders
ON Customers.Customers_ID Where City = ‘Framingham’ AND State = ‘Massachusetts’;
i.
How many records were returned?
505 records were returned. 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. 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
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
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
Which clause of an SQL query displays the results in a specific sequence?
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
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
Matlab code:
Read images from a folder with the
directory using the MATLAB code.
Be specific and don't write general
answer.
arrow_forward
Hello, statics please help
Â
tabular method
arrow_forward
Important instruction: This question uses the last three-digit value (L3D) of individual student matrix number. 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 examAdditional instruction: These questions use the last three-digit value (L3D) of individual student matrix number. 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.ple 10(L3D) means 10 x L3D.
Â
subject name is
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
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
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
Which clause of an SQL query is used to restrict the number of rows returned?
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
pls solve this ques on your own without copying from other platforms I'll give you multiple likes
arrow_forward
Acceleration analysis: Hello, I am stuck on the last part (d) and I'm not sure how to start. I have solved all other parts, Thanks.
arrow_forward
2.
(If relevant) A clearly labeled diagram (or diagrams) clearly pertaining to your analysis with a coordinate system and relevant labels.
Final answer with appropriate units and significant figures. You can use the fprintf() command in MATLAB to format numerical results
A 2-3 sentence reflection on your answer. Does it make sense? Why or why not? What are some implications?
arrow_forward
Command: PLOTTERMANAGER (from the autocad file m
TO CONFIGURE A LOCAL, NONSYSTEM PLOTTER
10. PROFILES-Controls the use of profiles. A profile is a configuration you define.
367N
367N
R=1.0m
426N
426N
B.
426N
C.
The two identical sphemes having oqual weights of 367N
is placed on top of the three identic al sphere's w/ 426 N
as their reight . Compute the reaction A,B and C
arrow_forward
Please solve the Below problem using 'Design data book'. And while solving problem add some table or figure reference number before taking each reference value. If answer is right then I will give you upvote/like.
arrow_forward
INSTRUCTIONS:
Please write clearly and understandable way.
Write all the corresponding GIVEN with their corresponding symbols and units.
List all the MISSING/REQUIRED, and list all the FORMULA that will be used.
• DRAW/ILLUSTRATE THE DIAGRAM/CIRCUIT OR DRAWINGS that is related to the
problem, IF POSSIBLE, which is HIGHLY REQUIRED.
The CONVERSION calculations with their corresponding symbols and units is
required.
The problem's SOLUTION must be solved in a step-by-step, no shortcut, again, with
their corresponding symbols and units.
• BOXED the Final Answer.
PROBLEM:
The compressor of a large gas turbine power plant receives 12kg/s of surrounding air at
95kPa and 20°C. At the compressor outlet, air exits at 1.52MPa, 430°C, Determine the
flow energy requirements in MW.
a) 1.412
b) 2.42
c) 1.01
d) 1.614
arrow_forward
Question 01:
a) What do you know about Pro/Engineer software and its applications in the field of
Mechanical Engineering? Write down the name of any three CAD softwares?
b) Define the following:
i.
Entity.
ii.
Parameter.
iii.
Weak dimensions and weak constraints.
iv.
Strong dimensions and strong constraints.
ICLO-11
arrow_forward
3. As a robotic engineer, your boss needs you to move the gripper on the UGV to the target
object. The workspace is shown Figure 1. In order to finish the task, you need to find the
correct representation.
{b}
{c}
{e}
{s}
{d}
Figure 1 The Workspace
The fixed frame is {s}, a body frame {b} is attached to the chassis of the UGV, a body
frame {c} is attached to the gripper, a body frame {d} is attached to the sensor, and a
body frame {e} is attached to the target object. The sensor's location is known as Tsd,
the chassis of the UGV's location is known as Tsb, the gripper's location's is Tsc, and the
target object's location is Tse. The sensor can detect the target object, so the target
object can be represented in the sensor's frame. The configuration of the UGV is
reported simultaneously, and the gripper's configuration is also known. How to
represent the target object in the gripper's frame?
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
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
The Weather Monitor. Your South American expedition splits into two groups: one that stays at home base, and yours that goes off to
set up a sensor that will monitor precipitation, temperature, and sunlight through the upcoming winter. The sensor must link up to a
central communications system at base camp that simultaneously uploads the data from numerous sensors to a satellite. In order to
set up and calibrate the sensor, you will have to communicate with base camp to give them specific location information.
Unfortunately, the group's communication and navigation equipment has dwindled to walkie-talkies and a compass due to a river-raft
mishap, which means your group must not exceed the range of the walkie-talkies (3.0 miles). However, you do have a laser rangefinder
to help you measure distances as you navigate with the compass. After a few hours of hiking, you find the perfect plateau on which to
mount the sensor. You have carefully mapped your path from base camp around lakes and…
arrow_forward
soon in detail typed .don't copy I will downvote
arrow_forward
This for Matlab
Please modify the script bisect.m to report/create the iteration table.
arrow_forward
Only use autocad please and show every step to create it and i will definitely like the answer. Thanks, steps are mandatory pls
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
Take your time for solving problem. Please solve the Below problem using 'Design data book'. And while solving problem add some table or figure reference number before taking each reference value. If answer is right then I will give you upvote/like.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9780190698614/9780190698614_smallCoverImage.gif)
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134319650/9780134319650_smallCoverImage.gif)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259822674/9781259822674_smallCoverImage.gif)
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118170519/9781118170519_smallCoverImage.gif)
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337093347/9781337093347_smallCoverImage.gif)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118807330/9781118807330_smallCoverImage.gif)
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Related Questions
- 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_forwardWhich clause of an SQL query displays the results in a specific sequence?arrow_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_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_forwardMatlab code: Read images from a folder with the directory using the MATLAB code. Be specific and don't write general answer.arrow_forwardHello, statics please help  tabular methodarrow_forward
- Important instruction: This question uses the last three-digit value (L3D) of individual student matrix number. 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 examAdditional instruction: These questions use the last three-digit value (L3D) of individual student matrix number. 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.ple 10(L3D) means 10 x L3D.  subject name isarrow_forwardAutoSave 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 IZarrow_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
- 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 answeringarrow_forwardWhich clause of an SQL query is used to restrict the number of rows returned?arrow_forwardYou 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
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
![Text book image](https://www.bartleby.com/isbn_cover_images/9780190698614/9780190698614_smallCoverImage.gif)
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134319650/9780134319650_smallCoverImage.gif)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259822674/9781259822674_smallCoverImage.gif)
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118170519/9781118170519_smallCoverImage.gif)
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337093347/9781337093347_smallCoverImage.gif)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118807330/9781118807330_smallCoverImage.gif)
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY