Question: Create at least 5 Functional Delete Statements for the Homework Database Each of the Delete Statements must be preceded by a SELECT Statement that lists
Create at least Functional Delete Statements for the Homework Database Each of the Delete Statements must be preceded by a SELECT Statement that lists the rowstuples that are going to be updated based on the criteria in the Delete Statement. Each of the Delete Statement, after the rowstuples have been updated, must have a written SELECT Statement that lists the rowstuples in their updated state. This will visually verify that the delete occurred according to plan. What to Submit?Upload a Text File with a SQL ExtensionInclude a copy of your version of the Homework Assignment: EMPLOYEE, STORE, REGION, and SUPPLIER Database. both CREATE TABLE Statements and INSERT INTO Statements. All the Scripts must be combined into a single SQL Text File Submit an SQL Text File for the SQL portion of this assignment. An SQL Text File is a text file with a SQL extension on the file name. The script should be well documented with commentsAll the script must be placed in one fileThe script should run continuously without errors
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
