## Company

id | name | location
--- | --- | ---
1 | Company A | Location A
2 | Company B | Location B

## Employee

id | firstName | lastName | companyId
--- | --- | --- | ---
|  |  | (→ Company.id)
1 | John | Smith | 1
2 | Jane | Doe | 2

## Education

id | level | employeeId
--- | --- | ---
|  | (→ Employee.id)
1 | Doctor of Dental Surgery | 1
2 | Bachelor of Science | 1

## Specialty

id | type | employeeId
--- | --- | ---
|  | (→ Employee.id)
1 | Orthodontics | 1
2 | Endodontics | 2

## Dentists

id | dentalCareer | educationLevel | specialtyType | employeeId
--- | --- | --- | --- | ---
|  |  |  | (→ Employee.id)
1 | Orthodontist | Doctor of Dental Surgery | Orthodontics | 1
2 | Orthodontist | Master of Science | Orthodontics | 2
3 | Periodontist | Doctor of Dental Surgery | Periodontics | 3
4 | Periodontist | Bachelor of Science | Periodontics | 4