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 |