Page 1 of 1
(3) Create a trigger for the Grade table: When the student's course selection changes, that is, when the course number i
Posted: Fri May 20, 2022 11:29 am
by answerhappygod
- 3 Create A Trigger For The Grade Table When The Student S Course Selection Changes That Is When The Course Number I 1 (45.19 KiB) Viewed 74 times
(3) Create a trigger for the Grade table: When the student's course selection changes, that is, when the course number in the Grade table is modified or a newly course selection record is added, it is required to keep the number of students taking each course no more than 4. If exceeded, the student is denied the course and appropriate prompts are given.“ (4) Create a trigger for the Grade table: At the end of the semester, when the teacher modifies the grade gmark in the Grade table, find out the number of students who fail courses greater than or equal to 2 courses and the number of courses that the student failed.