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 |