Question:What are the benefits of using triggers?
Answer
Triggers have many benefits: a. Audit trails: Special logging table that lets us quickly tabulate and display the results to an impatient executive. b. Validation: We can use triggers to validate data before updating the database. c. Referential integrity enforcement: Table relationships remain stable throughout the lifetime of a project