please use the picture below to answer the following question Display employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep".
please use the picture below to answer the following question Display employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep".
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
Related questions
Question
question 14
please use the picture below to answer the following question
Display employee number, employee last name, and hire date for employees whose last name includes letter e and their position is "Sales Rep".
![Invoice table
Column
DEFAULT
PK
NOT NULL UNIQUE
FK
VALIDATION
Column Names
DataTypes
VALUE
InvoiceNum
|Integer
InvoiceDate
Date
CustomerNum
Integer
Invoice_Detail
Column
DEFAULT
table Column
PK
NOT NULL UNIQUE
FK
VALIDATION
DataTypes
VALUE
Names
Invoice_number |Integer
Prod_ID
Quantity
Integer
Integer
Value must
price
Decimal(3,0)
be >0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4a5d1eb1-3f81-4d1a-b6f5-b63bc1325c48%2F2c344c58-a0a5-4ea7-8346-9abcbac3a1be%2F25jgup_processed.png&w=3840&q=75)
Transcribed Image Text:Invoice table
Column
DEFAULT
PK
NOT NULL UNIQUE
FK
VALIDATION
Column Names
DataTypes
VALUE
InvoiceNum
|Integer
InvoiceDate
Date
CustomerNum
Integer
Invoice_Detail
Column
DEFAULT
table Column
PK
NOT NULL UNIQUE
FK
VALIDATION
DataTypes
VALUE
Names
Invoice_number |Integer
Prod_ID
Quantity
Integer
Integer
Value must
price
Decimal(3,0)
be >0
![Employee
Customer
Invoice
PK EmployeelD
PK Customer_Number
Customer Name
PK Invoice_Number
Invoice_Date
FK Customer_Number
Emp_FName
Emp_LName
soc_Ins
FK Position_ID
FK Supervisor_ID
Location
FK Rep_ID
Invoice_Detail
Position
PK,
HireDate
Invoice_Number
FK1
PK Position_ID
PI,
Position
Prod_ID
FK2
Quantity
Title
Price
PK
Title_ID
Title
Author
Author_Product
Product
PK Author_ID
PK,
PK
Product_ID
Author_ID
FK1
Author_FName
FK
Title_ID
Edition
Author LName
PK,
Prod_ID
FK2
FK
Edition_ID
PK Edition_ID
Purchase_Cost
Edition
Retail_Price](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4a5d1eb1-3f81-4d1a-b6f5-b63bc1325c48%2F2c344c58-a0a5-4ea7-8346-9abcbac3a1be%2Fb4wf5o5_processed.png&w=3840&q=75)
Transcribed Image Text:Employee
Customer
Invoice
PK EmployeelD
PK Customer_Number
Customer Name
PK Invoice_Number
Invoice_Date
FK Customer_Number
Emp_FName
Emp_LName
soc_Ins
FK Position_ID
FK Supervisor_ID
Location
FK Rep_ID
Invoice_Detail
Position
PK,
HireDate
Invoice_Number
FK1
PK Position_ID
PI,
Position
Prod_ID
FK2
Quantity
Title
Price
PK
Title_ID
Title
Author
Author_Product
Product
PK Author_ID
PK,
PK
Product_ID
Author_ID
FK1
Author_FName
FK
Title_ID
Edition
Author LName
PK,
Prod_ID
FK2
FK
Edition_ID
PK Edition_ID
Purchase_Cost
Edition
Retail_Price
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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.Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education