Employees

IDNamePosition
1John DoeSoftware Engineer
2Jane SmithData Scientist
3Michael JohnsonProduct Manager
4Emily DavisUX Designer

ProjectManagers

ManagerID
(→ Employees.ID)
1
2
3
4

BusinessAnalysts

AnalystID
(→ Employees.ID)
1
2
3
4

Projects

ProjectIDDurationEstimateProjectManagerIDBusinessAnalystID
(→ ProjectManagers.ManagerID)(→ BusinessAnalysts.AnalystID)
14 weeks11
26 months22
38 weeks33
410 days44
53 months23
62 weeks11
75 weeks34