This problem from Oracle 12c chapter 6, ISBN : 9781305251038 I am having trouble so just need help plz. honestly i don't have the book, i mean if anyone has book by Joan Casteel oracle 12c and i did provide the ISBN number too, that would be great

Case Study: City Jail 224 1. The head DBA has requested the creation of a sequence for the primary key colu the Criminals and Crimes tables. After creating the sequences, add a new criminal Johnny Capps to the Criminals table by using the correct sequence. (Use any values the remainder of columns.) A crime needs to be added for the criminal, too. Add a row to the Crimes table, referencing the sequence value already generated for the Criminal ID and using the correct sequence to generate the Crime. ID value. (Use any values for the remainder of columns.) named for 2. The last name, street, and phone number columns of the Criminals table are used quite often in the WHERE clause condition of queries. Create objects that might improve data retrieval for these queries. 3. Would a bitmap index be appropriate for any columns in the City Jail database (assu ming the columns are used in search and/or sort operations)? If so, identify the columns and explain why a bitmap index is appropriate for them. 4. Would using the City Jail database be any easier with the creation of synonyms? Explain why or why not