DAD 220 Module Four Major Activity Database Documentation Template
.docx
keyboard_arrow_up
School
University of Washington *
*We aren’t endorsed by this school
Course
502
Subject
Mechanical Engineering
Date
Dec 6, 2023
Type
docx
Pages
6
Uploaded by GrandFire11360
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.
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?
505 records are 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 are 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
1204307
100006
ENT-24-10F
Enterprise Switch 10GigE SFP+ 24 Port
1204308
100007
ENT-48-10F
Enterprise Switch 10GigE SFP+ 48 port
D.
In the Customers table, perform a query to count all records where the city is Woonsocket, Rhode Island.
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 show work in a handwritten format.
Don't use chatgpt.
Mechanics of materials/design.
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
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
Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example
Thank you.
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
I want to answer all the questions by handwriting.
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
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
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
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
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 show work in a handwritten format. Don't use chatgpt. Mechanics of materials/design.arrow_forward
- Please do only C part with breif explanation. I want typed solution. Not hand writtenarrow_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_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
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