## Companies

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

## Departments

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

## Positions

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

## Employees

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