Build a database

The employee details of company ABC are stored in the table employees. As a security measure, employees are given access to the records through a view that shows only the name and contact details of employees working in the same department. Managerial staff are given access to all the records of employees working under them, through another view. This security measure restricts the visibility of information to the employees and requires new views to be created and maintained as new requirements arise. Thus, you are required to implement the following security requirement on the table employees using VPD: 1. All employees must be able to view all the employee records except the salary and commission percentage details. 2. An employee can only view his/her salary and commmission percentage details 3. All the managers must be able to view all the records of employees working under them (including salary and commission percentage details) 4. Employees working in the Human Resources department have a higher privilege than the other users and must be able to view all the details of the employees withouth any restriction. The details of the relations are given below: departments(department_id, department_name, manager_id, location_id); employees(employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, department_id) You are given all the required privileges to implement VPD on the table employees. Company employees will be using their email as the username to log in to the database. Scrips are provided only need to complete the above 4 tasks