Foreign Key Constraints and Referential Actions

Database

Abstract

In this activity, students extend their knowledge of foreign keys and referential integrity to the SQL database level, seeing foreign key constraints and referential actions. Students observe how foreign key constraints enforce referential integrity, then see examples of the restrict, set null, and cascade referential actions. The activity closes with application questions on how business rules motivate the choice of referential actions.

This activity was developed with NSF support through IUSE-1626765. You may request access to this activity via the following link: IntroCS-POGIL Activity Writing Program. 

• Level: Undergraduate
• Setting: Classroom
• Activity Type: Learning Cycle
• Discipline: Computer Science
• Course: Database
• Keywords: foreign key, foreign key constraint, referential action, business rule, cascade