• Read employee, project, and employee-project relationship information from the respective CSV files (employees.csv, projects.csv, and employee_projects.csv).
• Insert the employee, project, and employee-project data into the tables of a database named company_projects.sqlite. Ensure no duplicate entries for employees and projects.
• Ask the user to enter a name of an employee and print a list of projects the employee is working on. If no projects are found, print "No projects found for the employee".
Content of employees.csv file:
EmployeeID, EmployeeName
E1, John
E2, Jane
E3, Bob
Content of projects.csv file:
ProjectID, ProjectName
P1, Project A
P2, Project B
P3, Project C
Content of employee_projects.csv file:
EmployeeID, ProjectID
E1, P1
E1, P2
E2, P3
Zoom
+ 100%
Close
