Dealing with Referential Integrity

• 4 Approaches
• Add Cleanup to Application Software
• Nightly Maintenance Process
• Enforce SQL rules not to cut corners
• The Foreign Key Approach – Have the DBMS automatically delete Marooned Rows from Tables