$(2)$ Assume that CREATE TABLE statements given on page $4$ of the examination paper are included in a

script file dept.sql$.$ Assume that a user root with a password 'root' would like to create a

database called dept and inside the database the user root would like to create the tables given on

page $4$ of the examination. Write SQL script that performs all action listed below as a user root.

a$)$ Then, a user root would like to create a new user account called admin with a password

'admin'.

b$)$ The new user admin must have access in read mode to the relational tables Department,

Employee and Project.

c$)$ The new user admin must have access in write mode to information about the employee works on

projects. The new user has the right to propagate such privilege to other users.

d$)$ The new user admin must have the rights to execute CREATE TABLE and CREATE VIEW

statements with no right to propagate the privilege to the other users.

e$)$ The new user admin must have the rights to reference the primary keys in the tables Employee

with no rights to propagate the privilege to the other users.

f$)$ The new user admin must have the rights to create at any time only one connection to the

database.