how to prevent delete if data available on another table

Hi everyone, In this tutorial will see how to prevent delete from a parent/master record if data exist on another or related table. For this example, I have used programme and course table to prevent deletion of data in programme table, if programme name is available on course table. In this case, I have map the one-to-many relationship between programme table and course table. Here is the DEMO