Assignment 7

Write the solution in a Notepad or Word file and upload it.

Department(department_id, name, no_of_courses);

Student(std_id, name, cpga, gender, department_id, course_id)

Course(course_id, name, credits)

Write a trigger that is fired whenever a new course is created in order to increase the

course count of the corresponding department by 1.

In case of any exception display the oracle error message.