Creating a Course

Actors: Instructor (INSTRUCTOR)

1. Course Creation.

INSERT INTO course (name, price, status, instructor_id)
VALUES (:name, :price, 'ACTIVE', :instructorId);

2. Assigning Categories to the Course.

INSERT INTO course_category (course_id, category_id)
VALUES (:courseId, :categoryId);