| 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) | ||||
| 1 | 1 | 3 | Python, Java, C++ | Eclipse, IntelliJ |
| 2 | 2 | 6 | JavaScript, Ruby, Swift | Sublime Text, Atom |
| 3 | 3 | 8 | C#, PHP, Go | Visual Studio Code, PhpStorm |
| 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 |
| 4 | 4 | 4 | Pandas, NumPy, SciPy | PostgreSQL, MariaDB, Cassandra |
| 5 | 5 | 6 | TensorFlow, PyTorch, Keras | Amazon SageMaker, Google Cloud ML, Microsoft Azure ML |