Assignment8
.docx
keyboard_arrow_up
School
Florida State College at Jacksonville *
*We aren’t endorsed by this school
Course
4212
Subject
Mechanical Engineering
Date
Dec 6, 2023
Type
docx
Pages
3
Uploaded by TVD20
ISM4212 – Assignment 8
Directions:
Answer Ch. 13 Problem 1 below. Refer to Module 5 in the course for directions on
submitting the completed file.
Ch. 13 Problem 1:
(50 pts)
1.
The university computer lab's director keeps track of the lab usage, as measured by the number
of students using the lab. This particular function is very important for budgeting purposes. The
computer lab director assigns you the task of developing a data warehouse in which to keep track of
the lab usage statistics. The main requirements for this database are to
Show the total number of users by different time periods.
Show usage numbers by time period, by major, and by student classification.
Compare usage for different major and different semesters.
Use the Ch13_P1.mdb database, which includes the following tables
:
USELOG
contains the student lab access data
STUDENT
is a dimension table containing student data
Given the three preceding requirements, and using the Ch13_P1.mdb data, complete the following
problems:
a. Define the main facts to be analyzed. (Hint: These facts become the source for the design
of the fact table.)
Student Classification
Total number of students by time
Semester
Major
b. Define and describe the appropriate dimensions. (Hint: These dimensions become the
source for the design of the dimension tables.)
Major
Semester
Time
Classification
1
ISM4212 – Assignment 8
c. Draw the lab usage star schema, using the fact and dimension structures you defined in
Problems 1a and 1b.
d. Define the attributes for each of the dimensions in Problem 1b.
Semester- Semester_id, Semester_description, Begin_date, End_date
Major- Major_code, Major_name
Class- Class_id, Class_description
Time- Time_id, Time_description, Begin_time, End_time
2
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
Help with this would be great, thanks!
arrow_forward
solve with steps please
arrow_forward
Help with this would be great, thanks!
arrow_forward
I need help with parts b and c (see images). This is the complete question and not a writing assignment. Make sure for this problem you list the following:
a. Known: State briefly what is known about the problem.
b. Schematic: Draw a schematic of the physical system or control volume.
c. Assumptions: List all necessary assumptions used to complete the problem.
d. Properties: Identify the source of property values not given to you in the problem.
e. Find: State what must be found.
f. Analysis: Start your analysis with any necessary equations. Develop your analysis as completely as possible before inserting values and performing the calculations. Draw a box around your answers and include units and follow an appropriate number of significant figures.
arrow_forward
Assignment 1: TIME VALUE OF MONEY
Objective: To further understand the concept of the time value of money.
INSTRUCTIONS:
In each problem,
a. Translate data given in problems into their respective graphical representations - i.e. draw
the correct cash flow diagram.
b. Write down all pertinent given information or data on your paper.
c. Calculate answers correctly.
3. A certain college graduate, Sallie Evans, has $24,000 in student-loan debt at the end of
her college career. The interest rate on this debt is 0.75% per month. If monthly payments
on this loan are $432.61, how many months will it take for Sallie to repay the entire loan?
arrow_forward
Follow the instructions carefully.
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
KOREK li.
Homework- 5.pdf
Assist. Prof. Dr. Hamed Al-Falalahi
Engineering Thermodynamics
2nd year / 1* Semester
Homework- 5
P.1 Find the work for an isochoric process?
P.2
An ideal gas is taken from the state P= 100, V=1 to the state P=4, V=5 by two
different quasi-static processes. The units are arbitrary. Process (a) is described by
the equation;
P= 100/V... (1)
While the process (b) is described within our range of the variables, by the
equation;
P= 124-24... (2)
The two processes are shown on a P-V diagram in Fig below. What is the work
done per mole in each processes?
AL Kitab University
Petroleum Engineering Department
arrow_forward
On this engineering problem, I need help with parts b) and c). Also, this is the complete problem and not a writing assignment. Make sure for this problem you list the following:
a. Known: State briefly what is known about the problem.
b. Schematic: Draw a schematic of the physical system or control volume.
c. Assumptions: List all necessary assumptions used to complete the problem.
d. Properties: Identify the source of property values not given to you in the problem.
e. Find: State what must be found.
f. Analysis: Start your analysis with any necessary equations. Develop your analysis as completely as possible before inserting values and performing the calculations. Draw a box around your answers and include units and follow an appropriate number of significant figures.
arrow_forward
Please recheck and provide clear and complete step-by-step solution in scanned handwriting or computerized output thank you
arrow_forward
Help!!! Answer all parts correctly!! Please
arrow_forward
A manufacturing system consists of 3 machines. Parts arrive following EXPO(5) distribution. Upon arrival, the parts will be send to
the shops where they will be processed, each part will be transported individually (assume the parts move by themselves without
the need of a resource) and the move time takes UNIF(2, 3) minutes. Once the parts arrive at the shop station the parts are
distributed among the machines by selecting the machine with the shortest queue, if there are ties, then the tie breaker is the
machine index (Machine 3 is prioritized over machine 2, and 1, and machine 2 is prioritized over machine 1). There is no maximum
buffer capacity to be considered. Processing time for each machine is constant and is equal to 7 minutes. All three machines have
failure modes; the machines have up times and down time as following: Machine 1 Up Time expo(140) min, Down Time UNIF(S, 10)
min, Machine 2 up time EXPO(100) min and down time UNIF(S, 15) + 5 min while for machine 3 up time…
arrow_forward
1) During a particular manufacturing process a hoop of mass m and radius r is to roll without
slip on a slant before getting to the next step in the assembly line. The floor manager has
approached you and wants to know what the minimum coefficient of friction would have to
be to prevent the hoop from slipping.
a) Explicitly define coordinates for the inclined plane and write out the corresponding
transformation array.
b) Draw an FBD and IRD for the system.
c) Compute the coefficient of friction required to ensure the hoop does not slip if B = 45°.
[Ans. to Check: µ = 0.5]
m
arrow_forward
4. Documents business requirements use-case narratives.for only one process
note: please i want Documents like this in pic
arrow_forward
Thank you so much!
arrow_forward
I need unique and correct answer. Don't try to copy from anywhere. Do not give answer in image formet and hand writing
arrow_forward
A certain system contains three branches in parallel. One branch contains units A and B in series. A second
branch contains units C and D in series. The third branch contains unit E alone. These non-identical units have
constant hazard rates in order of their unit number of 0.1/year, 0.15/year, 0.2/year, 0.15/year, and 0.25/year.
a) Draw a block diagram and compute the reliability of the system from the reliabilities of the individual units.
b) Draw a signal flow graph.
c) Identify the cut sets and the minimal cut sets.
d) Find reliability of the system.
e) Find the mean time to failure
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
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
Assignment 1: TIME VALUE OF MONEY
Objective: To further understand the concept of the time value of money.
INSTRUCTIONS:
In cach problem,
a. Translate data given in problems into their respective graphical representations - i.e. draw
the correct cash flow diagram.
b. Write down all pertinent given information or data on your paper.
c. Calculate answers correctly.
1. Your spendthrift cousin wants to buy a fancy watch for $425. Instead, you suggest that
she buy an inexpensive watch for $25 and save the difference of $400. Your cousin
agrees with your idea and invests $400 for 40 years in an account earning 9% interest per
year. How much will she accumulate in this account after 40 years have passed?
arrow_forward
I need a clear answer by hand, not by keyboard and fast answer within 20 minutes. Thank you | dybala
arrow_forward
FINALS ASSIGNMENT IN ME 3215
COMBUSTION ENGINEERING
PROBLEM 1:
A Diesel engine overcome a friction of 200 HP and delivers 1000 BHP. Air consumption is 90 kg per minute.
The Air/fuel ratio is 15 to 1. Find the following:
1. Indicated horsepower
2. The Mechanical efficiency
3. The Brake Specific Fuel Consumption
PROBLEM 2:
The brake thermal efficiency of a diesel engine is 30 percent. If the air to fuel ratio by weight is 20 and the
calorific value of the fuel used is 41800 kJ/kg, what brake mean effective pressure may be expected at
S.P. conditions (Standard Temperature and pressure means 15.6°C and 101.325 kPa, respectively)?
arrow_forward
Solve correctly
arrow_forward
The annual demand for an item is 10,000 units.
The unit cost is Rs. 100 and inventory carrying
charges are 14.4% of the unit cost per annum.
The cost of one procurement is Rs. 2000. the
time between two consecutive orders to meet
the above demand is
_month(s).
arrow_forward
C)If both cyclists have 170 mm cranks on their bikes, what will be the mechanical advantage (considering only the movement of the feet with a constant force for walking and riding), in percent, that each rider will have achieved over walking the same distance? (This can
be found by dividing the distance wallked by the distance the feet move in riding.)
arrow_forward
Task 4
.
Investigate the effect of varying mass flow rate ( m in kg/s) of the cooling water on heat input to the compressor and heat removed by the cooling water.
In order to solve this task, you have to assume different mass flow rates to investigate the relationship between mass flow rate, heat input to the compressor, and heat removed by the cooling water, you can use Matlab or EES and present your results in a graph form.
arrow_forward
11)
arrow_forward
subject (dynamics)
pls show me full steps with clear handwriting
pls send me in 30 mins
thank you sir
arrow_forward
6) just solve C-D
Please answer in legible and orderly handwriting. If it is not legible, I will not give a positive rating.
arrow_forward
Please explain
arrow_forward
Question 2 (35 marks):
A company has a project to complete. To complete the project, the following activities
should be done. Draw the Project Diagram/Network (15 pts) of this project and develop
a Linear Program (20 pts) for computing a critical path (NO NEED TO SOLVE IT).
Duration
Activity
Predecessors
(months)
4
A
3
B
C
D
A
2
6
W
E
B, D
S
F
E, C
7
1
G
E
alt
H
F, G
4
arrow_forward
ADAMSON UNIVERSITY
College of Engineering
Civil Engineering Department
Answer Sheet
Name:
Date:
Course:
Time:
4m
4m
100 t
200 kat
arrow_forward
O Web C x
k GECO0 X
O Course X
O Assign X
O Web C x
k MATHO X
Assign X
O Discus: X
O Quizze
O Syllabu x
O Grade: x
om/courses/31937/assignments/1001318?module_item_id=2616268
tructions:
ollow the prescribed format by the course policy
pu have 48 hours to answer and submit the solution.
olve the problem with complete and detailed solution.
7x+14]
-x
1.
What value of x satisfies the matrix equation
(2 points)
3x-2
x+8
2.
Solve for x and y in the matrix equation below:
3 -4
y
x-y 4
2] [10
-1]
3 -1]
%3D
(3 Points)
-1
[2 -3]
x -8
2
6х -9
-3 3х
|1 -2
2
and
the matrix 3(A +2B) is equal to? (3 points)
3.
For matrices A=| 0
%3D
7 -2
3 -1
[2 -3
The matrix product
2 4 ?(2 points)
4.
0 1
1
4,
arrow_forward
Question 3
a) The details of travel time and capacity of different links in a portion of a city
road network is as given in Table 1. Assign a traffic volume of 15,000 pcu per hr
from node A to node I by multiple route assignment technique.
Table 1: Travel time and capacity
Link
Travel time in minutes
Practical capacity in
pcu/hr
A-B
6000
A-C
5000
A-D
5000
B-F
6000
C-E
5000
D-G
5000
E-H
5000
F-I
6000
G-H
5000
H-I
10000
wwNN
2
2
3
3
3
2
N33 N
2
2
arrow_forward
Do not give answer in image and hand writing
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
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
- I need help with parts b and c (see images). This is the complete question and not a writing assignment. Make sure for this problem you list the following: a. Known: State briefly what is known about the problem. b. Schematic: Draw a schematic of the physical system or control volume. c. Assumptions: List all necessary assumptions used to complete the problem. d. Properties: Identify the source of property values not given to you in the problem. e. Find: State what must be found. f. Analysis: Start your analysis with any necessary equations. Develop your analysis as completely as possible before inserting values and performing the calculations. Draw a box around your answers and include units and follow an appropriate number of significant figures.arrow_forwardAssignment 1: TIME VALUE OF MONEY Objective: To further understand the concept of the time value of money. INSTRUCTIONS: In each problem, a. Translate data given in problems into their respective graphical representations - i.e. draw the correct cash flow diagram. b. Write down all pertinent given information or data on your paper. c. Calculate answers correctly. 3. A certain college graduate, Sallie Evans, has $24,000 in student-loan debt at the end of her college career. The interest rate on this debt is 0.75% per month. If monthly payments on this loan are $432.61, how many months will it take for Sallie to repay the entire loan?arrow_forwardFollow the instructions carefully.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_forwardKOREK li. Homework- 5.pdf Assist. Prof. Dr. Hamed Al-Falalahi Engineering Thermodynamics 2nd year / 1* Semester Homework- 5 P.1 Find the work for an isochoric process? P.2 An ideal gas is taken from the state P= 100, V=1 to the state P=4, V=5 by two different quasi-static processes. The units are arbitrary. Process (a) is described by the equation; P= 100/V... (1) While the process (b) is described within our range of the variables, by the equation; P= 124-24... (2) The two processes are shown on a P-V diagram in Fig below. What is the work done per mole in each processes? AL Kitab University Petroleum Engineering Departmentarrow_forwardOn this engineering problem, I need help with parts b) and c). Also, this is the complete problem and not a writing assignment. Make sure for this problem you list the following: a. Known: State briefly what is known about the problem. b. Schematic: Draw a schematic of the physical system or control volume. c. Assumptions: List all necessary assumptions used to complete the problem. d. Properties: Identify the source of property values not given to you in the problem. e. Find: State what must be found. f. Analysis: Start your analysis with any necessary equations. Develop your analysis as completely as possible before inserting values and performing the calculations. Draw a box around your answers and include units and follow an appropriate number of significant figures.arrow_forward
- Please recheck and provide clear and complete step-by-step solution in scanned handwriting or computerized output thank youarrow_forwardHelp!!! Answer all parts correctly!! Pleasearrow_forwardA manufacturing system consists of 3 machines. Parts arrive following EXPO(5) distribution. Upon arrival, the parts will be send to the shops where they will be processed, each part will be transported individually (assume the parts move by themselves without the need of a resource) and the move time takes UNIF(2, 3) minutes. Once the parts arrive at the shop station the parts are distributed among the machines by selecting the machine with the shortest queue, if there are ties, then the tie breaker is the machine index (Machine 3 is prioritized over machine 2, and 1, and machine 2 is prioritized over machine 1). There is no maximum buffer capacity to be considered. Processing time for each machine is constant and is equal to 7 minutes. All three machines have failure modes; the machines have up times and down time as following: Machine 1 Up Time expo(140) min, Down Time UNIF(S, 10) min, Machine 2 up time EXPO(100) min and down time UNIF(S, 15) + 5 min while for machine 3 up time…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