Provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table . Include patient name, Patient ID, Date of birth, Gender).
2) 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. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?
3) APA format is not required, but solid academic writing is expected.