Employee
id | firstName | lastName | jobTitle | gender |
1 | John | Doe | Software Engineer | Male |
2 | Jane | Smith | Data Scientist | Female |
3 | Alice | Brown | Project Manager | Female |
4 | Charlie | White | Quality Analyst | Male |
5 | David | Black | HR Specialist | Male |
6 | Eva | Green | Marketing Executive | Female |
Research_Scientist
id | yearsOfExperience | publications |
(→ Employee.id) | | |
1 | 7 | 10 |
2 | 3 | 2 |
3 | 9 | 8 |
4 | 5 | 6 |
5 | 2 | 1 |
Laboratory_Technician
id | experienceInYears | certifications |
(→ Employee.id) | | |
1 | 5 | 3 |
2 | 4 | 2 |
3 | 6 | 4 |
4 | 3 | 1 |
5 | 2 | 0 |
Skills
id | skillName | proficiencyLevel |
(→ Employee.id) | | |
1 | Python Programming | 8 |
2 | JavaScript Development | 7 |
3 | SQL Querying | 9 |
4 | Web Design | 6 |
5 | Database Management | 8 |
Projects
id | projectName | startDate | endDate |
(→ Employee.id) | | | |
1 | Project Alpha | 2020-01-01 | 2020-12-31 |
2 | Project Beta | 2019-01-01 | 2019-12-31 |
3 | Project Gamma | 2021-01-01 | 2021-12-31 |
4 | Project Delta | 2020-01-01 | 2020-12-31 |
5 | Project Epsilon | 2019-01-01 | 2019-12-31 |
Education
id | degreeType | institution | graduationYear |
(→ Employee.id) | | | |
1 | PhD | University of Science | 2018 |
2 | BS | Tech University | 2015 |
3 | MS | Knowledge Institute | 2017 |
4 | BA | Life College | 2014 |
5 | MA | Wisdom Academy | 2016 |