Write the commands in SQL Developer to perform the tasks described below. Then click on Write Submission and copy and paste the commands into the submission box. This assignment should be completed by July 30th

Create a sequence to generate new customer numbers for the customers table. Make sure that the values you use are consistent with the values that are already in the database.

Add a new customer to the customers table. Use the following information. Make sure the data you enter are formatted the same as the other data in the database.

The customer number should come from the sequence you created

The first name is Mary and the last name is Shoulders.

The address is 2230 Happy Valley Ln, Atlanta, Georgia, 30304.

She was referred by Jake Lucas.

Her e-mail address is M_Shoulders@yahoo.com.

Create an index for the books table based on the categories of the books. Name the index book_categories_index.

Create a synonym for the book_categories_index called category_idx.