VISOR is an IT company. It has a number of employees. The attributes of Employee include employee
Question:
VISOR is an IT company. It has a number of employees. The attributes of Employee include employee ID, name, address, and birth date. The company also has several projects. Attributes of project include project Name and start Date. Each project has some resources. A resource can be used in different projects. We need to record for each resource its type (software/hardware), price, brand, and date of use. Each employee may be assigned to one or more projects or may not be assigned to a project. The IT department manages many projects. The IT department has a director, budget, etc. Clients contract these projects. The clients name, address and phone number must be recorded. A project must have at least one employee assigned, and it may have any number of employees assigned. Each project has only one project manager. An employee’s billing rate may vary by project and the company wishes to record the applicable billing rate for each employee when assigned to a particular project. At the end of each month, the company mails a check to each employee who has worked on a project during that month. The check amount is based on the billing rate and the hours logged for each project assigned to the employee. You can enrich the case if needed).
Apply the data control language (DCL) in your project as the following:
Create two roles based on the nature of your business. Each one must be for different type of users.
- Each role must have at least two different privileges.
- Create four users and grant each two users a different role (e.g. two Admins and two normal users).
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi