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...
Viewing document dimensions in the Info panel is faster than relying on the Image Size dialog box.
Answer the following statement true (T) or false (F)
If a VBA error occurs while Access is running a procedure, you are offered the choice of ending the procedure or entering debugging mode. Choosing to end the procedure opens the Visual Basic Editor with the incorrect line of code highlighted in yellow
Indicate whether the statement is true or false
If you have an address field listing the city, state, and ZIP together such as Paterson, NJ 07501, you have violated the first normal form.
Answer the following statement true (T) or false (F)
When a program contains multiple ____ blocks, they are examined in sequence until a match is found for the type of exception that occurred.
A. throw B. finally C. catch D. try