9. Explain how you could delete the IT department without deleting all the emplo

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.

13. 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.

Explanation / Answer

Dear, 9. DELETE FROM employees WHERE department='IT' 10. Haven't specified the table name assuming foods
UPDATE foods SET price=price+1 11.UPDATE foods SET price=price+1 where name='grilled steak' Hope this will help you Hope this will help you

Related Questions

Navigate

• Browse (All)
• Browse 9
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.