Question
1. Temple Consulting is a professional services company. Employee training is critical to their success in their knowledge industry. The HRIS system tracks employee training.
1. 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 | HireDate | |||
10343 | Sandra | Song | 2017-02-02 | |||
10354 | Nicole | Kim | 2018-05-07 | |||
10385 | Samuel | Walter | 2018-09-14 | |||
10399 | Jeffrey | King | 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. If the EmployeeID field is used for the join, performing a left join with EmployeeData and TrainingData will result in
A.7 rows.
B.8 rows.
C.4 rows.
D.6 rows.
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