Question: Suppose that a database includes the following relations. employee ( id , name, address, age, dept _ no * ) department ( dept _ no

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*)
(i) 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.
(6 marks)
(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.
(5 marks)
(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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!