Company
| id | name |
| 1 | TechCorp |
| 2 | HealthPlus |
| 3 | GreenTech |
| 4 | SoftWare |
| 5 | MedicalPioneers |
Department
| id | companyId | departmentName |
| (→ Company.id) | |
| 1 | 1 | Biotechnology |
| 2 | 2 | Chemistry |
| 3 | 3 | Physics |
| 4 | 4 | Computer Science |
| 5 | 5 | Mathematics |
PositionType
| id | typeName |
| 1 | Full Time |
| 2 | Part Time |
| 3 | Contractual |
| 4 | Internship |
| 5 | Volunteering |
LabPosition
| id | positionTypeId | labPosition | gender | minimumEducation | experienceInYears | salaryRange |
| (→ PositionType.id) | | | | | |
| 1 | 1 | Research Scientist | Female | PhD | 5 | 60k - 90k |
| 2 | 1 | Research Scientist | Male | PhD | 7 | 80k - 110k |
| 3 | 2 | Laboratory Technician | Female | BSc | 3 | 40k - 60k |
| 4 | 2 | Laboratory Technician | Male | BSc | 4 | 50k - 70k |
| 5 | 3 | Data Analyst | Non-binary | MS | 2 | 60k - 80k |
Employee
| id | firstName | lastName | dateOfBirth | email | phoneNumber | hireDate | jobTitle | departmentId | gender |
| | | | | | | | (→ Department.id) | |
| 1 | John | Smith | 1990-01-15 | johnsmith@email.com | +1 (234) 567-8910 | 2021-06-01 | Research Scientist | 1 | Male |
| 2 | Jane | Doe | 1988-03-20 | janedoe@email.com | +1 (123) 456-7890 | 2021-07-01 | Laboratory Technician | 2 | Female |
| 3 | Tom | Hanks | 1985-09-05 | thomhanks@email.com | +1 (345) 678-9012 | 2021-08-01 | Engineer | 3 | Male |
| 4 | Alice | Williams | 1992-11-10 | alicewilliams@email.com | +1 (456) 789-0123 | 2021-09-01 | Analyst | 4 | Female |
| 5 | Chris | Evans | 1989-06-25 | chrisevans@email.com | +1 (567) 890-1234 | 2021-10-01 | Manager | 5 | Male |