## Employees

id | name | position
--- | --- | ---
1 | John Doe | Software Engineer
2 | Jane Smith | Data Analyst
3 | Michael Johnson | UI/UX Designer
4 | Emily Davis | QA Tester
5 | David Brown | DevOps Engineer

## ProjectManagers

id | employeeId | projectName | projectDescription | Project_Manager | Project_Duration_Estimate
--- | --- | --- | --- | --- | ---
| (→ Employees.id) |  |  |  |
1 | 1 | Web App Development | Development of an eCommerce web app | Tom Anderson | 3 weeks
2 | 2 | Mobile Application Development | Development of a mobile app for Android and iOS platforms | Lisa Thompson | 6 months
3 | 3 | CRM System Implementation | Implementation of a CRM system for sales and marketing teams | Robert Clark | 8 weeks
4 | 4 | Content Management System | Building a content management system for website owners | Michelle Wilson | 4 weeks
5 | 5 | ERP Integration | Integrating various ERP systems within a company | Chris Taylor | 10 weeks

## BusinessAnalysts

id | employeeId | businessArea | analysisTasks | Business_Analyst | Project_Duration_Estimate
--- | --- | --- | --- | --- | ---
| (→ Employees.id) |  |  |  |
1 | 1 | Marketing | Analyzing customer behavior and market trends | Anna Martinez | 4 weeks
2 | 2 | Finance | Performing financial analysis and forecasting | Steven Harris | 5 weeks
3 | 3 | Human Resources | Evaluating HR processes and policies | Laura King | 7 weeks
4 | 4 | Operations | Optimizing supply chain operations | Kevin White | 6 weeks
5 | 5 | Product Development | Assessing product viability and potential impact on market | Nathan Garcia | 8 weeks

## Technologies

id | technologyName
--- | ---
1 | Python
2 | JavaScript
3 | React Native
4 | SQL Server
5 | Node.js

## ProjectTechnologyMapping

id | projectId | techId
--- | --- | ---
| (→ ProjectManagers.id) | (→ Technologies.id)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 3 | 4
5 | 4 | 5

## Skills

id | skillName
--- | ---
1 | Agile Methodologies
2 | Scrum
3 | Waterfall
4 | Git
5 | Test Automation

## EmployeeSkillMapping

id | empId | skillId
--- | --- | ---
| (→ Employees.id) | (→ Skills.id)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5