Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

1951077083, 978-1951077082

More Books

Students also viewed these Databases questions