De?ne the trigger WatchCourseHistory that uses a table Log to record all changes that transactions make to the various courses in the Course relation.
What will be an ideal response?
```
CREATE TRIGGER WatchCourseHistory
AFTER UPDATE, DELETE, INSERT ON Course
REFERENCING OLD TABLE AS OldT
NEW TABLE AS NewT
FOR EACH STATEMENT
BEGIN
INSERT INTO Log
SELECT CURRENT_DATE, ’OLD’, * FROM OldT;
INSERT INTO Log
SELECT CURRENT_DATE, ’NEW’, * FROM NewT
END
```
You might also like to view...
By selecting the appropriate template, you can use a(n) ________ placeholder for additional information to explain or support a picture or idea
A) caption B) footer C) section header D) title and content
In a(n) ____________________ layout, the column widths don't change when the browser window changes size.
Fill in the blank(s) with the appropriate word(s).