Package Diagram

Database Design

Data Access and Manipulation DiagramUntil 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