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 above and attachment provided, draw the following using an UML tool:

Final version of Class Diagram
Package Diagram
Database Design
Data Access and Manipulation Design

Transcribed Image Text:Package Diagram Item Initial version Final version Symbols Database Design Item Conversion Doc Format Symbols Sub Item Does the diagram group the classes reasonably? Are packages shown properly? Are relationships shown properly? Are packages shown properly? Are relationships shown properly? Are symbols appropriate? Sub Item Are tables converted correctly by the rules? Are the fields in tables converted correctly by the rules? Are the relationships among tables converted correctly by the rules? Are the cardinality between tables converted correctly by the rules? Are DB tables and classes provided in a diagram? Are symbols appropriate? Data Access and Manipulation Diagram Item Conversion Doc Format Symbols Sub Item Are DAM classes converted correctly by the rules? Do classes provide appropriate methods? Are DB tables, classes, and DAM classes provided in a diagram? Are symbols appropriate?

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 above and attachment provided, draw the following using an UML tool:

Final version of Class Diagram
Package Diagram
Database Design
Data Access and Manipulation Design

Package Diagram
Item
Initial version
Final version
Symbols
Database Design
Item
Conversion
Doc Format
Symbols
Sub Item
Does the diagram group the classes reasonably?
Are packages shown properly?
Are relationships shown properly?
Are packages shown properly?
Are relationships shown properly?
Are symbols appropriate?
Sub Item
Are tables converted correctly by the rules?
Are the fields in tables converted correctly by the rules?
Are the relationships among tables converted correctly by the rules?
Are the cardinality between tables converted correctly by the rules?
Are DB tables and classes provided in a diagram?
Are symbols appropriate?
Data Access and Manipulation Diagram
Item
Conversion
Doc Format
Symbols
Sub Item
Are DAM classes converted correctly by the rules?
Do classes provide appropriate methods?
Are DB tables, classes, and DAM classes provided in a diagram?
Are symbols appropriate?

Accepted Answer

To assist you effectively, I'd break down the tasks you outlined into different steps and provide…