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 |