| CompanyID | Name | Address | PhoneNumber |
|---|---|---|---|
| 1 | TechCorp | 123 Tech St. | +123456789 |
| 2 | MedCo | 456 Med Ave. | +987654321 |
| 3 | FinCorp | 789 Fin Blvd., | +321654897 |
| 4 | EduInc | 123 Edu St. | +543219876 |
| 5 | GovAgency | 456 Gov Plaza | +789654321 |
| DepartmentID | Name | Description | LocationID |
|---|---|---|---|
| (→ Companies.CompanyID) | |||
| 1 | Engineering | Research and Development | 1 |
| 2 | Marketing | Brand Management | 1 |
| 3 | HR | Recruitment and Onboarding | 2 |
| 4 | IT | System Administration | 2 |
| 5 | Accounting | Budget and Audit | 3 |
| 6 | Academics | Curriculum Design | 4 |
| 7 | Policy | Legislative Affairs | 5 |
| PositionID | Title | Salary | DepartmentID |
|---|---|---|---|
| (→ Departments.DepartmentID) | |||
| 1 | Software Engineer | 80000 | 1 |
| 2 | Product Manager | 90000 | 1 |
| 3 | HR Specialist | 60000 | 2 |
| 4 | Network Administrator | 70000 | 2 |
| 5 | Accountant | 50000 | 3 |
| 6 | Professor | 85000 | 4 |
| 7 | Policy Analyst | 75000 | 5 |
| EmployeeID | FirstName | LastName | BirthDate | HireDate | PositionID | Mental_Health_Career | Clinic |
|---|---|---|---|---|---|---|---|
| (→ Positions.PositionID) | |||||||
| 1 | John | Doe | 1990-01-01 | 2015-06-01 | 3 | Psychologist | Harmony Wellness Center |
| 2 | Jane | Smith | 1985-01-01 | 2017-08-01 | 4 | Psychologist | Serenity Center |
| 3 | Alice | Jackson | 1988-01-01 | 2018-12-01 | 1 | Psychiatrist | Harmony Wellness Center |
| 4 | Tom | Lee | 1992-01-01 | 2019-05-01 | 2 | Psychiatrist | Peaceful Haven |