Stage 1: Database

3. Add, Edit and Delete in Database

3.3. Lecturer

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


1. Add Lecturer


To add lecturer in Lecturer Management, there are 3 simple steps.

STEPS 1: To Add new lecturer, click on the icon Add Lecturer


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

Diagram 3.3.1 Add Lecturer Popup


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

Lecturer Code

Short name of the lecturer. Lecture Code cannot be duplicated & it is compulsory.

Example : AIN SYUHADA

 Lecturer Name

Long Name of the lecturer.

Example : NUR AIN SYUHADA

 Maximum Load

Maximum Load of the lecturer.

 Minimum

Minimum Load of the lecturer.

 ID Number

ID Number of the lecturer.

 Department

Department of the Batch.

Table 3.3.1 Lecturer Details Explanation



Diagram 3.3.2 Teaching Courses


In the Lecturer Management, you will see Teaching Courses section. To add courses to the lecturer, select any available course and click the move to the right button and it will move the course to the right side. You can also do the same from the right side to the left side by pressing the move to the left button.


Moves to the right.

Moves all to the right.

Moves to the left.

Moves all to the left.


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


Diagram 3.3.3 Filled lecturer details


STEPS 3: Click Ok once finished. 

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


Diagram 3.3.4 Search the Lecturer


2. Edit Lecturer


To edit lecturer in Lecturer Management, there are 4 simple steps.

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


Diagram 3.3.5 Editable Fields


STEPS 3: Edit the Lecturer Details. For Example, we change ID Number from 309 to 930.


Diagram 3.3.6 Changed Lecturer ID Number


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


Diagram 3.3.7 Updated Lecturer Details


3. Delete Lecturer


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



Diagram 3.3.8 Steps on How to Delete Lecturer