Asked by Hallie Canto on May 07, 2024
Verified
Sam created a self join between two copies of the Employees table and then renamed one copy Managers.When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?
A) The datasheet lists employees with no managers.
B) The datasheet lists managers with no employees.
C) Employee last names are repeated many times because many employees report to the same managers.
D) Manager last names are repeated many times because many employees report to the same managers.
Self Join
A database join operation in which a table is joined with itself, used to compare rows within the same table.
Employees Table
A structured arrangement in a database or spreadsheet specifically designed to hold information about employees.
Managers Table
A database or spreadsheet feature used to organize and manage information relating to managers within an organization.
- Identify the differences between self joins and alternative join techniques.
Verified Answer
HJ
Heather JimenezMay 10, 2024
Final Answer :
D
Explanation :
Since it's a self join and one copy of the table has been renamed as Managers, when the LastName field is added from both tables, it will list the managers' last names along with employee last names they manage. Hence, Manager last names will be repeated many times as many employees report to the same managers.
Learning Objectives
- Identify the differences between self joins and alternative join techniques.