Provide SQL statements to create the database and populate it with sample data at least 4 rows per table
modify the database by adding an additional column "Deleted_Date" to those tables that represent entities that could contain data which can be deleted and justify your rationale in a short paragraph.
Explain what the tradeoffs are in using a marker-column for deletion as opposed to actually deleting a row from the table.