$(5-5)$ Question $4$:

Write a script that does the following:

$$ Display all the data in sec$0505\_$foods

$$ Create a view of the foods table, including all the columns and rows

$$ Insert a new row into the view

$$ Update the view, setting menu$\_$item to $20$ and description to $$CARROTS$$ where the

description is currently $$BROCCOLI$$

$$ Delete a row from the view

$$ Display all the data in the view

$$ Display all the data in sec$0505\_$foods

$(5-11)$ Question $5$:

List the names of all the tables you own.

$(5-12)$ Question $6$:

List the names of all the views you own.

$(5-14)$ Question $7$:

Use the Data Dictionary to find the names of all the columns of the L$\_$EMPLOYEES table.

$(5-15)$ Question $8$:

Use the Data Dictionary to find the primary key of the L$\_$EMPLOYEES table.