Bbin texting is five times this level.

1. Create a stored procedure p_kh with input parameters and output, and return the course number of the course taught by the specified teacher (as output parameter) (as input parameter).

2. Create and execute the stored procedure p_cj3 with input and output parameters, and query the course name and grade (output parameters) of the course selected by the students with the specified student number (input parameters). After calling the stored procedure, it will display "the course selected with XX student number is named XX and the grade is XX".

3. Check p_xsqk, p_kh and p_cj3 respectively.

4. Create 1 triggers named tr_insert_cj on xs_kc table in xscj library. When inserting xs_kc table, the triggers will be triggered, and the prompt message "xs_kc table inserts new score!" .

5. Create a 1 trigger named TR _ DELETE _ xsqk on the xsqk table in the xscj library. When the row with the specified student number is to be deleted, the trigger is triggered to cancel the deletion operation, and the prompt message "The information in the XSQK table cannot be deleted!" .

6. Create a trigger named TR _ UPDATE _ xs_kc on the XS _ KC table, which is used to detect whether the "Grade" column of the table has been updated, and display its student number, course number, original grade and new grade after the update.

7. delete the tr_insert_cj trigger.