5- of employee's job doesn't have job id insert new job id in jobs table with the first three letters of the job name 6- if department name doesn't exist insert it into deprtments and give it new id ...