DAD 220 Module Three Major Activity Database Documentation Template (1)
.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 KidFlower13108
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:
Explanation:
Used the command use Robinson; to connect to the correct table I’ve been using. Then used the command show tables; to make sure I was connected to the correct database. Then used the CREATE DATABASE QuantigrationRMA; to create a new database schema and used show tables; again to make sure that it was added into the databases. 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:
Explanation:
Used the commands:
CREATE TABLE Customers (
-> CustomerID INT NOT NULL PRIMARY KEY,
-> FirstName VARCHAR(25),
-> LastName VARCHAR(25),
-> Street VARCHAR(50),
-> City VARCHAR(50),
-> State VARCHAR(25),
-> ZipCode VARCHAR(10),
-> Telephone VARCHAR(15));
Then used the describe Customers; to see that the information I entered was correct. I first entered in the command show Customers; but forgot it should be describe and not show in order to view the new table since there isn’t anything in that table to show yet. 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:
Explanation: Used CREATE TABLE Orders (
-> OrderID INT NOT NULL PRIMARY KEY,
-> CustomerID INT,
-> SKU VARCHAR(20),
-> Description VARCHAR(50),
-> FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID));
Used this command to create another table as shown on the RMA Diagram, made sure to attach the primary key for the orderID since it shows PK on the table next to it, and then made the CustomerID a foreign key by using FOREIGN KEY (CustomerID) REFERENCES Custumers(CustomerID) to set the foreign and primary keys in the table. Then used describe Orders; to make sure that I got everything correct in this table. 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
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
Hello please show your correct and complete solution with schematic diagram and assumptions. Thanks ASAP!
Subject: Mechanical Engineering
arrow_forward
Question: Continue the previous work, pls create me an Grann Chart for Production of High-Quality Organic Rice. You may assume the activities and days.
arrow_forward
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
arrow_forward
Problem 1: You are working in a consulting company that does a lot of hand calculations for designs in
Aerospace Industry for mechanical, thermal, and fluidic systems. You took the Virtual engineering
course, and you want to convince your boss and the team you work to move to modelling and simulation
in computers using a certain software (Ansys, Abaqus, etc). Discuss the benefits and pitfalls of computer
based models used within an industrial environment to solve problems in engineering.
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
Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example
Thank you.
arrow_forward
Engineering Management :
Please Read your Reference: www.bigrentz.com for your own. Topic is " Top 10 Construction
Industry Trends To Watch For In 2022" Answer The following this.
Make a reaction paper of the statement. In precisely five paragraphs,
minimum of five sentences per paragraph, discuss your stand regarding
the statement with at least 5 reliable references supporting your reaction.
CONSTRUCTION
Top 10 Construction
Industry Trends To
Watch For In 2022
By: BigRentz, Inc. on December 13,
2021
in
2022
arrow_forward
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
Please explain
arrow_forward
Follow the instructions carefully.
arrow_forward
FIGURE Q2 shows an aluminum impeller with an outer diameter of 75 mm. As
a manufacturing engineer in 3DP-Engineering Sdn. Bhd. you are initially
required to write a comprehensive proposal to convince and justify, based on
engineering and economics fundamental, to your Production Manager to initially
produce a metal prototype. You are required to justify why a metal prototype
would be advantages to the company and what additive manufacturing
technology would be the best option.
In the next manufacturing planning stage, you are required to propose to
3DP-Engineering the best method to mass manufacture 500 pieces of good
quality aluminium impellers. Your proposal should evaluate and determine the
best casting method based on economic and engineering fundamentals as well.
Your Production Manager also requires you to include the proposed process
flow, predict potential defects, and means to overcome these defects.
Additionally, the Production Manager also requires you to propose with…
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
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