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.

I've done that google thing and this is what I've found:
MySQL :: MySQL 5.0 Reference Manual :: 12.1.11 CREATE TRIGGER Syntax
Create the First Trigger in MySQL