Question

9. Explain how you could delete the IT department without deleting
all the employees who work for that department
10. Supplier ASP’s has decided to raise their prices. They raised
the price of all their foods by a $1. Update the database to show
this change.
11. The price of grilled steak increased by 2 dollars. Update the
database to show this change. Show your sql below.
12. The lunches scheduled for the 5 of December has been moved to
the 15th of December. Update the database to show this change. Show
your sql below
A new supplier, RGF (Really Good Food) has been approved. RGF
supplys all the same items as CBC, but 50 cents cheaper. Show the
insert statements required to enter this information into the
l_foods and l_suppliers table.