PRP201c_-_SP_2022_-_Block5_-_PE_131.webp
Kim Anh1

PRP201c_-_SP_2022_-_Block5_-_PE_131.webp

  • Media owner Kim Anh1
  • Ngày thêm
3. (4 points) Write a program to manage individual tax of employees including employee'name, rate, salary, total and tax. The program reads data from the file "Data.txt" and save to the database file employee.sqlite using the following table schema.
employee (Name, rate, salary, Total, Tax)
Where:
Total = rate * salary
Tax = Total * 5% if Total >=9000000, otherwise, Tax = 0.
The program prints the employee list whose rate > 3 and sorted in ascending order by name. The output should be as follows:
employee list:
Name
rate
salary
Nga
Phi
2.34
3.0
Loi
4.32
Total
1490000
3,486,600
3490000
5490000
10,470,000
Tax
0.0
1,047,000
23,716,800
2,371,680
Chưa có bình luận nào.

Thông tin

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

Share this media

Back
Bên trên Bottom