1. 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?
2. Design a database prototype that comprises diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
Database Proposal Below
Pharmacy Designating Database
The intent of this Database Design Proposal is to design and develop a database that will describe, compile, and designate the location of the medications ordered. Medications are ordered 24/7 in the hospital for the inpatients and yet the medications ordered are not making it to the patient. The medications seem to be lost or else simply missing from the floor. The nurses have several places to look for their patients' medications, but stay confused about where each medication is kept. Scheming a designating database would list the description of where the medication is kept on each floor or if it will come from pharmacy.