Answer Happy

Important Note: Please don't take the answer from
another one and read the Qs probably the questions here is
different from the others, please
(c) Suppose that a database includes the following relations. employee(id, name, address, age, dept_no*) department(dept_no, dept_name, location, building) project(projectNumber, subject, level, dept_no*) . (0) The Users of the database are: Isavella who is authorised to do anything with the relations; Laura who can see and change all employee details, but cannot add or delete new employees and cannot access the other relations; Naser who has the same authorisation as Laura. Write SQL statements that give these Users the access described above. (ii) Suppose that there is another User, Jane, who can only see projects for which level=advanced; she is not authorised to do anything else. Write SQL statements that implement this. (iii) Now suppose that Naser has now moved to another company and, therefore, should no longer have access to the database. Write a SQL statement to implement this.