I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test  your trigger COMPLETELY for every event it is defined.  (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging).  This should work both for new rows and existing rows that are updated.  Scenerio:  All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.

//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();…

Task 1: The InstantRide received some traffic violation tickets from the government. The Legal team of InstantRide requires the travel information of the respective drivers along with corresponding Driving License IDs to proceed further. In addition, the team wants to include the drivers without travel information in the system yet for the completion of driver list. Therefore, you need to return DRIVER_FIRST_NAME, DRIVER_LAST_NAME, DRIVER_DRIVING_LICENSE_ID, TRAVEL_START_TIME, TRAVEL_END_TIME information from the DRIVERS and TRAVELS data connected by LEFT JOIN. Task: Query all drivers with and without travel data. (SQL Database Test)

Use Visual Studio to create a database named Personnel.mdf. The database should have a table named Employee, with columns for employee ID, name, position, and hourly pay rate. The employee ID should be the primary key. Insert at least five sample rows of data into the Employee table. Create an application that displays the Employee table in a DataGridView control.