1. Consider the relational database schema ofabove.Suppose that all the relations were created by (and hence are owned by) userJane Smith, who wants to grant the following privileges to user accounts A:

(a) Account A can retrieve or modify any relation except DEPENDENT; A can grant any of these privileges to other users.

(e) Suppose that the privilege in part (a) is given to account A is with GRANT OPTION, but only so that account A can grant it to at most five accounts, and each of these accounts can propagate the privilege to other accounts but without the GRANT OPTION privilege. How would you use the horizontal and vertical propagation limits in this case?

Write SQL statements to grant the above privileges. Use views if they are appropriate.