3. Add, Edit and Delete in Database

3.2. Lecturer


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

1. Add Lecturer

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


STEPS 1: To create new lecturer, click on the icon Create New Lecturer. 


STEPS 2: Once you have clicked the icon, select the new lecturer that appearing on left side.


Diagram 3.2.1 New Lecturer


You will be able to see the Lecturer details on right side. 

Diagram 3.2.2 Lecturer Details

STEPS 3: To fill in, refer to the table below

Lecture Name

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

Example : ALIA

Long Name

Long Name of the lecturer. Long Name is compulsory.

Example : ALIA MAISARAH BINTI KAMARUL

Maximum Load

Maximum number of courses teaches. Maximum Load is non-compulsory.

ID Number

Lecturer’s ID Number. ID Number is non-compulsory.

Example : 4544

Auto Assign

“Yes” to auto assigned the course & “No” to not auto assigned the course. Auto Assign is non-compulsory.

Department

The Department of the lecturer. Department is non-compulsory.

Example : FSKM

Note

The notes under the lecturer that is non-related to the database. Note is non-compulsory.

Example : In charge of basketball club

Table 3.2.1 Lecturer Details Explanation


 Diagram 3.2.3 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. Noted that there is No Save Button. You may close it and it will be automatically added into the Lecturer Management.



 Diagram 3.2.4 Filled Lecturer Details


Note that new lecturer you created will automatically appear at the bottom list of lecturers. When you reopening the Lecturer Management, the lecturer can be found in the list of lecturers according to alphabetical order.


 Diagram 3.2.5 Location of the new lecturer before and after you fill up the details


You have created your first lecturer! 


Optional: Organize your courses into respective folder (Non-Compulsory)


Once you have multiple lecturers, you may want to organize them into folders. For example, folder is organized by lecturer's faculty. 

Press the New Folder  icon.


Diagram 3.2.6 New Lecturer Folder

Note that new folder you created will also automatically appear at the bottom list of folder. When you reopening the Lecturer Management, the folder can be found in the list according to alphabetical order.


You can rename the Folder in the Group Name. For example, rename as CSMATH.


Diagram 3.2.7 Filled lecturer folder details


Select your desired lecturer.     


Diagram 3.2.8 Selected desired lecturer


Drag it to the folder and drop.


Diagram 3.2.9 Lecturer dragged inside the folder

2. Edit Lecturer

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


STEPS 1: To edit lecturer, you may open the Lecturer Management. 

STEPS 2: Choose the lecturer that you want to edit.


Diagram 3.2.10 Editable Fields


STEPS 3: Edit the Lecturer information. For Example, changing note to "In charge of Human Resource Department". Refer to the picture below.


Diagram 3.2.11 Note Added to Lecturer's Details


STEPS 4: All done. You can simply close it as it is automatically updated inside Lecturer Management

3. Delete Lecturer

There are 2 ways of delete the lecturer. You can delete a lecturer/folder OR you can delete All lecturers.


ALTERNATIVE 1:To delete, select the lecturer or the folder that you want to delete.

Diagram 3.2.12 Selected Lecturer


Click the Delete Folder or Lecturer icon . 

After that, it will pop-up confirmation window on deleting the folder/group or the lecturer. click Yes to proceed. 


      

Diagram 3.2.13 Delete Group and Lecturer Pop-up


     

ALTERNATIVE 2: To Delete All, select the Delete All icon .

Confirmation window will pop-up and click Yes to proceed. 


         

Diagram 3.2.14 Delete All Lecturer Pop-up