Please answer the question properly - using my SQL developer -Procedures.

Q4. Create a Bonus_transaction table with (Today_date, Description, worker_id, bons_amoun, bonus_date)

SQL CODES FOR WOKER & BONUS TABEL :

CREATE TABLE Worker ( WORKER_ID INT PRIMARY KEY, FIRST_NAME VARCHAR(25), LAST_NAME VARCHAR(25), SALARY INT, JOINING_DATE DATE, DEPARTMENT VARCHAR(25) ); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (001, 'Monika', 'Arora', 100000, TO_DATE('14-02-20','yy-mm-dd'), 'HR'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (002, 'Niharika', 'Verma', 80000, tO_DATE('14-06-11','yy-mm-dd'), 'Admin'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (003, 'Vishal', 'Singhal', 300000, TO_DATE('14-02-20','yy-mm-dd'), 'HR'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (004, 'Amitabh', 'Singh', 500000, TO_DATE('14-02-20','yy-mm-dd'), 'Admin'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (005, 'Vivek', 'Bhati', 500000, TO_DATE('14-06-11','yy-mm-dd'), 'Admin'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (006, 'Vipul', 'Diwan', 200000, TO_DATE('14-06-11','yy-MM-dd'), 'Account'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (007, 'Satish', 'Kumar', 75000, TO_DATE('14-01-20','yy-MM-dd'), 'Account'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (008, 'Geetika', 'Chauhan', 90000, TO_DATE('14-04-11','yy-MM-dd'), 'Admin'); INSERT INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES (009, 'Monika', 'Arora', 100000, TO_DATE('14-02-20','yy-mm-dd'), 'HR'); CREATE TABLE Bonus ( WORKER_REF_ID INT, BONUS_AMOUNT INT, BONUS_DATE DATE, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker(WORKER_ID) ON DELETE CASCADE ); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (001, 5000, TO_DATE('16-02-20','yy-MM-dd')); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (002, 3000, TO_DATE('16-06-11','yy-MM-dd')); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (003, 4000, TO_DATE('16-02-20','yy-MM-dd')); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (004, 4500, TO_DATE('16-02-20','yy-MM-dd')); INSERT INTO Bonus (WORKER_REF_ID, BONUS_AMOUNT, BONUS_DATE) VALUES (005, 3500, TO_DATE('16-06-11','yy-MM-dd')); SELECT * FROM WORKER; SELECT * FROM BONUS;

Answer question 3 must > please provide the right answer with a screenshot. Dont right wrong command codes. URgent require .Thanks

please add a few more records in bonus table to have this output Q3. Write a trigger that should run when you try to add a bonus in the bonus table. The trigger will check if the worker has got the bonus before. Depending upon the past bonus amounts, it should display the message as : Congratulations of your first bonus (if it's the first time) OR Wow! You got the biggest bonus till yet (if the past bonus were less than todays) Or Enjoy the bonus!!! (else)