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 |