exam_1_problems_engelmanj
.docx
keyboard_arrow_up
School
University Of Arizona *
*We aren’t endorsed by this school
Course
420
Subject
Mechanical Engineering
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by BarristerHerringMaster551
GIST 420
Exam 1 Section 2 Problem Sets
Part 1 – Database Normalization
arboretum
(
noun,
\ˌär-bə-ˈrē-təm\ ) -- a place where trees, shrubs, and herbaceous plants are cultivated for scientific and educational purposes A major university has established an arboretum on its campus for educational and research purposes. The arboretum committee has collected data on the plant specimens that are included in the arboretum. In order to manage the plant specimens within the arboretum, the committee has collected data on the plant specimens
. These data include the individual plant specimen number, the genus and species of the plant, the value of the particular specimen, the origins of the species, and the forms that the species can occur in.
This information has been placed in an un-normalized
spreadsheet. A few rows of the spreadsheet are show below:
Specimen#
Genus
Species
Value
Origin 1
Origin 2
Lifeform 1
Lifeform 2
1
Ligustrum
lucidum
outstanding
China
Japan
tree
shrub
2
Agave
americana
outstanding
tropics
succulent
3
Ficus
cariaca
heritage
Mediter.
tree
4
Lagerstroemia
indica
none
Asia
Australia
tree
shrub
5
Fouquieria
columnaris
heritage
Mexico
tree
6
Xylosma
congestum
none
tropics
tree
shrub
7
Agave
americana
mutated
tropics
succulent
8
Ficus
pumila
none
Asia
Australia
vine
You will be decomposing this un-normalized relation into a series of normalized relations to be used in a relational database management system. To complete the following sections, consider the following assumptions about the data in the spreadsheet:
Specimen#
(specimen number) refers to an occurrence of an individual plant
on the campus
There may be more than one plant of a given taxon (
genus
and species
) on campus, but each individual is a unique occurrence and receives a unique specimen#. (taxon = genus + species)
There can be multiple species of one genus among the specimens
Value
refers to the primary type of special value (if any) of an individual plant specimen
(not the taxon)
Each individual specimen can have only one
Value
Origin1
and Origin2
refer to the historical distribution of the taxon in the world; some taxa have more than one
distribution origin.
Lifeform1
and Lifeform2
refers to the structure of the taxon; plants of these taxa would not have more than two lifeforms (succulent, vine, tree, shrub)
There is no order or importance implied by the column names Origin1
and Origin2
There is no order or importance implied by the column names Lifeform1
and Lifeform2
There are more rows in the spreadsheet than are shown above
Genus
does not
determine species
Diagram the functional dependencies (9 pts)
On the header below please indicate the functional dependencies in the arboretum spreadsheet. Draw arrows to the dependent attribute from the determining attribute, e.g. A
B would indicate that B is functionally dependent on A.
Specimen#
Genus
Species
Value
Origin 1
Origin 2
Lifeform 1
Lifeform 2
Joseph Engelman
GIST 420
Exam 1 Section 2 Problem Sets
Circle the letter of the BEST normalized database scheme solution from the diagram sets below: (18 pts.)
A)
Specimens (Specimen#
, Genus, Species, Value, Origin1, Origin2, Lifeform1, Lifeform2)
B) Specimens (Specimen#
, Genus, Species, Value)
Lifeforms (Lifeform_ID, Genus, Species
, Lifeform)
Origins (Genus, Species, Origin
)
C) Specimens (Specimen#
, GS_ID)
Taxon (GS_ID
, Genus, Species, Value)
Lifeforms ( GS_ID
, Lifeform
)
Origins (GS_ID, Origin
)
D) Specimens (Specimen#,
GS_ID, Value)
Taxon (GS_ID
, Genus, Species)
Lifeforms (GS_ID, Lifeform
)
Origins (GS_ID, Origin
)
Joseph Engelman
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
Please solve, engineering econ
arrow_forward
HELLO, CAN U HELP ME TO MY RESEARCH PART?, MY RESEARCH PART IS DATA GATHERING PROCEDURE, AND I'LL SEND THE SAMPLE THAT MY TEACHER GAVE ME, THIS IS MY TITLE BTW " Students who play Axie Infinity as scholars do not make enough money to support their studies: a qualitative study of Axie Infinity scholars among the students of Precious High Academy" THANKS!
arrow_forward
I need help solving this problem.
arrow_forward
Please answer the 4th question
arrow_forward
Scenario
You are assigned a role as a mechanical engineer for a vehicle design manufacturing company. Your
department has a software to perform numerical differentiation and integration. To be able to verify the
results of using the software and validate these results, your department manager has asked you to
analytically perform some tasks to validate the results generated by the software.
Q: is the last two digits of your student Id number. If your number is (20110092) then Q=92.
P: is the last digit of your student Id Number. If your number is (20110092) then P=2,
If that digit equals zero then use P=1. Example: If your number is (20110040) then P=1.
Task 1
Determine the gradient of following functions at the given points:
a) x(t) = (2t7 + P t-2)² + (6vi – 5) when t = 1
5s+7
b) v(s) =
when s = 3
(s²-P)2
c) i(t) = 5(1 – In(2t – 1) )
when t= 1 sec.
d) V(t) =5sin(100nt + 0.2) Volts , find i(t) = 10 × x10-6 dV©)
Ampere when t= 1ms.
dt
e) y(t) = e¬(t-n) sin(Qt + P)
when t = n radian
f)…
arrow_forward
I Blackboard @ Texas Tech Uni x
Bb MasteringEngineering - Spri x
E MasteringEngineering Maste X
C Suppose That H = 3.8 M . (Fi x
X Mathway | Calculus Problem x
y! how to take a full page scree
A session.masteringengineering.com/myct/itemView?assignmentProblemID=12360392&offset=next
ABP O
Tp E
G
KAssignment #3
Fundamental Problem 2.29
5 of 6
>
I Review
Part A
Find the magnitude of the projected component of the force along the pipe AO.
(Figure 1)
Express your answer to three significant figures and include the appropriate units.
µA
FAO =
Value
Units
Submit
Request Answer
Figure
4 m
F = 400 N
6 m
5 m
B
4 m
10:31 PM
O Type here to search
2/7/2021
arrow_forward
Help me solve this ENGINEERING GRAPHICS question
Use 0.25 cartesian paper or 0.25 Isometric paper please.
arrow_forward
Solve correctly
arrow_forward
I could not figure this problem during lecture please help me solve it! ANSWER ALL OR DO NOT ATTEMPT
arrow_forward
M Inbox (58) - tasin5 x
M It's official. Your p X
My Questions | ba x
G Security Checkup x
G Privacy Checkup
M Inbox (58) - tasin x
M New assignment: X
A Term Paper (Sectic X
+
i classroom.google.com/u/1/c/NDA5NTY×OTA5MZU0/a/NDAyNTUyNDIzNzk5/details
E Apps M Gmail
YouTube
A Maps
E Reading list
Term Paper Question
= Final Exam of ME 331
Determine the natural frequency of the system which is shown below. Here, springs geometries
O Term Pa
are similar but spring 1 made of mild steel, spring 2 made of copper, d= 5 mm, spring index = 10,
Assigned
Md Maruf Billah •
number of active coils in the springs = 8, m2= mo, r2=r¡ = 25 mm = 0.4R = 5t and the pulleys are
100 points
made of cast iron. Take other information which are necessary to solve the problem from
dd or create
internet/literature/book.
rk as done
mments
Class comme
k2
to Md Maruf Billah
m.
Add a class comm
m2
k1
Center line
Cross section of the springs
Cross section of the pulleys
Page
1 | 1
2:03 РМ
Type here to search
33°C Rain…
arrow_forward
ethuto.cut.ac.za/ultra/courses/_9063_1/cl/outline
Question Completion Status:
Moving to another question will save this response.
gestion 9
MECHANICAL AND CIVIL ENGINEERING
Two forces
and 2 are acting on a particle.
20 N
45°
30°
16N
The magnitude of the resultant force is:
O4 287+6.147
O B. 12.37 N
OC 28.67 N
D.
None of the above is correct
arrow_forward
Chrome
File
Edit
View
History
Bookmarks
People
Tab
Window
Help
McGraw-Hill Campus - ALEKS Science - CHM1045 GEN CHEM 1 BLENDED 669113
A bconline.broward.edu/d21/le/content/466883/fullscreen/12868783/View
McGraw-Hill Campus - ALEKS Science
O GASES
Interconverting pressure and force
A chemistry graduate student is designing a pressure vessel for an experiment. The vessel will contain gases at pressures up to 470.0 MPa. The student's
design calls for an observation port on the side of the vessel (see diagram below). The bolts that hold the cover of this port onto the vessel can safely withstand
a force of 2.80 MN.
pressure vessel
bolts
side
View
port
Calculate the maximum safe diameter w of the port. Round your answer to the nearest 0.1 cm.
O cm
Explanation
Check
O2021 McGraw-Hill Education. All Rights Reserved. Terms of Use
FEB
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
Identify the lines
arrow_forward
Please give me the answers for this i been looking at this for a hour and my head hurts
arrow_forward
Don't copy paste someone else answer if I get to know I'll report and downvote too do on your own and only handwritten with proper steps not that handwritten only
arrow_forward
What are the answers in given problem
arrow_forward
The planning department of Abstract Office Supplies has been asked to determine whether the company should introduce a new computer desk next year. The department estimates that $7,000
of new manufacturing equipment will need to be purchased and that the cost of constructing each desk will be $200. The department also estimates that the revenue from each desk will be $550
a. Determine the revenue function R(x) from the sale of x desks. R(x) =
Clear all
Check answer
View an example
et more help -
Help me solve this
9:05 PM
1/24/2022
L390 Y
Insert
Home
End
F12
F10
F11
F9
F7
F8
Esc
F5
F6
F4
F3
F2
FnLock
F1
&
%23
$4
80
9.
@
7
2
3
4
Y
arrow_forward
57% O O
P 1:21
ZAIN IQ I.
Lecture (5).pptx - Microsoft PowerPoint
Animations
Slide Show
Review
View
IIA Text Direction-
|Align Text
Convert to Smartart {}* Arrange Quick
Shape Fill-
Shape Outline Repla
A Find
32, AA =,=,| 一前
u s
AL1ゆ4G-
US abe AV
Aa- A- EE
Styles
Shape Effects
A Select
Font
Paragraph
Drawing
Editin
Engineering Mechanics
Statics (Equilibrium of a Particle)
Ayad A. M.
Q/ Use the conditions of equilibrium to solve the following problem
and find the magnitude of the resultant force acting on the screw eye
and its direction measured clockwise from the x axis.
F- 250 N
F- 150 N
30
105
9 68% O
底 )
arrow_forward
What would be the analysis of the given table or graph?
arrow_forward
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
arrow_forward
e IY: %VY OLD ?
د ميکانيك شهري 2021.pdf
UNIVERSITY OF BASRAH - COLLEGE OF ENGINEERING
DEPARTMENT OF CIVIL ENGINEERING
Subject: Engineering Mechanics-Static
Class: 1st year, 1st term
Exam. : Semester
Date: 16/3/2021
Examiner: Dr. Mazin, Dr. Aqeel, Dr.Ahid and Dr.Jaffar
Time: 1.5Hours
Q1] (10 Marks)
A- In Fig.A , If the resultant force acting on the bracket is to be 642 N directed
along the positive x axis, determine the magnitude of F.
B- In Fig.B , Determine the magnitude of the resultant force acting on the screw
eye and its direction measured clockwise from the x axis.
C- In Fig.C , Resolve the 100N force into components along the u and v axes, and
determine the magnitude of each of these components.
D- In Fig.D, Determine the moment of the force about point O.
300 N
60N
25°
32
45°
60°
505 N
50°
40N
Fig. A
50 N
Fig. B
400 N
100N
28°
18
2.12 m
Fig. C
2.12 m
Fig.D
Q2] (10 Marks)
A- In Fig.A , Replace the loading system by an equivalent resultant force and
specify where the resultant's…
arrow_forward
immediately
arrow_forward
I need this quickly please please please its in mechanical engineering: dynamic please please please i need this
arrow_forward
Hello tutors, help me. Just answer "Let Us Try"
arrow_forward
Please do only C part with breif explanation. I want typed solution. Not hand written
arrow_forward
save me please , engineering instrumentations
arrow_forward
The estimated times and immediate predecessors for the activities in a project at Howard Umrah's rotinal scanning company are given in the following tablo. Assume
that the activity times are independent.
Time (weeks)
Immediate
Time (weeks)
Immediate
Activity
b
Predecessor(s) Activity
b.
Predecessor(s)
a
a
7.
10
13
10
12
A
B
6
12
18
14
This exercise contains only parts a, b, c, d, and e
a) Based on the activity time estimates, the expected times and variance for each of the activities are (round your response to two decimal places)
Expected
Time
Activity
Variance
A
B
If the time to complete the activitios on the critical path is nomally distributed, thern the probabilty that the critical path will be finished in 22 weeks or less -
(enter as a probability and round your response to two decimal places)
0 of 1 ques
the time to complete the activities on the non critical path in normaly distributed, then the probability that the non criical path will be finished in 22 weeks ar less
(enter…
arrow_forward
answer in excel file , clear fomula and chart. and calculation method.
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
Motiyo
Add explanation
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
- Please solve, engineering econarrow_forwardHELLO, CAN U HELP ME TO MY RESEARCH PART?, MY RESEARCH PART IS DATA GATHERING PROCEDURE, AND I'LL SEND THE SAMPLE THAT MY TEACHER GAVE ME, THIS IS MY TITLE BTW " Students who play Axie Infinity as scholars do not make enough money to support their studies: a qualitative study of Axie Infinity scholars among the students of Precious High Academy" THANKS!arrow_forwardI need help solving this problem.arrow_forward
- Please answer the 4th questionarrow_forwardScenario You are assigned a role as a mechanical engineer for a vehicle design manufacturing company. Your department has a software to perform numerical differentiation and integration. To be able to verify the results of using the software and validate these results, your department manager has asked you to analytically perform some tasks to validate the results generated by the software. Q: is the last two digits of your student Id number. If your number is (20110092) then Q=92. P: is the last digit of your student Id Number. If your number is (20110092) then P=2, If that digit equals zero then use P=1. Example: If your number is (20110040) then P=1. Task 1 Determine the gradient of following functions at the given points: a) x(t) = (2t7 + P t-2)² + (6vi – 5) when t = 1 5s+7 b) v(s) = when s = 3 (s²-P)2 c) i(t) = 5(1 – In(2t – 1) ) when t= 1 sec. d) V(t) =5sin(100nt + 0.2) Volts , find i(t) = 10 × x10-6 dV©) Ampere when t= 1ms. dt e) y(t) = e¬(t-n) sin(Qt + P) when t = n radian f)…arrow_forwardI Blackboard @ Texas Tech Uni x Bb MasteringEngineering - Spri x E MasteringEngineering Maste X C Suppose That H = 3.8 M . (Fi x X Mathway | Calculus Problem x y! how to take a full page scree A session.masteringengineering.com/myct/itemView?assignmentProblemID=12360392&offset=next ABP O Tp E G KAssignment #3 Fundamental Problem 2.29 5 of 6 > I Review Part A Find the magnitude of the projected component of the force along the pipe AO. (Figure 1) Express your answer to three significant figures and include the appropriate units. µA FAO = Value Units Submit Request Answer Figure 4 m F = 400 N 6 m 5 m B 4 m 10:31 PM O Type here to search 2/7/2021arrow_forward
- M Inbox (58) - tasin5 x M It's official. Your p X My Questions | ba x G Security Checkup x G Privacy Checkup M Inbox (58) - tasin x M New assignment: X A Term Paper (Sectic X + i classroom.google.com/u/1/c/NDA5NTY×OTA5MZU0/a/NDAyNTUyNDIzNzk5/details E Apps M Gmail YouTube A Maps E Reading list Term Paper Question = Final Exam of ME 331 Determine the natural frequency of the system which is shown below. Here, springs geometries O Term Pa are similar but spring 1 made of mild steel, spring 2 made of copper, d= 5 mm, spring index = 10, Assigned Md Maruf Billah • number of active coils in the springs = 8, m2= mo, r2=r¡ = 25 mm = 0.4R = 5t and the pulleys are 100 points made of cast iron. Take other information which are necessary to solve the problem from dd or create internet/literature/book. rk as done mments Class comme k2 to Md Maruf Billah m. Add a class comm m2 k1 Center line Cross section of the springs Cross section of the pulleys Page 1 | 1 2:03 РМ Type here to search 33°C Rain…arrow_forwardethuto.cut.ac.za/ultra/courses/_9063_1/cl/outline Question Completion Status: Moving to another question will save this response. gestion 9 MECHANICAL AND CIVIL ENGINEERING Two forces and 2 are acting on a particle. 20 N 45° 30° 16N The magnitude of the resultant force is: O4 287+6.147 O B. 12.37 N OC 28.67 N D. None of the above is correctarrow_forwardChrome File Edit View History Bookmarks People Tab Window Help McGraw-Hill Campus - ALEKS Science - CHM1045 GEN CHEM 1 BLENDED 669113 A bconline.broward.edu/d21/le/content/466883/fullscreen/12868783/View McGraw-Hill Campus - ALEKS Science O GASES Interconverting pressure and force A chemistry graduate student is designing a pressure vessel for an experiment. The vessel will contain gases at pressures up to 470.0 MPa. The student's design calls for an observation port on the side of the vessel (see diagram below). The bolts that hold the cover of this port onto the vessel can safely withstand a force of 2.80 MN. pressure vessel bolts side View port Calculate the maximum safe diameter w of the port. Round your answer to the nearest 0.1 cm. O cm Explanation Check O2021 McGraw-Hill Education. All Rights Reserved. Terms of Use FEBarrow_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