Some of the employees are office workers such as secretaries and accountants.The
ID: 3722258 • Letter: S
Question
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
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 6Explanation / Answer
Explanation:
Full outer join returns entries from both tables, whether there is a match or not.
Notice, the last 2 rows came in from the FLEET table, as the vehicle with those VEH_ID are not assigned to anyone, yet they show up in the table, with blank against the EMP_ID and L_NAME.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.