English Question: Display the Student name, Course Name, Semester and Section and grade for the student with this .

Write a procedure COURSES_BY_STUDENT (bannerId VARCHAR(3)). When executed it displays Student name, Course Name, Semester and Section and grade for the student with this bannerId. Test your procedure by executing these calls.

CALL COURSES_BY_STUDENT ("103");

CALL COURSES_BY_STUDENT ("106");

CALL COURSES_BY_STUDENT ("109");

Tables are bellow:

Student Table

Department Table

Professor Table

Course Table

Teaching_Assignment Table:

Transcript Table:

Banner Id 100 101 102 103 104 105 106 107 108 109 110 Name Leona Jerald Freddie Shannon Billie Casey Nicole Alex Mona Anthony Thomas Curtis Addres Status Freshman Freshman Freshman Sophomore Sophomore Sophomore Junior Junior Junior Senior Senior Senior Banner Id 100 101 102 103 104 105 106 107 108 109 110 Name Leona Jerald Freddie Shannon Billie Casey Nicole Alex Mona Anthony Thomas Curtis Addres Status Freshman Freshman Freshman Sophomore Sophomore Sophomore Junior Junior Junior Senior Senior Senior