I was looking at database past exam from the school that I attend, and I have a question about ON DELETE and ON UPDATE.
The question in the past exam was:
Show the contents of the tables after the insturction
update Student set sid=1234 where sid=4563If
on delete cascadewas used on the reference from Enrollment to Student.
(Enrollment has an attribute referencing to the student relation)
on delete cascade was used, and if we were to update the student relation wouldn't this be rejected since it was
on delete cascade, not
on update cascade?