## Education

id | degree_name
--- | ---
1 | Doctor of Dental Surgery
2 | Master of Science in Dentistry
3 | Bachelor of Dental Surgery
4 | Diploma in Dental Technology
5 | Associate Degree in Applied Sciences - Dental Assisting

## Specialization

id | speciality_name
--- | ---
1 | Orthodontics
2 | Prosthodontics
3 | Endodontics
4 | Oral and Maxillofacial Surgery
5 | Pediatric Dentistry

## Orthodontists

id | name | education_id | specialty_id
--- | --- | --- | ---
|  | (→ Education.id) | (→ Specialization.id)
1 | John Doe | 1 | 1
2 | Jane Smith | 2 | 2
3 | Michael Johnson | 3 | 1
4 | Emily Davis | 4 | 2
5 | William Brown | 5 | 3

## Periodontists

id | name | education_id | specialty_id
--- | --- | --- | ---
|  | (→ Education.id) | (→ Specialization.id)
1 | Anna Martinez | 1 | 4
2 | David Miller | 2 | 3
3 | Emma Wilson | 3 | 5
4 | Charlie Thompson | 4 | 4
5 | Rachel Taylor | 5 | 1