8. Assume that a table named AUTHOR is already existed with the following rows. [5 Marks) AuthorID 501 502 503 AUTHOR Author Name William Agatha Barbara a) Add a new column. Size Column Name Data Type No_Publications Number Constraint - Column Level Should not be empty 10 b) Modify the author name with "Steel for the Author ID 501. c) Delete the constraint of No_Publications column. 9. Assume that the table "AUTHOR' is available in "user006". [4 Marks] a) Give the permissions to allow the user "user009 to modify the data in table "AUTHOR" b) Create a save point with the name of SP5. c) Write a query to modify Author Name of Author ID 502 to "John" by user user009". d) Cancel all the transactions up to save point "SP5". e) Cancel all the privileges given to user "user009