Data Modeling, Normalization & Optimization

Data Modelin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing, Normalization & Optimization Order Description 1) 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). 2) Modify the database by addin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing an additional column ("Deleted_Date") to those tables that represent entities that could contain" rel="nofollow">in" rel="nofollow">in" rel="nofollow">in data which can be deleted and justify your rationale in" rel="nofollow">in" rel="nofollow">in" rel="nofollow">in a short paragraph. In addition, explain" rel="nofollow">in" rel="nofollow">in" rel="nofollow">in what the tradeoffs are in" rel="nofollow">in" rel="nofollow">in" rel="nofollow">in usin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing a marker-column for deletion, as opposed to actually deletin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing a row from a table? 3) APA format is not required, but solid academic writin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing is expected. 4) This assignment uses a gradin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing rubric. Instructors will be usin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing the rubric to grade the assignment; therefore, students should review the rubric prior to begin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">innin" rel="nofollow">in" rel="nofollow">in" rel="nofollow">ing the assignment to become familiar with the assignment criteria and expectations for successful completion of the assignment