## Education

ID | Degree
--- | ---
1 | Doctor of Dental Surgery
2 | Master of Science in Dentistry

## Jobs

ID | Title | Description | Location | CompanyName | PostedDate | FullTimePartTime
--- | --- | --- | --- | --- | --- | ---
1 | Orthodontist | An experienced Orthodontist required. | New York | ABCD Inc | 2024-03-13 12:00:50 | Full Time
2 | General Dentist | A General Dentist needed for our clinic. | California | XYZ Clinic | 2024-03-13 12:00:50 | Full Time
3 | Periodontist | A qualified Periodontist wanted for our hospital. | Texas | LMN Hospital | 2024-03-13 12:00:50 | Full Time
4 | Dental Assistant | Experienced Dental Assistants needed. | Florida | OPQ Clinic | 2024-03-13 12:00:50 | Part Time

## Employees

ID | Name | Email | PhoneNumber | HireDate | JobID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Jobs.ID)
1 | John Doe | john@gmail.com | 1234567890 | 2024-03-13 12:00:50 | 1
2 | Jane Smith | jane@yahoo.com | 9876543210 | 2024-03-13 12:00:50 | 2
3 | Michael Johnson | mike@outlook.com | 5555555555 | 2024-03-13 12:00:50 | 3
4 | Emma Williams | emma@hotmail.com | 7777777777 | 2024-03-13 12:00:50 | 4

## Dentists

ID | FirstName | LastName | DentalSpecialty | JoiningDate | EducationID
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Education.ID)
1 | Alice | Smith | Orthodontist | 2024-03-13 12:00:50 | 1
2 | Bob | Johnson | Orthodontist | 2024-03-13 12:00:50 | 2
3 | Charlie | Williams | Periodontist | 2024-03-13 12:00:50 | 1
4 | David | Brown | Periodontist | 2024-03-13 12:00:50 | 2