Education

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

Specialization

idspeciality_name
1Orthodontics
2Prosthodontics
3Endodontics
4Oral and Maxillofacial Surgery
5Pediatric Dentistry

Orthodontists

idnameeducation_idspecialty_id
(→ Education.id)(→ Specialization.id)
1John Doe11
2Jane Smith22
3Michael Johnson31
4Emily Davis42
5William Brown53

Periodontists

idnameeducation_idspecialty_id
(→ Education.id)(→ Specialization.id)
1Anna Martinez14
2David Miller23
3Emma Wilson35
4Charlie Thompson44
5Rachel Taylor51