## Employees

ID | Name | Position
--- | --- | ---
1 | John Doe | Software Engineer
2 | Jane Smith | Data Scientist
3 | Michael Johnson | Product Manager
4 | Emily Davis | UX Designer

## ProjectManagers

ManagerID
(→ Employees.ID)
1
2
3
4

## BusinessAnalysts

AnalystID
(→ Employees.ID)
1
2
3
4

## Projects

ProjectID | DurationEstimate | ProjectManagerID | BusinessAnalystID
--- | --- | --- | ---
|  | (→ ProjectManagers.ManagerID) | (→ BusinessAnalysts.AnalystID)
1 | 4 weeks | 1 | 1
2 | 6 months | 2 | 2
3 | 8 weeks | 3 | 3
4 | 10 days | 4 | 4
5 | 3 months | 2 | 3
6 | 2 weeks | 1 | 1
7 | 5 weeks | 3 | 4