You have normalized your database. Data exists just once. You need to delete data in a parent table (Customer) that has a relationship with another tables (Address). Which technique can change the data appropriately in both tables?

You have normalized your database. Data exists just once. You need to delete data in a parent table (Customer) that has a relationship with another tables (Address). Which technique can change the data appropriately in both tables?

You have normalized your database. Data exists just once. You need to delete data in a parent table (Customer) that has a relationship with another tables (Address). Which technique can change the data appropriately in both tables?


Answer – Use a DML trigger.

(Because the SQL language permits specifying only one table for an insert, update, or delete, the trigger was invented. Triggers fire automatically for any combination of these three actions on a specified table. In SQL Server, a trigger can fire a trigger to a nested limit of 32.)