The following "Courses ERD" represents courses and sections as offered at UNB. This ERD

applies to Questions $2$ to $7.$

UNB offers courses in a wide variety of subject areas, including the subject area codes CS$,$

MATH, and ENGL, just to name a few. Those three codes represent the subject areas named

Computer Science, Mathematics, and English, respectively.

Each course in UNB's Undergraduate Calendar is in exactly one subject area and has a course

title $($e$.$g$.$ 'Introduction to Databases'$).$

A section is an offering of a course that takes place during a specific academic term, such as

Winter $2022($repWrite a SQL stored procedure called adjustCapacity that takes as input:

$$ A section id

$$ The desired capacity for that section

The procedure should update the capacity for the specified section. If there is an invalid section

id$,$ the procedure should generate an exception with a custom error code of $45001$ and a

message of $$Invalid Section Id$.$

Use the space provided below to write the adjustCapacity stored procedure.resented in this database by the code $\text{'}$W$2022\text{'}).$

$6.$ Write a SQL stored procedure called adjustCapacity that takes as input:

$$ A section id

$$ The desired capacity for that section

The procedure should update the capacity for the specified section. If there is an invalid section id$,$ the procedure should generate an exception with a custom error code of $45001$ and a

message of $$Invalid Section Id$.$

Use the space provided below to write the adjustCapacity stored procedure.