Here, attribute dept name is primary key in the department table and foreign key in the instructor table.
Insertion constraint on the foreign key is that any value A which is not in the department table and we try to insert it in the instructor table, then it is a violation of the foreign key constraint.
Example:
INSERT INTO instructor VALUES(100000,'John', 'English' , 40000);
It will gives error as it is the insertion violation of foreign key ,since there is no dept name as English in the department table.
Deletion constraint is when we try to delete from the department table and same value is present in the instructor table.
DELETE FROM department WHERE dept name = 'Biology' ;
It will give error since dept name biology exists in the instructor table , so it cant be delete from the department table
learn more about foreign key constraint here :
https://brainly.com/question/28139689
#SPJ4
