Employee

EmpIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceBrownalice.brown@example.com
4BobWhitebob.white@example.com
5MikeBlackmike.black@example.com

Position

PosIDTitleSalary
1Software Engineer80000.0
2Web Developer70000.0
3Data Analyst60000.0
4Project Manager90000.0
5Product Designer120000.0

Department

DeptIDNameLocation
1Research and DevelopmentNew York
2DesignSan Francisco
3MarketingLos Angeles
4Human ResourcesChicago
5FinanceAtlanta

Employment

EmpIDPosIDDeptIDHireDate
(→ Employee.EmpID)(→ Position.PosID)(→ Department.DeptID)
1112024-03-13 19:18:11
2232024-03-13 19:18:11
3322024-03-13 19:18:11
4442024-03-13 19:18:11
5512024-03-13 19:18:11

Engineers

EmpIDYearsExperience
(→ Employee.EmpID)
15
23
37
410
52

Architects

EmpIDProjectCount
(→ Employee.EmpID)
12
24
33
46
51