Create a trigger UPDATE_ON_TA on TA. After updating a row on TA, your designed trigger will insert current date and time in DATE format, ID(Before update), Semester(Before Update), Action(UPDATE) on daten table. Daten table has four columns, ID(int), Semester(int), Action(Varchar[13]) and DateofUpdate(DATE).

Include the SQL query of creating Daten table also in your text file.

Schema: TA (ID, Name, Semester, GPA) English: There is a TA (Teaching Assistant) with ID, Name, Semester (represents in which semester he/she currently in), GPA (Current GPA) TA_INFO (ID, Position) English: TA_INFO represents the position of TA (UGA = Undergraduate Teaching Assistant, GA = GRADUATE Teaching Assistant). Each TA is identified by ID. Friend (ID1, ID2) English: The TA with ID1 is friends with the TA with ID2. Friendship is mutual, so if (123,456) is in the Friend table, so is (456, 123). REVIEW_TA (ID1, ID2) English: The TA with ID1 reviews a TA with ID2. Reviewing someone is not nece ecessarily mutual, so if (123, 456) is in the REVIEW_TA table, there is no guarantee that (456, 123) is also present