Question: pedepsmod This course Participants Question) Consider the foreign key constraint from the dept_name attribute of instructor to the department relation. Give one example of each

 pedepsmod This course Participants Question) Consider the foreign key constraint from

pedepsmod This course Participants Question) 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 depl_name Physics Finance History Comp. Sci. Elec. Eng Biology Comp. Sci. History Comp. Sci. Music Physics Finance salary 95000 90000 60000 75000 80000 72000 65000 62000 92000 40000 87000 80000 Tel. budget dept_name Comp. Sci. Biology Elec. Eng Music Finance History Physics building Taylor Watson Taylor Packard Painter Painter Watson 100000 90000 85000 80000 120000 50000 70000 (b) The department table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!