52
What happens during updates ?
•
SQL has three policies for maintaining
referential integrity:
•
Reject
violating modifications (default)
•
Cascade
: after a delete/update do a
delete/update
•
Set-null
set foreign-key field to NULL
•
•
READING ASSIGNEMNT: 7.1.5, 7.1.6