Capacity Management of University Classes
Write a program to create a trigger to reduce the capacity of the class in the classroom table if the new record is added to the Student table.
The Student table has the following fields:
• Student code
• Name
• Class code
The Classroom table also contains the following fields:
• Class code
• Class capacity