when the user deletes a record in the master table all the corresponding records in the detail table along with the records in the master table will be deleted.
ON DELETE CASCADE option permits deletions of referenced key values in the parent table and automatically deletes dependent rows in the child table to maintain referential integrity.
