DAD 220 Module Three 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 cdpoole1
DAD 220 Module Three Major Activity Database Documentation Template Overview
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 show. 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 help. Create a Database
1.
In your integrated development environment (IDE), create a database schema called QuantigrationRMA. List out the database name. Provide the SQL commands you ran to successfully complete this in your answer, then connect to it:
mysql> CREATE database QuantigrationRMA;
mysql> USE QuantigrationRMA;
2.
Using the entity relationship diagram (ERD) as a reference, create the following
tables with the appropriate attributes and keys
:
a.
A table named customers in the QuantigrationRMA database as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
mysql> CREATE TABLE Customers
-> (Customer_ID INT,
-> First_Name VARCHAR(25),
-> Last_Name VARCHAR(25),
-> Street VARCHAR(50),
-> City VARCHAR(50),
-> State VARCHAR(25),
-> Zip_Code INT,
-> Telephone VARCHAR(15));
b.
A table named orders in the QuantigrationRMA database as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
mysql> CREATE TABLE Orders
(Order_ID INT,
Customer_ID INT,
SKU VARCHAR (20),
Description VARCHAR(50));
c.
A table named rma
in the QuantigrationRMA database as defined on the project ERD. Provide the SQL commands you ran against MySQL to complete this successfully in your answer:
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
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
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
I want to answer all the questions by handwriting.
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
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
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
Directions: modify the standard SolidWorks ANSI B Landscape layout for your own engineering
consulting company. Include a logo, change the legal notice, and make other changes as you see fit.
Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions.
Usual DRAWN BY.
Deliverable: screenshot of your personalized layout/template without any drawings on it.
arrow_forward
I need help solving this problem.
arrow_forward
Choose the correct answer, please, I need the solution as soon as possible
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
Instructions:
• Create a step by step and detailed explanation on how to solve the problem attached
below.
Create a script-like document like how you would explain this in a video presentation.
Explain every single step with full details.
Think of it that you have a youtube channel and you are explaining this problem step by
step and on this document you will put the transcript of your video presentation except
there is no video presentation only the transcript is needed.
• Include complete solution and what formulas are used.
PROBLEM:
Given is a thin-walled tube with the following data:
Wall thickness- 2mm
ABC is a sector with a radius of 100 mm
AOD & COD is a triangle
Torque is 800 N.m
Length of the thin walled tube is 2 m.
Use G=24 GPa for aluminium
B
30⁰
Determine the following:
a. Enclosed Area
b. Perimeter of the thin walled tube
c. Shear flow
d. Shear stress
e. Angle of twist
arrow_forward
solve this please on ANSYS and give me screenshots how you did it, please
arrow_forward
Draw it on the graph provided please!
arrow_forward
Please draw the right side view.
Don't copy from anywhere else. Please write the dimensions as well.
arrow_forward
Please do only C part with breif explanation. I want typed solution. Not hand written
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
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
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
arrow_forward
AutoCAD is one of the ready-made
programs that help workers in the field
of design and engineering drawing
because
OThe possibilities it provides to facilitate the
design process.
OThe non-possibilities it provides to facilitate the
design process.
OThe possibilities it non-provides to facilitate the
design process.
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
Don't Use Chat GPT Will Upvote And Give Handwritten Solution Please
arrow_forward
Please solve, engineering econ
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
Follow the instructions carefully.
arrow_forward
Document three phases of writing a CNC program in the form of a block diagram.
Don’t need to write the actual CNC program.
arrow_forward
In a hypothetical scenario respond to the following email to reasuure the owner and in an informative and professional way.
Dear Project Manager-
I am so excited to have broken ground on the new mixed use space. As I watch the underground utilities such as water, storm drain, and sewer get installed I find myself worrying about failures. What steps are you taking to ensure those systems will not have to be dug up and repaired later in the construction process? We cannot afford a delay of any kind. Could you please explain how you plan to prevent any delays and ensure that the systems are functional and leak free.
The other concern that has come up that I would like to address now is the comfort of the office staff. Our current building is not comfortable. I am wondering why. We have the temperature appropriately set and it is easily maintained, but people still complain. What can we do to ensure they will be comfortable in the new building? A few months ago I asked one of our…
arrow_forward
You are spending the summer as an assistant learning how to navigate on a large ship carrying freight across Lake Erie. One day, you and your ship are to travel across the lake a distance of 200 km traveling due north from yourorigin port to your destination port. Just as you leave your origin port, the navigation electronics go down. The captain continues sailing, claiming he can depend on his years of experience on the water as a guide. The engineers work on the navigation system while the ship continues to sail,and winds and waves push it off course. Eventually, enough of the navigation system comes back up to tell you your location. The system tells you that your current position is 50.0 km north of the origin port and 25.0 km east of the port. The captain is a little embarrassed that his ship is sofar off course and barks an order to you to tell him immediately what heading he should set from your current position to the destination port. Give him an appropriate heading angle.
arrow_forward
I want the answer of part c
arrow_forward
Don't use chatgpt will upvote
arrow_forward
Identify the lines
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
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
- 4. Documents business requirements use-case narratives.for only one process note: please i want Documents like this in picarrow_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_forwardI want to answer all the questions by handwriting.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_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_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
- Directions: modify the standard SolidWorks ANSI B Landscape layout for your own engineering consulting company. Include a logo, change the legal notice, and make other changes as you see fit. Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions. Usual DRAWN BY. Deliverable: screenshot of your personalized layout/template without any drawings on it.arrow_forwardI need help solving this problem.arrow_forwardChoose the correct answer, please, I need the solution as soon as possiblearrow_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_forwardInstructions: • Create a step by step and detailed explanation on how to solve the problem attached below. Create a script-like document like how you would explain this in a video presentation. Explain every single step with full details. Think of it that you have a youtube channel and you are explaining this problem step by step and on this document you will put the transcript of your video presentation except there is no video presentation only the transcript is needed. • Include complete solution and what formulas are used. PROBLEM: Given is a thin-walled tube with the following data: Wall thickness- 2mm ABC is a sector with a radius of 100 mm AOD & COD is a triangle Torque is 800 N.m Length of the thin walled tube is 2 m. Use G=24 GPa for aluminium B 30⁰ Determine the following: a. Enclosed Area b. Perimeter of the thin walled tube c. Shear flow d. Shear stress e. Angle of twistarrow_forwardsolve this please on ANSYS and give me screenshots how you did it, pleasearrow_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