Until now, the Business College has managed manually the information for rooms and related works such as equipment allocation and janitor allocation status. However, the process was inefficient because the information is not updated in real-time and hard to manage the related information together. Hence, the university decided toadopt Room Management System. The basic business processes that should be included inRoom Management System are as below: Manage room informationManage IT device location informationManage janitor allocation information Various information retrieval functionalities In the Manage room information process, the Business College wants to manage rooms in the BC building. There  are various types of rooms such as suites (rooms in a large room), classrooms, labs, rest rooms, and faculty offices. They want to manage these types of rooms in the system. For each room, the square feet, the capacity of persons, the floor of the room, and the room number information should be managed. If you think that more information is required for the rooms, you may add as you want. In the Manage IT device location information process, BC wants to manage the location of all IT devices. The IT devices include the ones using IT technologies such as laptop computers, desktop computers, projectors, printers, etc. and each unit is identified by a unique stock number. As the devices are installed in various rooms, BC wants to manage the location of the devices. For example, desktops and laptops are in faculty/department offices and labs and the projectors are in labs and classrooms. When the devices are out of order, IT staffs will replace them with the new ones in the storage and move the broken devices back into the storage. Hence, you need to consider the new and broken devices kept in the storage. Also, these replacement job logs should be managed in the system. Each job log should include the IT staff who worked on the job, the date of the job, two replaced units, and the reason for the replacement. If you want, you may add more information. As the devices are managed by IT staffs, COB wants to manage the list and the details of each IT staff in the system. The IT staffsare identified by their ID number.   In the Manage janitor allocation information process, BC wants to manage the janitor allocation information for daily cleaning. After the last class of each day, janitors clean the rooms in BC When cleaning, janitors clean the rooms for which they are allocated. For example, the janitor #1 will clean the rooms #101, #103, and #105 and the janitors #2 and #3 will clean the rooms #201 and #202 together as allocated in the system. COB wants to manage this allocation information in real-time. Like IT staff information, a janitor list and their detailed information should be managed by the system. In Various information retrieval functionalities, the managers in BC want to retrieve the information using various search options (similar to searching players in the MLB website using various search options). Even if there’s no manipulation of information in this process, the Room Management System should provide various search options. For all the information, the users of the system should be able to create/read/update/delete the information in real-time.   Based on the scenario provided above, draw the following using UML Final version of Class DiagramPackage DiagramDatabase Design Data Access and Manipulation Design

Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter8: Enterprise Systems
Section: Chapter Questions
Problem 15SAT: Many multinational companies roll out standard IS applications for all to use. However, standard...
icon
Related questions
Topic Video
Question
Until now, the Business College has managed manually the information for rooms and related works such as equipment allocation and janitor allocation status. However, the process was inefficient because the information is not updated in real-time and hard to manage the related information together. Hence, the university decided to
adopt Room Management System. The basic business processes that should be included in
Room Management System are as below:

Manage room information
Manage IT device location information
Manage janitor allocation information
Various information retrieval functionalities

In the Manage room information process, the Business College wants to manage rooms in the BC building. There  are various types of rooms such as suites (rooms in a large room), classrooms, labs, rest rooms, and faculty offices. They want to manage these types of rooms in the system. For each room, the square feet, the capacity of persons, the floor of the room, and the room number information should be managed. If you think that more information is required for the rooms, you may add as you want. In the Manage IT device location information process, BC wants to manage the location of all IT devices. The IT devices include the ones using IT technologies such as laptop computers, desktop computers, projectors, printers, etc. and each unit is identified by a unique stock number. As the devices are installed in various rooms, BC wants to manage the location of the devices. For example, desktops and laptops are in faculty/department offices and labs and the projectors are in labs and classrooms. When the devices are out of order, IT staffs will replace them with the new ones in the storage and move the broken devices back into the storage. Hence, you need to consider the new and broken devices kept in the storage. Also, these replacement job logs should be managed in the system. Each job log should include the IT staff who worked on the job, the date of the job, two replaced units, and the reason for the replacement. If you want, you may add more information. As the devices are managed by IT staffs, COB wants to manage the list and the details of each IT staff in the system. The IT staffs
are identified by their ID number.

 
In the Manage janitor allocation information process, BC wants to manage the janitor allocation information for daily cleaning. After the last class of each day, janitors clean the rooms in BC When cleaning, janitors clean the rooms for which they are allocated. For example, the janitor #1 will clean the rooms #101, #103, and #105 and the janitors #2 and #3 will clean the rooms #201 and #202 together as allocated in the system. COB wants to manage this allocation information in real-time. Like IT staff information, a janitor list and their detailed information should be managed by the system. In Various information retrieval functionalities, the managers in BC want to retrieve the information using various search options (similar to searching players in the MLB website using various search options). Even if there’s no manipulation of information in this process, the Room Management System should provide various search options. For all the information, the users of the system should be able to create/read/update/delete the information in real-time.
 
Based on the scenario provided above, draw the following using UML
Final version of Class Diagram
Package Diagram
Database Design 
Data Access and Manipulation Design
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Instruction Format
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning