Question: Paragraph Styles Consider the foreign key constraint from the dept.name attribute of instructor to the department relation. Give one example of each of the following:

Paragraph Styles Consider the foreign key constraint from the dept.name attribute of instructor to the department relation. Give one example of each of the following: 1. insert into the instructor table which can cause a violation of the foreign key constraint. 2. delete from the department table, which can cause a violation of the foreign key constraint. ID name 22222 12121 32343 45565 98345 76766 10101 58583 83821 15151 33456 76543 Einstein Wu El Said Katz Kim Crick Srinivasan Califieri Brandt Mozart Gold Singh dept_name Physics Finance History Comp. Sci. Elec. Eng Biology Comp. Sci. salary 95000 90000 60000 75000 80000 72000 65000 62000 92000 40000 87000 80000 History Comp. Sci. Music Physics Finance (a) The instructor table dept_name Comp. Sci. Biology Elec. Eng Music Finance History Physics building Taylor Watson Taylor Packard Painter Painter Watson budget 100000 90000 85000 80000 120000 50000 70000 (b) The department table
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
