Prepare SQL to update your implement database table from assignment one

Implement$($name$,$ cost$,$ date$-$purchased, category, modelYear$)$:

with three rows of table data from assignment $1$:

'Box Blade$-4f{t}^{\text{'}},429\mathrm{.}99,\text{'}2001-05-04\text{'},$'grader',$2000$

'Cultivator', $224\mathrm{.}99,\text{'}1981-01-23\text{'},$'tillage', $1960$

'Finishing Mower$-5f{t}^{\text{'}},1379\mathrm{.}00,1988-06-02\text{'},$ 'cutter', $\text{'}1987$

If necessary, issue ALTER TABLE commands to ensure the table structure and

data are consistent with assignment $1.$ If not already included, apply an

alteration to ensure the table has a primary key on name.

Issue a START TRANSACTION command so a series of update commands may be

rolled back.

Give a SHOW CREATE TABLE schema.tableName command to document the Implement

table structure.

Code a SELECT schema.tableName to project all Implement table columns with

rows listed in key order.

Insert Data:

a$.$ Insert a table row with these values:

'Finishing Mower$-6$ ft$\text{'},1599\mathrm{.}00,\text{'}2010-04-08\text{'},$'cutter',$2010$

b$.$ Code a single insert statement with values for two new rows:

'Middle Buster',$138\mathrm{.}62,\text{'}2020-03-16\text{'},$'tillage',$2020\text{'}$

'Landscape Rake',$469\mathrm{.}99,\text{'}2017-06-25\text{'},$'utility',$2017$

Modify Data:

a$.$ Update one column in a single row. This update should reference the

primary key in A restrict clause.

b$.$ Issue a single update that will modify two columns in a single row. This

update should reference the primary key in it's restrict clause.

c$.$ Code a single update statement that will modify the same column value in

every table row for a particular group $($e$.$g$.$ global change for two or

more rows with the same value in a certain column or that have values

within a specified range$).$

d$.$ Issue a "restrict" query with the IN option that lists the primary key

values for the rows updated in parts a through $c.$

Delete Data:

a$.$ Query your table again.

b$.$ Delete a single row. This delete should reference the primary key in

it's restrict clause.

c$.$ Issue a single delete that will remove all rows having values in one

column that fall within a certain range$($use the BETWEEN operator$).$

d$.$ Query your updated table projecting all columns with rows ordered by key.

Issue a rollback, then another query to show the table has been restored.