oblem create a (temporary) table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the temporary table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table, then the procedure makes sure the total number of courses taught in the temporary table is up-to-date. You must name your procedure:

I need help installing / understanding myphpadmin for mac and if i need to install wamp aswell. Also how to create a database from the code below

//stored procedure   create or replace procedure firstthree (my_seqid in varchar2) as cursor c1 is     select sname, grade from student s join taken t on s.sid=t.sid       where seqid=my_seqid       order by grade desc; -- my_sname varchar2(40); my_sname student.sname%TYPE; -- my_grade number(2,1); my_grade taken.grade%TYPE; begin /* clear the my_tmp table */ delete from my_tmp; commit;   open c1; for i in 1..3 loop     fetch c1 into my_sname, my_grade;     exit when c1%notfound; /* in case the number requested */                            /* is more than the total */                            /* number of enrolled students */     /* display the result */     dbms_output.put_line('name: ' || my_sname || ' ' || 'grade: ' || my_grade);     /* put into temporary table */     insert into my_tmp values(my_sname, my_grade);     commit; end loop; close c1; end; / -------------- //php <? $connection = oci_connect ("test", "test", "test"); if ($connection == false){    $e = oci_error();…

with it, paste your code in a text file named Student.txt and save it in your task folder. Write the SQL code to create a table called Student. The table structure is summarised in the table below (Note that STU_NUM is the primary key): STU_NUM Attribute Name STU_SNAME STU_FNAME STU_INITIAL STU_STARTDATE COURSE_CODE PROJ_NUM STU STU_S STU_F STU_INITIAL NUM NAME NAME 01 02 Snow John E CHAR(6) After you have created the table in question 1, write the SQL code to enter the first two rows of the table as below: Stark Arya с VARCHAR(15) VARCHAR(15) CHAR(1) DATE CHAR(3) INT(2) Data Type STU_STARTDATE COURSE_ PROJ_ CODE NUM 05-Apr-14 12-Jul-17 201 305 6 11 Assuming all the data in the Student table has been entered as shown below, write the SQL code that will list all attributes for a COURSE_CODE of 305.