ID | Name | Position |
---|---|---|
1 | John Doe | Software Engineer |
2 | Jane Smith | Data Scientist |
3 | Michael Johnson | Product Manager |
4 | Emily Davis | UX Designer |
ManagerID |
---|
(→ Employees.ID) |
1 |
2 |
3 |
4 |
AnalystID |
---|
(→ Employees.ID) |
1 |
2 |
3 |
4 |
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 |