What does a foreign key do?
Student.dept_id is a foreign key referencing Department.dept_id.
Someone tries to insert a student with dept_id = 99, and no department 99 exists.
What happens?
Student.dept_id is a foreign key referencing Department.dept_id.
Someone tries to insert a student with dept_id = 99, and no department 99 exists.
What happens?