For this exercise on the Patient table,create: a history table with a column that stores value for delete or update

For this exercise on the Patient table,create:

1. A history table with a column that stores value for delete or update

2. A delete trigger

3. An update trigger

4. An instead of trigger

SQL Server