Based on the ERD below, display all fields in the JOB table sorted by the largest hourly charges for the job first. The image depicts an Entity-Relationship Diagram (ERD) that showcases the relationships between four tables: JOB, EMPLOYEE, ASSIGNMENT, and PROJECT. Each table contains attributes, some of which serve as primary or foreign keys, establishing connections between the tables.### Tables and Attributes:1. **JOB Table** - **Primary Key:** `JOB_CODE` - **Attributes:** - `JOB_DESCRIPTION` - `JOB_CHG_HOUR` - `JOB_LAST_UPDATE`2. **EMPLOYEE Table** - **Primary Key:** `EMP_NUM` - **Attributes:** - `EMP_LNAME` - `EMP_FNAME` - `EMP_INITIAL` - `EMP_HIREDATE` - `JOB_CODE` (Foreign Key) - `EMP_YEARS`3. **ASSIGNMENT Table** - **Primary Key:** `ASSIGN_NUM` - **Attributes:** - `ASSIGN_DATE` - `PROJ_NUM` (Foreign Key) - `EMP_NUM` (Foreign Key) - `ASSIGN_JOB` - `ASSIGN_CHG_HR` - `ASSIGN_HOURS` - `ASSIGN_CHARGE`4. **PROJECT Table** - **Primary Key:** `PROJ_NUM` - **Attributes:** - `PROJ_NAME` - `PROJ_VALUE` - `PROJ_BALANCE` - `EMP_NUM` (Foreign Key)### Relationships:- The `JOB` table is related to the `EMPLOYEE` table via the `JOB_CODE`. The cardinality indicates a one-to-many relationship, meaning a single job can be associated with multiple employees.- The `ASSIGNMENT` table acts as a junction between the `EMPLOYEE` and `PROJECT` tables using foreign keys `EMP_NUM` and `PROJ_NUM`, indicating that multiple employees can be assigned to multiple projects. The relationships are many-to-one, denoting that each assignment is linked to one employee and one project.This diagram is essential for understanding how different entities within a company interact and can be used to effectively manage workforce allocations and project assignments.

SELECT * will fetch you all record in table

Answered: display all fields in the JOB table…

Engineering

Computer Engineering

display all fields in the JOB table sorted by the largest hourly charges for the job first

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

Similar questions

Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City, State, ZipCode and MemberFee. The table contains 75,000 documents. How would you build indexes for the table and why would you create these indexes?
Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee. Status Vacation Time Earned Full TIme 10 Part Time 7 Contract 0 Employees Status Vacation TIme Earned John Contract Jane Part Time Al Full TIme
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
Display the state of customers, the total and the average purchase amounts of each state in 2017 ordered by state. Rounding the amounts to 2 decimal places.
SQL code for: (1) Hint: A NULL in the hours column should be considered as zero hours. Find the ssn, lname, and the total number of hours worked on projects for every employee whose total is less than 40 hours. Sort the result by lname */ /* (2) For every project that has more than 2 employees working on it: Find the project number, project name, number of employees working on it, and the total number of hours worked by all employees on that project. Sort the results by project number. /* (3) For every employee who has the highest salary in their department: Find the dno, ssn, lname, and salary. Sort the results by department number. */ /* (4) For every employee who does not work on any project that is located in Houston: Find the ssn and lname. Sort the results by lname /* (5) Hint: This is a DIVISION query For every employee who works on every project that is located in Stafford: Find the ssn and lname. Sort the results by lname */
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To decrease the postal costs, they will send gifts to owners in batches to their corresponding offices. Similarly, the marketing team will send the gifts in groups to the residents living in the same property. Therefore, you will need to provide them the number of gifts for each StayWell office and number of gifts for each property. The column headers for the first table should be OFFICE_NUM and GIFTS, the column headers for the second table should be PROPERTY_ID and GIFTS. Provide the StayWell team the number of gifts for each office. Provide the StayWell team the number of gifts for each residence.
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
SQL Help The Car Maintenance team wants to learn how many times each car is used in every month and day to organize their maintenance schedules. The team wants a table with the following column names and information: Car ID Month Day Count You need to create a summary table using the WITH ROLLUP modifier and grouped by the specific column names, listed above, and send the data back to the team. Query the frequency of each car's use by month and day
Display the total number of credits earned in each year using the tot credits (year, num credits) view.