Based on the scenario below and draw class diagrams and sequence digrams for each use case mentioned below. Until now, the College F 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 inreal-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 information Manage IT device location information Manage janitor allocation information Various information retrieval functionalitiesIn the Manage room information process, the College F wants to manage rooms in the 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 theroom, and the room number information should be managed. If you think that moreinformation is required for the rooms, you may add as you want. In the Manage IT device location information process, COB 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, COB 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 thereplacement. 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, COB wants to manage the janitor allocation information for daily cleaning. After the last class of each day, janitors clean the rooms in Colleg F. 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 detailedinformation should be managed by the system. In Various information retrieval functionalities, the managers in COB 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 below and draw class diagrams and sequence digrams for each use case mentioned below. Until now, the College F 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 inreal-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 information Manage IT device location information Manage janitor allocation information Various information retrieval functionalitiesIn the Manage room information process, the College F wants to manage rooms in the 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 theroom, and the room number information should be managed. If you think that moreinformation is required for the rooms, you may add as you want. In the Manage IT device location information process, COB 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, COB 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 thereplacement. 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, COB wants to manage the janitor allocation information for daily cleaning. After the last class of each day, janitors clean the rooms in Colleg F. 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 detailedinformation should be managed by the system. In Various information retrieval functionalities, the managers in COB 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.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter9: Database Design

Section: Chapter Questions

Problem 6P

See similar textbooks

Related questions

Question

Based on the scenario below and draw class diagrams and sequence digrams for each use case mentioned below.

Until now, the College F 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 inreal-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 College F wants to manage rooms in the 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 theroom, 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, COB 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, COB 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, COB wants to manage the janitor allocation information for daily cleaning. After the last class of each day, janitors clean the rooms in Colleg F. 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 COB 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.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 1 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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.