Companies

idnamelocation
1Ocean LifeSan Francisco
2Wild WorldNew York
3Nature ExplorersLos Angeles
4Sea DiscoveriesMiami
5Earth GuardiansChicago

Jobs

idtitledescriptionpostedDatecompanyId
(→ Companies.id)
1 Marine BiologistConduct research on marine life.2024-03-13 12:20:041
2 ZoologistStudy animals and their habitats.2024-03-13 12:20:042
3 Conservation OfficerProtect endangered species.2024-03-13 12:20:043
4 AquaristMaintain aquatic exhibits.2024-03-13 12:20:044
5 Environmental EducatorTeach about environmental issues.2024-03-13 12:20:045

AnimalStudies

idcareer
1Marine Biologist
2Zoologist
3Veterinarian
4Wildlife Rehabilitator
5Ecologist

ExperienceLevels

idlevel
15 years
27 years
33 years
410 years
58 years

JobRequirements

idjobIdanimalCareerIdexperienceLevelId
(→ Jobs.id)(→ AnimalStudies.id)(→ ExperienceLevels.id)
1111
2112
3221
4233
5344

Applicants

idnameemailphoneNumberapplicationDate
1John Doejohn@example.com555-123-45672024-03-13 12:20:04
2Jane Smithjane@example.com555-987-65432024-03-13 12:20:04
3Alice Johnsonalice@example.com555-321-98762024-03-13 12:20:04
4Bob Brownbob@example.com555-555-55552024-03-13 12:20:04
5Carol Whitecarol@example.com555-111-22222024-03-13 12:20:04

ApplicationJobs

applicantIdjobIddateApplied
(→ Applicants.id)(→ Jobs.id)
112022-01-01
122022-01-15
212022-02-01
222022-02-15
312022-03-01