Question

Database Schema You are given a database for an employee management system. The table names are self-explanatory. • companies (ID, Name) 1. ID: The unique ID of the company. 2. Name: The name of the company. • employees (ID, Name, Job_ID) 1. ID: The unique ID of the employee. 2. Name: The name of the employee. 3. Job ID: The job of that employee, referring to the jobs table. • jobs (ID, Company ID, Name, Salary) 1. ID: The unique ID of a job. 1 2. Company ID: The id of the company associated with the job, referring to the companies table. 3. Name: The name of the job. 4. Salary: The salary of the job.

          Database Schema
You are given a database for an employee management system. The table names are self-explanatory.
• companies (ID, Name)
1. ID: The unique ID of the company.
2. Name: The name of the company.
• employees (ID, Name, Job_ID)
1. ID: The unique ID of the employee.
2. Name: The name of the employee.
3. Job ID: The job of that employee, referring to the jobs table.
• jobs (ID, Company ID, Name, Salary)
1. ID: The unique ID of a job.
1
2. Company ID: The id of the company associated with the job, referring to the companies
table.
3. Name: The name of the job.
4. Salary: The salary of the job.

Show more…

Database Schema
You are given a database for an employee management system. The table names are self-explanatory.
• companies (ID, Name)
1. ID: The unique ID of the company.
2. Name: The name of the company.
• employees (ID, Name, JobID)
1. ID: The unique ID of the employee.
2. Name: The name of the employee.
3. Job ID: The job of that employee, referring to the jobs table.
• jobs (ID, Company ID, Name, Salary)
1. ID: The unique ID of a job.
1
2. Company ID: The id of the company associated with the job, referring to the companies
table.
3. Name: The name of the job.
4. Salary: The salary of the job.

Added by Oscar M.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Manisha Sarker

Step 1

a, we need to find the employee at Microsoft with the highest salary. We can do this by joining the employees and jobs tables, filtering for Microsoft employees, and then ordering by salary in descending order. Show more…

Show all steps

lock

Thanks for your feedback!

ASAP!!! Please make sure that the query is runnable:) I provided the schema for the DB. The answers for the questions below need to be answered by an SQL query. Question 2.a: Which employee at Microsoft has the highest salary? 2.b: Find the average salary of all jobs excluding the highest-paid company, rounded to two decimal places. 2.c: How many people hold the maximum salary? 2.d: What is the most common salary? Database Schema: You are given a database for an employee management system. The table names are self-explanatory. companies (ID, Name) 1. ID: The unique ID of the company 2. Name: The name of the company. employees (ID, Name, Job_ID) 1. ID: The unique ID of the employee 2. Name: The name of the employee. 3. Job_ID: The job of that employee, referring to the jobs table. jobs (ID, Company_ID, Name, Salary) 1. ID: The unique ID of a job 2. Company ID: The ID of the company associated with the job, referring to the companies table. 3. Name: The name of the job. 4. Salary: The salary of the job

Play audio

Feedback

Powered by NumerAI

Manisha Sarker and 91 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later