Ask Question
27 March, 00:40

Consider the foreign-key constraint from the 'dept name' attribute of 'instructor' to the 'department' relation. Give examples of inserts and deletes to these relations that can cause a violation of the foreign-key constraint.

+5
Answers (1)
  1. 27 March, 01:13
    0
    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)
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Consider the foreign-key constraint from the 'dept name' attribute of 'instructor' to the 'department' relation. Give examples of inserts ...” in 📘 Computers and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers