Companies

CompanyIDNameAddressPhoneNumber
1TechCorp123 Tech St.+123456789
2MedCo456 Med Ave.+987654321
3FinCorp789 Fin Blvd.,+321654897
4EduInc123 Edu St.+543219876
5GovAgency456 Gov Plaza+789654321

Departments

DepartmentIDNameDescriptionLocationID
(→ Companies.CompanyID)
1EngineeringResearch and Development1
2MarketingBrand Management1
3HRRecruitment and Onboarding2
4ITSystem Administration2
5AccountingBudget and Audit3
6AcademicsCurriculum Design4
7PolicyLegislative Affairs5

Positions

PositionIDTitleSalaryDepartmentID
(→ Departments.DepartmentID)
1Software Engineer800001
2Product Manager900001
3HR Specialist600002
4Network Administrator700002
5Accountant500003
6Professor850004
7Policy Analyst750005

Employees

EmployeeIDFirstNameLastNameBirthDateHireDatePositionIDMental_Health_CareerClinic
(→ Positions.PositionID)
1JohnDoe1990-01-012015-06-013PsychologistHarmony Wellness Center
2JaneSmith1985-01-012017-08-014PsychologistSerenity Center
3AliceJackson1988-01-012018-12-011PsychiatristHarmony Wellness Center
4TomLee1992-01-012019-05-012PsychiatristPeaceful Haven