## Company

id | name | address | website
--- | --- | --- | ---
1 | Company A | Address A | www.companya.com
2 | Company B | Address B | www.companyb.com
3 | Company C | Address C | www.companys.com
4 | Company D | Address D | www.companyd.com
5 | Company E | Address E | www.companye.com

## Department

id | company_id | name
--- | --- | ---
| (→ Company.id) |
1 | 1 | Department A
2 | 1 | Department B
3 | 2 | Department X
4 | 3 | Department Y
5 | 4 | Department Z

## Position

id | department_id | title | creative_industry_profession | office | salary
--- | --- | --- | --- | --- | ---
| (→ Department.id) |  |  |  |
1 | 1 | Position A | Graphic Designer | 2/7 London Street | 60000
2 | 1 | Position B | Software Engineer | 2/9 London Street | 80000
3 | 2 | Position C | Graphic Designer | 3/4 New York Avenue | 55000
4 | 3 | Position D | Data Analyst | 3/2 San Francisco Way | 70000
5 | 4 | Position E | Web Developer | 2/7 London Street | 75000

## Employee

id | position_id | employee_name | hire_date
--- | --- | --- | ---
| (→ Position.id) |  |
1 | 1 | John Doe | 2021-01-01
2 | 2 | Jane Smith | 2021-02-01
3 | 3 | Alice Johnson | 2021-03-01
4 | 4 | Bob Brown | 2021-04-01
5 | 5 | Charlie Green | 2021-05-01