Microsoft Access
Canberk
Relationships_OneToMany.accdb| DeptNum | DeptName | DeptHead |
|---|---|---|
| 27 | Marketing | 2173 |
| 31 | Technology | 4519 |
| 24 | Finance | 8112 |
| EmpID | DepNum | FirstName | LastName |
|---|---|---|---|
| 2173 | 27 | Barbara | Hennessey |
| 4519 | 31 | Lee | Noordsy |
| 8005 | 27 | Pat | Amidon |
| 8112 | 24 | Chris | Wandzell |
| PositionID | PossitionDesc | PayGrade |
|---|---|---|
| 1 | Director | 45 |
| 2 | Manager | 40 |
| 3 | Analyst | 30 |
| 4 | Clerk | 20 |
