This is all one question

2. Views a) Create an Employee contact information view from single base table b) Create an Employee work location information view (dname, street adr, city, state, zip) c) Create a view of the DB, called EMP_JOB, that reports the following required information for all entries of job history: employee_id, last name, job_title, start_data, end date and department_name d)Use the view to find out all the job histories that were started after Jan 01, 1995 2. Views a) Create an Employee contact information view from single base table b) Create an Employee work location information view (dname, street adr, city, state, zip) c) Create a view of the DB, called EMP_JOB, that reports the following required information for all entries of job history: employee_id, last name, job_title, start_data, end date and department_name d)Use the view to find out all the job histories that were started after Jan 01, 1995