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).
data mining
Description
|
Database Schema-SQL Statements |
|
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 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?
APA format is not required, but solid academic
writing is expected.
This assignment uses a grading rubric.
Instructors will be using the rubric to grade the assignment; therefore,
students should review the rubric prior to beginning the assignment to become
familiar with the assignment criteria and expectations for successful
completion of the assignment.
You are not required to
submit this assignment to LopesWrite.
RUBRIC
Attempt Start Date: 09-Jul-2020 at 12:00:00 AM
Due Date: 19-Aug-2020 at 11:59:59 PM
Maximum Points: 125.0
