Answer:
Inserting a tuple:
(10111, Ostrom, Economics, 110,000)
into the instructor table, where the department table does not have the
department Economics, would violate the foreign key constraint.
• Deleting the tuple:
(Biology, Watson, 90000)
from the department table, where at least one student or instructor
tuple has dept name as Biology, would violate the foreign key constraint.
employee (person name, street, city)
works (person name, company name, salary)
company (company name, city)
Explanation:
