| Table |
Description |
| COUNTRIES |
country table. Contains 25 rows. References with locations table.
|
| DEPARTMENTS |
Departments table that shows details of departments where employees
work. Contains 27 rows; references with locations, employees, and job_history tables.
|
| EMPLOYEES |
employees table. Contains 107 rows. References with departments,
jobs, job_history tables. Contains a self reference.
|
| JOB_HISTORY |
Table that stores job history of the employees. If an employee
changes departments within the job or changes jobs within the department,
new rows get inserted into this table with old job information of the
employee. Contains a complex primary key: employee_id+start_date.
Contains 25 rows. References with jobs, employees, and departments tables.
|
| JOBS |
jobs table with job titles and salary ranges. Contains 19 rows.
References with employees and job_history table.
|
| LOCATIONS |
Locations table that contains specific address of a specific office,
warehouse, and/or production site of a company. Does not store addresses /
locations of customers. Contains 23 rows; references with the
departments and countries tables.
|
| REGIONS |
|