To prepare for this question, first create new table in the ischool_v2 database called new_person_records . The
Question:
For this question, develop a trigger that will execute when a new record is added into the people table, and will add to the new_person_records table a new row with the following values:
An auto-incremented ID value into the new_person_record_id column;
A text message value, "You have added a new person, , who is affiliated
with in the ." Into the new_person_record_text column;
The value of the date and time of the record insertion into the new_person_record_timestamp
column.
Use Q2_Partial_Code.sql script for this question.
For this question, please create stored function called get_person_pronouns. This function expects two arguments that represent the first name and last name of a person that is present in the people table. The function will return the pronouns of the person (type VARCHAR) - "he/him", "she/her", "they/them", etc.
Intermediate Accounting
ISBN: 978-1260481952
10th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson, Wayne Thomas