| CompanyID | Name | Location |
|---|---|---|
| 1 | TechCorp | New York |
| 2 | MedicalInnovations | San Francisco |
| DepartmentID | Name | Description | CompanyID |
|---|---|---|---|
| (→ Companies.CompanyID) | |||
| 1 | Engineering | Developing new technologies. | 1 |
| 2 | Biotechnology | Researching genetic engineering. | 2 |
| JobID | Title | Salary | StartDate | EndDate | DepartmentID |
|---|---|---|---|---|---|
| (→ Departments.DepartmentID) | |||||
| 1 | Software Engineer | 75000 | 2023-01-01 | None | 1 |
| 2 | Molecular Biologist | 65000 | 2023-01-01 | None | 2 |
| 3 | Research Scientist | 80000 | 2023-01-01 | None | 1 |
| 4 | Research Scientist | 80000 | 2023-01-01 | None | 2 |
| 5 | Laboratory Technician | 60000 | 2023-01-01 | None | 2 |
| ApplicationID | FirstName | LastName | PhoneNumber | Gender | JobID | |
|---|---|---|---|---|---|---|
| (→ Jobs.JobID) | ||||||
| 1 | John | Doe | john.doe@example.com | +1234567890 | male | 1 |
| 2 | Jane | Smith | jane.smith@example.com | +1234567890 | female | 1 |
| 3 | Alice | Brown | alice.brown@example.com | +1234567890 | female | 2 |
| 4 | Robert | Green | robert.green@example.com | +1234567890 | male | 3 |
| 5 | Charlotte | White | charlotte.white@example.com | +1234567890 | female | 4 |
| 6 | William | Black | william.black@example.com | +1234567890 | male | 5 |