Question
Temple Consulting is a professional services company. Employee training is critical to their success in their knowledge industry. The HRIS system tracks employee training. The
Temple Consulting is a professional services company. Employee training is critical to their success in their knowledge industry. The HRIS system tracks employee training. The HRIS database contains the following tables:
EmployeeData | |||||||
EmployeeID | First Name | Last Name | Position | HireDate | |||
10343 | Sandra | Song | Manager | 2017-02-02 | |||
10354 | Nicole | Kim | Director | 2018-05-07 | |||
10385 | Samuel | Walter | Manager | 2018-09-14 | |||
10399 | Jeffrey | King | Manager | 2019-04-16 | |||
TrainingData |
| ||||||
CourseID | EmployeeID | DateCompleted |
| ||||
543 | 10343 | 2022-05-05 |
| ||||
543 | 10354 | 2022-05-05 |
| ||||
543 | 10385 | 2022-10-11 |
| ||||
754 | 10343 | 2022-11-09 |
| ||||
754 | 10354 | 2022-01-08 |
| ||||
754 | 10385 | 2022-09-11 |
| ||||
939 | 10343 | 2022-11-13 |
| ||||
EmployeeData is the left table and TrainingData is the right table. What would be the most appropriate join type to determine what employee has not taken a course?
EmployeeData left join with TrainingData
EmployeeData inner join with TrainingData
TrainingData right join with TrainingData
None of the answer choices are correct.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started