Company

idnameaddresswebsite
1Company AAddress Awww.companya.com
2Company BAddress Bwww.companyb.com
3Company CAddress Cwww.companys.com
4Company DAddress Dwww.companyd.com
5Company EAddress Ewww.companye.com

Department

idcompany_idname
(→ Company.id)
11Department A
21Department B
32Department X
43Department Y
54Department Z

Position

iddepartment_idtitlecreative_industry_professionofficesalary
(→ Department.id)
11Position AGraphic Designer2/7 London Street60000
21Position BSoftware Engineer2/9 London Street80000
32Position CGraphic Designer3/4 New York Avenue55000
43Position DData Analyst3/2 San Francisco Way70000
54Position EWeb Developer2/7 London Street75000

Employee

idposition_idemployee_namehire_date
(→ Position.id)
11John Doe2021-01-01
22Jane Smith2021-02-01
33Alice Johnson2021-03-01
44Bob Brown2021-04-01
55Charlie Green2021-05-01