please i need help with this Database project and i would hope you show me all steps

Run the script, C7_BBcreate.sql, to create the tables required for this lab.

Create a package named Program10_PKG containing two overloaded procedures. Both procedures should use the same DML to query the BB_SHOPPER table for the following data: First name, Last name, City, State, Phone, and e-mail address. The first procedure must use the Shopper ID to search for the record in the table. The second procedure must use the last name for the search. Do not print any data in the procedure. Use parameters to return the data to the calling program unit. Include a NO_DATA_FOUND exception handler to display a message that no record was found. Test the package three times, with an anonymous block. Call the procedure with shopper ID of 23, then 30, and then with a last name of Ratman