3. Add, Edit and Delete in Database

3.1. Course


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


1. Add Course


To add course in Course Management, there are 3 simple steps.

STEPS 1: To Add new course, click on the icon Add Course


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


Diagram 3.1.1 Add Course Popup


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

 Course Code

Short name for the course. Course Code is compulsory and cannot be duplicated.

Example : CS221

 Course Name

Course Name of the Code. Course Name is compulsory.

Example : COMPUTER SCIENCE ALGORITHM

Default Size

Default number of class capacity.

 Default Duration

Default on how long the class will be held.

 ID Number

ID Number of the course.

 Department

Department of the course.

Table 3.1.1 Course Details Explanation


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

Diagram 3.1.2 Filled course details


STEPS 3: Click Ok once finished. 

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


Diagram 3.1.3 Search the Course


2. Edit Course


To edit course in Course Management, there are 4 simple steps.

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

Diagram 3.1.4 Editable Fields


STEPS 3: Edit the Course Details. For Example, we change the duration from 2 hours to 1 hours.


Diagram 3.1.5 Changed Duration of the Course


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


Diagram 3.1.6 Updated Course Details


3. Delete Course


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



Diagram 3.1.7 Steps on How to Delete Course