## Experience

id | experience
--- | ---
1 | 5 years
2 | 10 years
3 | 3 years
4 | 6 months
5 | 2 years

## MarineBiologists

id | name | age | salary
--- | --- | --- | ---
(→ Experience.id) |  |  |
1 | John Doe | 30 | 70000.0
2 | Jane Smith | 35 | 80000.0
3 | Michael Johnson | 29 | 65000.0
4 | Emily Brown | 32 | 75000.0
5 | David Wilson | 28 | 60000.0

## Zoologists

id | name | age | salary
--- | --- | --- | ---
(→ Experience.id) |  |  |
1 | Lisa Thompson | 27 | 68000.0
2 | Robert Martin | 31 | 72000.0
3 | William Taylor | 26 | 62000.0
4 | Amy Clark | 29 | 69000.0
5 | Steven Davis | 25 | 58000.0

## Companies

id | companyName | location
--- | --- | ---
1 | Ocean Life Inc. | Los Angeles
2 | Wildlife Exploration LLC | New York
3 | Animal Research Corporation | Chicago
4 | Eco Discovery Group | Houston
5 | Nature Conservation Association | Philadelphia

## Jobs

jobId | jobTitle | description | postedDate | marineBiologist | zoologist | foreignKeyID
--- | --- | --- | --- | --- | --- | ---
(→ MarineBiologists.id) |  |  |  |  |  | (→ Companies.id)
1 | Marine Biologist Position | Study and protect marine life. | 2021-01-01 | 1 | 0 | 1
2 | Zoologist Position | Study and conserve various species of animals. | 2021-01-02 | 0 | 1 | 2
3 | Research Scientist | Conduct research on animal behavior. | 2021-01-03 | 1 | 1 | 3
4 | Curator | Manage a collection of live animals and plants. | 2021-01-04 | 1 | 1 | 4
5 | Field Technician | Assist researchers in field studies. | 2021-01-05 | 0 | 0 | 5

## Applications

applicationId | applicantName | appliedJobId | appliedCompanyId | applyDate
--- | --- | --- | --- | ---
|  | (→ Jobs.jobId) | (→ Companies.id) |
1 | John Smith | 1 | 1 | 2021-01-06
2 | Alice Jones | 2 | 2 | 2021-01-07
3 | Bob Williams | 3 | 3 | 2021-01-08
4 | Carol Brown | 4 | 4 | 2021-01-09
5 | Daniel Davis | 5 | 5 | 2021-01-10