Answered: Show all female’s first names and their…

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

Show all female’s first names and their salary.

Show the branchno that has a supervisor whose
salary is greater than 15000.

Show the first name and birthday for all female
staff whose birthday is before 1950-01-01.

List of monthly salaries for all male staff,
showing the staff number, the first and last
names, and the salary details.

Transcribed Image Text:Below is the transcription of the tabular data regarding employee information: --- | staffNo | fName | lName | position | sex | DOB | salary | branchNo | |---------|-------|-------|------------|-----|------------|---------|----------| | SA9 | Mary | Howe | Assistant | F | 1970-02-19 | 9500.00 | B007 | | SG14 | David | Ford | Supervisor | M | 1958-03-24 | 18000.00 | B003 | | SG37 | Ann | Beech | Assistant | F | 1960-11-10 | 12000.00 | B003 | | SG5 | Susan | Brand | Manager | F | 1940-06-03 | 24000.00 | B003 | | SL21 | John | White | Manager | M | 1945-10-01 | 30000.00 | B005 | | SL41 | Julie | Lee | Assistant | F | 1965-06-13 | 9000.00 | B005 | --- ### Explanation: This table represents a dataset of employees with the following columns: - **staffNo**: The unique staff number assigned to each employee. - **fName**: First name of the employee. - **lName**: Last name of the employee. - **position**: Their job position, which includes roles such as Assistant, Supervisor, and Manager. - **sex**: The gender of the employee, where 'F' stands for female and 'M' for male. - **DOB**: Date of birth of the employee, formatted as YYYY-MM-DD. - **salary**: The yearly salary of the employee in the monetary unit specified (not explicitly mentioned). - **branchNo**: The branch number indicating the location or division within the organization.

Expert Solution

Step 1: Introduction

Relational database is a type of database which stores and provides the access to data which are related to each other. In relational database, the data is stored in the form of rows and columns that means in the form of tables.

Step by step

Solved in 3 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