I have these questions for my assignment?
I have created tables and inserted data and everything but I am stuck with triggers.
a. Write a trigger to be executed on insert of PROPERTY to initialize date_of_insert and expiration_date to Sysdate.
b. Write a Procedure/trigger to be executed on insert, update of a PROPERTY Every property that gets entered gets checked against other properties of having the same: Agent(s), Owner(s), Location (City, State, Address), if you find one then update Property Status to “Double” as a duplicate
c. Write a trigger to be executed on update of a PROPERTY when the status field is changed from “NEW” to “APROVED” then update expiration date with today’s date (Sysdate) + 90 days.