Assignment8
docx
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
ISM4212 – Assignment 8
e. Recommend the appropriate attribute hierarchies.
Classification
Semester
Major
Time
f. Implement your data warehouse design, using the star schema you created in Problem 1c
and the attributes you defined in Problem 1d.
g. Create the reports that will meet the requirements listed in this problem’s introduction.
-
STUDENT, TIME, and LAB:
total number of students on different times of the day/semester.
- STUDENT, MAJOR and TIME: used for the computer lab usages by major.
- MAJOR and STUDENT: used for comparison of majors with semesters.
3
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
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
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
show me working
arrow_forward
Please answer the 4th question
arrow_forward
Learning Goal:
To understand the concept of moment of a force and how to calculate it using a scalar
formulation.
The magnitude of the moment of a force with a magnitude F around a point O is defined
as follows:Mo = Fdwhere d is the force's moment arm. The moment arm is the
perpendicular distance from the axis at point O to the force's line of action.
Figure
F₁
1 of 2
Part A
A stool at a restaurant is anchored to the floor. When a customer is in the process of sitting down, a horizontal force with magnitude F₁ is exerted at the top of the stool support as shown in the figure. (Figure 1)
When the customer is seated, a vertical force with magnitude F2 is exerted on the stool support. If the maximum moment magnitude that the stool support can sustain about point A is M₁ = 140 lb-ft, what is the
maximum height do that the stool can have if the magnitudes of the two forces are F₁ = 65.0 lb and F₂ = 140 lb ? Assume that moments acting counterclockwise about point A are positive whereas…
arrow_forward
Example: Thesis Statement (1)
Check () the thesis statements that suggest a chronological order. Put a double
check (V) next to the thesis statements that suggest the essay will describe a
process or procedure. In the sentences you have checked, circle the word or
words that indicate chronological order or process.
к1. A child learns to handle responsibility in a series of small steps.
X2.
3.
WA.
5.
X6.
X7.
X8.
9.
A person's intelligence is the product of both heredity' and environment.
There are two main reasons I believe women in the army should not be allowed in a
war zone along with men.
The procedure for submitting expense reports has recently changed.
The tensions that led to last year's student riots had been developing for several years.
North American directness often conflicts with Asian modesty.
The two busiest travel days in the United States are the Wednesday before and the
Sunday after Thanksgiving.
Cultures celebrate the end of winter and the arrival of spring in…
arrow_forward
Develop the activity sequence model and determine the normal time for the following work activity:
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
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
Compute efficiency and Balance Delay
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
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
Please solve, engineering econ
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
As an engineer responsible for monitoring works in the area of mechanical systems, you must evaluate the following situation: a large client in the retail area has a refrigeration system where it stores some chilled or frozen products to be sold on the sales floor.Recently, the customer's maintenance department has been questioning the system's performance and requested an evaluation of the system's behavior. You went to the location and requested some information from the maintenance manager about the system, who provided the following data: - The system operates with R-134a refrigerant;- The refrigerated environment is maintained at 0°C and the external environment at 26°C;- The refrigerant flow rate in the system is 0.08 kg/s; In addition to the data provided, you carried out some tests and measured the temperature of the refrigerant fluid at some specific points in the system, such as the compressor inlet and condenser outlet, finding values of 0°C and 26°C respectively.…
arrow_forward
As an engineer responsible for monitoring works in the area of mechanical systems, you must evaluate the following situation: a large client in the retail area has a refrigeration system where it stores some chilled or frozen products to be sold on the sales floor.Recently, the customer's maintenance department has been questioning the system's performance and requested an evaluation of the system's behavior. You went to the location and requested some information from the maintenance manager about the system, who provided the following data: - The system operates with R-134a refrigerant;- The refrigerated environment is maintained at 0°C and the external environment at 26°C;- The refrigerant flow rate in the system is 0.08 kg/s; In addition to the data provided, you carried out some tests and measured the temperature of the refrigerant fluid at some specific points in the system, such as the compressor inlet and condenser outlet, finding values of 0°C and 26°C respectively.…
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
SEE MORE QUESTIONS
Recommended textbooks for you

Precision Machining Technology (MindTap Course Li...
Mechanical Engineering
ISBN:9781285444543
Author:Peter J. Hoffman, Eric S. Hopewell, Brian Janes
Publisher:Cengage Learning
Related Questions
- Help with this would be great, thanks!arrow_forwardProblem 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_forwardHelp 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_forwardshow me workingarrow_forwardPlease answer the 4th questionarrow_forward
- Learning Goal: To understand the concept of moment of a force and how to calculate it using a scalar formulation. The magnitude of the moment of a force with a magnitude F around a point O is defined as follows:Mo = Fdwhere d is the force's moment arm. The moment arm is the perpendicular distance from the axis at point O to the force's line of action. Figure F₁ 1 of 2 Part A A stool at a restaurant is anchored to the floor. When a customer is in the process of sitting down, a horizontal force with magnitude F₁ is exerted at the top of the stool support as shown in the figure. (Figure 1) When the customer is seated, a vertical force with magnitude F2 is exerted on the stool support. If the maximum moment magnitude that the stool support can sustain about point A is M₁ = 140 lb-ft, what is the maximum height do that the stool can have if the magnitudes of the two forces are F₁ = 65.0 lb and F₂ = 140 lb ? Assume that moments acting counterclockwise about point A are positive whereas…arrow_forwardExample: Thesis Statement (1) Check () the thesis statements that suggest a chronological order. Put a double check (V) next to the thesis statements that suggest the essay will describe a process or procedure. In the sentences you have checked, circle the word or words that indicate chronological order or process. к1. A child learns to handle responsibility in a series of small steps. X2. 3. WA. 5. X6. X7. X8. 9. A person's intelligence is the product of both heredity' and environment. There are two main reasons I believe women in the army should not be allowed in a war zone along with men. The procedure for submitting expense reports has recently changed. The tensions that led to last year's student riots had been developing for several years. North American directness often conflicts with Asian modesty. The two busiest travel days in the United States are the Wednesday before and the Sunday after Thanksgiving. Cultures celebrate the end of winter and the arrival of spring in…arrow_forwardDevelop the activity sequence model and determine the normal time for the following work activity: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_forward1) 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_forwardCompute efficiency and Balance Delayarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Precision Machining Technology (MindTap Course Li...Mechanical EngineeringISBN:9781285444543Author:Peter J. Hoffman, Eric S. Hopewell, Brian JanesPublisher:Cengage Learning

Precision Machining Technology (MindTap Course Li...
Mechanical Engineering
ISBN:9781285444543
Author:Peter J. Hoffman, Eric S. Hopewell, Brian Janes
Publisher:Cengage Learning