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 ...

With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations. If you have a large data source, such as an Access ...