CREATE VIEWS ON THE EMPLOYEES AND DEPARTMENT TABLES THAT REMOVE ALL PERSONAL INFORMATION

2. Create views on the EMPLOYEES and DEPARTMENT tables that remove all

personal information:

create view emp_anon_v asselect hire_date, job_id,salary,commission_pct,department_id from employees;create view dept_anon_v asselect department_id,department_name,location_id from departments;