| 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 |
| 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 |
| 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 |
| id | technologyName |
|---|---|
| 1 | Python |
| 2 | JavaScript |
| 3 | React Native |
| 4 | SQL Server |
| 5 | Node.js |
| id | projectId | techId |
|---|---|---|
| (→ ProjectManagers.id) | (→ Technologies.id) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 3 |
| 4 | 3 | 4 |
| 5 | 4 | 5 |
| id | skillName |
|---|---|
| 1 | Agile Methodologies |
| 2 | Scrum |
| 3 | Waterfall |
| 4 | Git |
| 5 | Test Automation |
| id | empId | skillId |
|---|---|---|
| (→ Employees.id) | (→ Skills.id) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 4 | 4 | 4 |
| 5 | 5 | 5 |