3. Add, Edit and Delete in Database

3.6. Room

In this subchapter, we will learn on how to AddEdit and Delete Room in Room Management.


1. Add Room


To add room in Room Management, there are 3 simple steps.

STEPS 1: To Add new room, click on the icon Add Room


STEPS 2: Once you have clicked the icon, a pop up will appear.

Diagram 3.2.1 Add Room Popup


To fill in the details, refer to the table below.

 Room Name

Short name of the room. Room code cannot be duplicated and compulsory.            
Example: CS LAB

 Room Code

Long name of the room. It is compulsory.
Example: COMPUTER SCIENCE LAB

 Room Capacity

The number of student that a room can accommodate based on its size. 

 Room Type

Type of room. It is compulsory.
Example: APPLE MAC STUDIO

 Room Group

Building of the room. It is non-compulsory.
 Example: BILIK SIMULASI

Table 3.6.1 Room Details Explanation


Below is the example how it will look like after filling the form. 


Diagram 3.6.2 Filled room details


STEPS 3: Click Ok once finished. 

To search for the room that has been added, simply click CTRL + F and search your preferred room.


Diagram 3.6.3 Search the Room


2. Edit Room


To edit room in Room Management, there are 4 simple steps.

STEPS 1: To edit room, you can simply choose the room that you want to edit and click Edit Room Icon  OR double click the selected room.


Diagram 3.6.4 Editable Fields


STEPS 3: Edit the Room Details. For Example, we change capacity to 50.


Diagram 3.6.5 Changed Room Capacity


STEPS 4: Click Ok once done. Below is how it would look like once changed.


Diagram 3.6.6 Updated Room Details


3. Delete Room


To delete, you can simply refer to the picture below.



Diagram 3.6.7 Steps on How to Delete Room