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 |