1. (25 pts.) Write the SQL statements to create a view that will display course names by section. 2. (75 pts.) Create a PL/SQL procedure which accepts a course code (ccode) and display the corresponding corse name and credit from COURSE table. (40 pts.) - The procedure accepts a course code. (5 pts.) - If the course code exists, the procedure display course informations. (10pts.) - If the course code does not exist, the procedure handles the exception and prints a descriptive text, (10pts) - Write a simple anonymous block with the procedure call to testit. (10pts.) Note1: PK Primary Key FX Foreign Key NN Not Null Note2: You can find sample data on the back of the page