Relationships_MM.accdb
| DeptNum | DeptName | DeptHead |
| 24 | Finance | 8112 |
| 27 | Marketing | 2173 |
| 31 | Technology | 4519 |
| EmpID | DepNum | FirstName | LastName |
| 2173 | 27 | Barbara | Hennessey |
| 4519 | 31 | Lee | Noordsy |
| 8005 | 27 | Pat | Amidon |
| 8112 | 24 | Chris | Wandzell |
| StartDate | EndDate | EmploymentID | PositionID | EmplD |
| 12/14/11 | | 11111 | 2 | 2173 |
| 4/23/13 | | 22222 | 1 | 4519 |
| 11/11/07 | 4/22/13 | 33333 | 3 | 4519 |
| 6/5/12 | 8/25/13 | 44444 | 3 | 8005 |
| 7/2/10 | 6/4/12 | 55555 | 4 | 8005 |
| 12/15/12 | | 66666 | 1 | 8112 |
| 10/4/11 | 12/14/12 | 77777 | 2 | 8112 |
| PositionID | PossitionDesc | PayGrade |
| 1 | Director | 45 |
| 2 | Manager | 40 |
| 3 | Analyst | 30 |
| 4 | Clerk | 20 |
Canberk
