Assignment 2 - Based on the feedback received on your Topic 2 assignment Database
Buy and Download >
Based on the feedback received on your Topic 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four 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. In addition, explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table? This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. You are not required to submit this assignment to LopesWrite.