PRP201c_-_SU_2024_-_PE1_2531.webp
H

PRP201c_-_SU_2024_-_PE1_2531.webp

Result of the program:
Content of the input file (integers_data.txt):
1 2 3 4 5 6 7 8 9 10
Content of the output file (even_numbers.txt):
2 4 6 8 10
Exercise 3: (4 marks)
Write a program that implements the following tasks:
• 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

+ 100%
Zoom
Close
Chưa có bình luận nào.

Thông tin

Category
PRP201c
Thêm bởi
Hạnh Dung1
Ngày thêm
Lượt xem
990
Lượt bình luận
0
Rating
0.00 star(s) 0 đánh giá

Image metadata

Filename
PRP201c_-_SU_2024_-_PE1_2531.webp
File size
250.6 KB
Dimensions
2560px x 1269px

Share this media

Back
Bên trên Bottom