Create SQL database
1. Views
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
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
