Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date. The image depicts an Entity-Relationship Diagram (ERD) with four tables, illustrating a database structure for a company's job assignment system. Below is a detailed explanation of each table along with the relationships among them:### Tables and Attributes:1. **JOB Table** - **Attributes:** - **JOB_CODE:** Primary Key, uniquely identifies each job. - **JOB_DESCRIPTION:** Describes the job role. - **JOB_CHG_HOUR:** Indicates the charge per hour for the job. - **JOB_LAST_UPDATE:** Records the last update time of the job information.2. **EMPLOYEE Table** - **Attributes:** - **EMP_NUM:** Primary Key, uniquely identifies each employee. - **EMP_LNAME:** Last name of the employee. - **EMP_FNAME:** First name of the employee. - **EMP_INITIAL:** Middle initial of the employee. - **EMP_HIREDATE:** Date the employee was hired. - **JOB_CODE:** Foreign Key, links to the JOB table. - **EMP_YEARS:** Number of years the employee has worked.3. **ASSIGNMENT Table** - **Attributes:** - **ASSIGN_NUM:** Primary Key, uniquely identifies each assignment. - **ASSIGN_DATE:** Date of the assignment. - **PROJ_NUM:** Foreign Key, links to the PROJECT table. - **EMP_NUM:** Foreign Key, links to the EMPLOYEE table. - **ASSIGN_JOB:** Job assigned to the employee. - **ASSIGN_CHG_HR:** Charge per hour for the assignment. - **ASSIGN_HOURS:** Number of hours assigned. - **ASSIGN_CHARGE:** Total charge for the assignment.4. **PROJECT Table** - **Attributes:** - **PROJ_NUM:** Primary Key, uniquely identifies each project. - **PROJ_NAME:** Name of the project. - **PROJ_VALUE:** Budgeted value for the project. - **PROJ_BALANCE:** Remaining balance for the project. - **EMP_NUM:** Links to the employee involved with the project.### Relationships:- The **JOB** table is connected to the **EMPLOYEE** table via the **JOB_CODE**.- The **EMPLOYEE** table connects to the **ASSIGNMENT** table through **EMP_NUM**, facilitating relationships between employees and their assignments.- The

ORDER BY is the keyword used to sort the list and to make it in descending order, we use DESC commandSELECT EMP_FNAME, EMP_LNAME, EMP_HIREDATE, EMP_YEARS FROM EMPLOYEE WHERE EMP_YEARS>15 ORDER BY EMP_HIREDATE DESC;

Answered: display the first and last names, hire…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.