Answered: • Find all staff fname and direct…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Transcribed Image Text:### Educational Content: Finding Staff and Their Supervisors The SQL query results illustrate how to retrieve staff members' first names and their direct supervisors' first names from a database. #### SQL Query ```sql MariaDB [dreamhome]> select * from Staff1; ``` #### Table Structure The table `Staff1` provides the following columns of data: - **staffNo**: Staff number - **fName**: First name - **lName**: Last name - **position**: Job position - **sex**: Gender - **DOB**: Date of Birth (YYYY-MM-DD) - **salary**: Salary - **branchNo**: Branch number - **superno**: Supervisor number #### Data Example The data in the table is structured as follows: | staffNo | fName | lName | position | sex | DOB | salary | branchNo | superno | |---------|-------|-------|-----------|-----|------------|---------|----------|---------| | SA9 | Mary | Howe | Assistant | F | 1970-02-19 | 9000.00 | B007 | SG5 | | SG14 | David | Ford | Supervisor| M | 1958-03-24 | 18000.00| B003 | SG5 | | SG37 | Ann | Beech | Assistant | F | 1960-11-10 | 12000.00| B003 | SG5 | | SG5 | Susan | Brand | Manager | F | 1940-06-03 | 24000.00| B003 | SL21 | | SL21 | John | White | Manager | M | 1945-10-01 | 30000.00| B005 | NULL | | SL41 | Julie | Lee | Assistant | F | 1965-06-13 | 9000.00 | B005 | SL21 | #### Output - Staff and Their Supervisors The resulting output showcases the relationship between each staff member and their supervisor: | staff | supervisor | |--------|------------| | Mary | Susan | | David | Susan | | Ann | Susan | | Susan | John | |

Expert Solution

Step 1 Solution

For such questions, we can solve them using joins.

Joins combine the data from two tables using the foreign key of one table into another table.

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions