| ID | Degree |
|---|---|
| 1 | Doctor of Dental Surgery |
| 2 | Master of Science in Dentistry |
| ID | SpecializedIn |
|---|---|
| 1 | Pediatric Dentistry |
| 2 | Endodontics |
| 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 |
| ID | Name | 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 |
| ID | FirstName | LastName | DentalSpecialty | JoiningDate | EducationID | SpecializationID |
|---|---|---|---|---|---|---|
| (→ Education.ID) | (→ Specialization.ID) | |||||
| 1 | Alice | Smith | Orthodontist | 2024-03-13 12:00:50 | 1 | 1 |
| 2 | Bob | Johnson | Orthodontist | 2024-03-13 12:00:50 | 2 | 2 |
| 3 | Charlie | Williams | Periodontist | 2024-03-13 12:00:50 | 1 | 1 |
| 4 | David | Brown | Periodontist | 2024-03-13 12:00:50 | 2 | 2 |