| id | name |
|---|---|
| 1 | Junior |
| 2 | Middle |
| 3 | Senior |
| id | departmentName |
|---|---|
| 1 | IT |
| 2 | Finance |
| 3 | Human Resources |
| id | positionName |
|---|---|
| 1 | Manager |
| 2 | Engineer |
| 3 | Specialist |
| 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 |
| 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 |
| 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 |