Assignment 5

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)

Write a procedure that will accept a deptartment_id value and a gender value and total_std as parameters and

return the the total number of students with the given gender in that department.

The following conditions are to be treated as exceptions:

- Handle a relevant named exception by displaying a proper message

- If the gender parameter is not f or m. display "The value is invalid"

- Handle the deadlock exception with the code ORA-060 by displaying "deadlock detected"