Using the 2 following scenarios and please help provide the SQL code to use in Oracle. (Use the attached ERD) Let me know if updates are need in the ERD As well!

First Scenario

b. Develop a parameterized stored procedure that is used when any seller delivers any product to

The companies warehouse.

c. A seller delivers four each of the two new products added in Aspect 1 (the selfdriving video

camera and the holographic keyboard). Invoke the stored procedure twice to update the

inventory of these products for a seller of your choosing.

d. The seller from b above requests a listing of all of its products that have an inventory of 11 or

less. Develop and execute a single query that provides this information (the selfdriving video

camera and holographic keyboard should be among those listed).

Second Scenario

b. Develop a parameterized stored procedure that is used when any new customer signs up for a

new account on the company site.

c. You and your facilitator sign up for new accounts on Amazon. Invoke the stored procedure twice

to add you and your facilitator as customers.

d. For research purposes, the company requests the last names of customers where there are least 4

accounts associated with the last name. The company would like to see the actual number of

accounts associated with those last names. Develop and execute a single query that provides

this information.

Thank you so Much!

PK Selier DDIBINAL PROJECT e PK Ackiress id Seler type ende number buking Street name Apartment number Customer ID Cus First nme Cus Last name Phone number Email adthes Calegory Country_ code Calegory Name PK Product ID Customer Ackiress PF Ackiress id customer i Cus Phy method adchess type code prodat price Prnduct eondion code Onder stous Ship speed ene GILL PK Il ID Cusiomer order producs Cusiomer_order deveey PE Pinduct irt PK Selier DDIBINAL PROJECT e PK Ackiress id Seler type ende number buking Street name Apartment number Customer ID Cus First nme Cus Last name Phone number Email adthes Calegory Country_ code Calegory Name PK Product ID Customer Ackiress PF Ackiress id customer i Cus Phy method adchess type code prodat price Prnduct eondion code Onder stous Ship speed ene GILL PK Il ID Cusiomer order producs Cusiomer_order deveey PE Pinduct irt