1. Viewsa) Create an Employee contact information view from single base tableb) Create an Employee work location information view ( d_name, 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_named) Use the view to find out all the job histories that were started after Jan 01, 1995
