Employees

idnameposition
1John DoeSoftware Engineer
2Jane SmithData Analyst
3Michael JohnsonUI/UX Designer
4Emily DavisQA Tester
5David BrownDevOps Engineer

ProjectManagers

idemployeeIdprojectNameprojectDescriptionProject_ManagerProject_Duration_Estimate
(→ Employees.id)
11Web App DevelopmentDevelopment of an eCommerce web appTom Anderson3 weeks
22Mobile Application DevelopmentDevelopment of a mobile app for Android and iOS platformsLisa Thompson6 months
33CRM System ImplementationImplementation of a CRM system for sales and marketing teamsRobert Clark8 weeks
44Content Management SystemBuilding a content management system for website ownersMichelle Wilson4 weeks
55ERP IntegrationIntegrating various ERP systems within a companyChris Taylor10 weeks

BusinessAnalysts

idemployeeIdbusinessAreaanalysisTasksBusiness_AnalystProject_Duration_Estimate
(→ Employees.id)
11MarketingAnalyzing customer behavior and market trendsAnna Martinez4 weeks
22FinancePerforming financial analysis and forecastingSteven Harris5 weeks
33Human ResourcesEvaluating HR processes and policiesLaura King7 weeks
44OperationsOptimizing supply chain operationsKevin White6 weeks
55Product DevelopmentAssessing product viability and potential impact on marketNathan Garcia8 weeks

Technologies

idtechnologyName
1Python
2JavaScript
3React Native
4SQL Server
5Node.js

ProjectTechnologyMapping

idprojectIdtechId
(→ ProjectManagers.id)(→ Technologies.id)
111
212
323
434
545

Skills

idskillName
1Agile Methodologies
2Scrum
3Waterfall
4Git
5Test Automation

EmployeeSkillMapping

idempIdskillId
(→ Employees.id)(→ Skills.id)
111
222
333
444
555