ON UPDATE CASCADE ensures data integrity.
The ON UPDATE CASCADE ensures data integrity. In relation, if one value is updated, then, in turn, there might be the requirement of updating the other linked data to it. This functionality is provided by the command ON UPDATE CASCADE. Option A, normalization, does not ensure integrity as it is the methodology to reduce redundancy from the relation. Similarly, option C is incorrect.
☛ Related Questions: