Create SQL database


a) Create an Employee contact information view from single base table

b) 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_name

d) Use the view to find out all the job histories that were started after Jan 01, 1995