## Grade

id | name
--- | ---
1 | Junior
2 | Middle
3 | Senior

## Department

id | departmentName
--- | ---
1 | IT
2 | Finance
3 | Human Resources

## Position

id | positionName
--- | ---
1 | Manager
2 | Engineer
3 | Specialist

## Employee

id | firstName | lastName | gradeId | departmentId | positionId
--- | --- | --- | --- | --- | ---
|  |  | (→ Grade.id) | (→ Department.id) | (→ Position.id)
1 | John | Smith | 1 | 1 | 2
2 | Jane | Doe | 2 | 1 | 3
3 | Bob | Builder | 3 | 2 | 1
4 | Alice | Wonderland | 1 | 3 | 2
5 | Charlie | Brown | 2 | 3 | 1

## Software_Developer

id | employeeId | experience | programmingLanguages | toolsUsed
--- | --- | --- | --- | ---
| (→ Employee.id) |  |  |
4 | 4 | 5 | Kotlin, Rust, Scala | Android Studio, Vim
5 | 5 | 7 | Perl, Objective-C, Fortran | Emacs, Xcode

## Data_Analyst

id | employeeId | experience | analyticalTools | dataSources
--- | --- | --- | --- | ---
| (→ Employee.id) |  |  |
1 | 1 | 5 | R, SAS, Excel | SQL Server, MySQL, Oracle
2 | 2 | 9 | Matlab, Stata, SPSS | SAP HANA, Teradata, MongoDB
3 | 3 | 7 | Tableau, PowerBI, QlikView | Google Analytics, Adobe Analytics, Salesforce