I\'m behind in my SQL assignments, and I need major help. Thanks CIS250 Unit 2 A

Question

I'm behind in my SQL assignments, and I need major help. Thanks

CIS250 Unit 2 Assignment 2
Directions
Perform the tasks below by using the correct SQL statements. You must create the statements in Oracle by using the following steps (SQL > SQL commands > Enter Command). Once your command is error-free, copy and paste your statements into the assignment document. Upload this Word document for grading.
Scenario:
The suppliers want access to our database to enter their own prices. Although they are worried that other suppliers can see their prices, we have assured them that this is not possible

5. Attempt to insert the following two records into the view. Were you successful, why or why not?

Supplier_id product_code menu_item description price p
ASP GG 22 GRILLED GARDEN 6
CBC GS 23 GRILLED SALAD 6

Note: the last column should be price_increase 7 for both rows after column price.

6. What is a preventative delete?

7. Create a new table using the following column structure from the l_foods table: supplier_id, product_code, menu_item, description and price. Call the table l_foods_lt5. Populate the l_foods_lt5 table to include all the foods that cost less than $5.00.

8. Supplier ASP has gone out of business. Delete all the products for supplier ASP from your l_foods_lt5 table. Make sure your changes save.

9. Remove all the entries in the your l_foods_lt5 table, but not the table itself.

10. Delete the l_foods_lt5 table itself.

Explanation / Answer

8.SQL>Delete l_foods_lt5 where supplier_id ='ASP'; //delete supplier ASP SQL>commit; //save changes 9. SQL>Delete l_foods_lt5; 10. SQL> drop table l_foods_lt5 ;

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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