Explain what the tradeoffs are in using a marker-column for deletion, as opposed to actually deleting a row from a table?

Based on the feedback received on your Module 2 assignment Database Schema, provide SQL statements to create the (revised) database and populate it with sample data (at least four rows per table).

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.

I will add the module 2 work which was done by your company and it needs to be fixed exactly how my teacher recommened. Please make sure its exactly how she wants it.


Last Completed Projects

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min