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 | |
If EmployeeData is the left table and TrainingData is the right table, what would be the most appropriate join type to determine which courses were taken by employees who are managers?
EmployeeData left join with TrainingData
EmployeeData inner join with TrainingData
EmployeeData 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