1) Write a PL/SQL program with cursors to print a report that includes the name of each major (indicated by dept_name), printed once, then a line for each student in that major that includes the student name and total credits. The report should be sorted by major.

2) Write a PL/SQL program to print a report of the student's name and which instructors he or she has had for classes. The output should be sorted by student name and should be nicely formatted.

takes course id grade section course id semester time slot uilding time slot id room no time slot id day start time end time classroom building room no teaches capacity L course id sec id semester Mean Course course id title dept name credits prereq student name dept name tot cred department building budget instructor name L dept name salary advisor sid i id