1- Write, but do not execute, the commands to grant the following privileges:

a- User Rodriquez must be able to retrieve data from the BOOK table.

b- Users Gomez and Liston must be able to add new books and publishers to the database.

c. Users Andrews and Zimmer must be able to change the price of any book.

d- All users must be able to retrieve the book title, book code, and book price for every book.

e- User Golden must be able to add and delete publishers.

f. User Andrews must be able to create an index for the BOOK table.

g- Users Andrews and Golden must be able to change the structure of the AUTHOR table.

h- User Golden must have all privileges on the BRANCH table.

2. Write, but do not execute, the command to revoke all privileges from user Andrews.

3. Create the following indexes: a. Create an index named BOOK_INDEX1 on the TITLE column in the BOOK

table. b. Create an index named BOOK_INDEX2 on the TYPE column in the BOOK

table. c. Create an index named BOOK_INDEX3 on the CITY and PUBLISHER_NAME

columns in the PUBLISHER table.