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.