(Solved) : Need Help Project Please Second Time Posted Question Nobody Answered Run Script C10bbcrea Q29190615 . . . .

Again, need help with this project, please. this is the secondtime that i posted the same question because nobody answeredit.

Run the script, C10_BBcreate.sql, to create the tables requiredfor this lab. A company want to allow customers to do productsearch by selecting a product name or description, and then typinga search term. Using native dynamic SQL, create a procedure nameSEARCH_SP that returns a product name, description, and price baseon users’ search criteria. The procedure needs handle multiple rowsbeing returned.

here is the script

DROP TRIGGER fire_two_trg;

DROP TRIGGER fire_one_trg;

DROP VIEW bb_basketitem_vu;

DROP VIEW bb_ship_vu;

DROP TABLE bb_department CASCADE CONSTRAINTS;

DROP TABLE bb_product CASCADE CONSTRAINTS;

DROP TABLE bb_productoption CASCADE