Some of the employees are office workers such as secretaries and accountants.These types of positions are not assigned a company vehicle in order to complete their daily work.Other workers are meter readers, service technicians and line crew and use different types of vehicles in the fleet to complete their daily work.The permanent meter readers and service technicians have a truck assigned to them that they use every day.Part-time and/or temp workers share the floater truck.

The VEH_ID in the EMPLOYEE table denotes which vehicle in the FLEET (if any) are assigned to each EMPLOYEE.

Each table contains 20-40 additional attributes that pertain to the entity (all vehicle information and all employee information, respectively) as well as many, many more rows.This has been condensed for ease of use.The concept remains the same, whether using this small example or tables with hundreds of records.

Complete the table below by filling in the values that would be returned for an outer join on FLEET

EMP_CODE	L_NAME	VEH_ID

Table Name: FLEET Table Name: EMPLOYEE VEH ID VEH TYPE EMP CODE L NAME VEH ID 10 20 30 40 50 60 70 80 90 Davolio Grubb Leverling Penn Buchanan Smith King Callahan Dodsworth 1 Truck-FLOATER Truck Truck Truck Truck Van Line ServiceTruck 4 3 4 6