
Cascade update
A cascade update is a rule used in database management that automatically updates related records when a primary record changes. For example, if a company's name is changed in the main record, any related records, like employee details linked to that company, will also be updated automatically. This ensures data consistency across the database without requiring manual updates to each connected record. It simplifies maintaining accurate relationships among data and reduces errors when information changes.