Design a trigger that complements the trigger MaintainCoursesNonEmpty by precluding the insertion of tuples into the relation Teaching when there are no corresponding tuples in the Transcript relation.
What will be an ideal response?
```
CREATE TRIGGER PrecludeIdleTeaching
BEFORE INSERT OF CrsCode, Semester ON Teaching
REFERENCING OLD AS O
FOR EACH ROW
WHEN (NOT EXISTS (
SELECT *
FROM Transcript
WHERE Semester = O.Semester AND
CrsCode = O.CrsCode ) )
ROLLBACK
```
You might also like to view...
If a label is too long to fit into a cell and the next cell is empty, _____.
A. it extends into the next cell on the right B. it extends into the previous cell on the left C. the end of the label is cut off D. it automatically moves to the next line
A one-way __________ mechanism can provide better password security with very little extra effort.
a. compression b. SSL c. hashing d. biometric
One purpose of a database is to store data so that information can be obtained easily by asking questions
Indicate whether the statement is true or false
Outlook supports several ways for you to view your contact list.
Answer the following statement true (T) or false (F)