Write a small database using Delphi and Oracle
Employer
[no-member:pro]Viktor[/no-member:pro]Viktor
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentprepayment is possible
Payment methodsElectronic money
Acceptance of requestsclosed
Project description
DB task accounting (training program)
Each task has parameters: number, description, planned number of hours, state.
A number is a unique number that a task receives automatically when created.
- Planned number of hours - number
- State - field that takes the values of "In queue", "Consent" ", "Executed" ", "Confirmed" ", "Completed" ".
The state values change sequentially, the only exception being the "Confirmed" state; the task may return to the "Executed" state.
You need to create an interface that works with this data. It is also necessary that the form displays for each task “Past time in hours”, which is considered as the sum of time that the task was in the state “Agreement” and “Executed”. Only working days from 9 to 18 are taken into account, and 8 working hours are included.
Time is 3 days.
Each task has parameters: number, description, planned number of hours, state.
A number is a unique number that a task receives automatically when created.
- Planned number of hours - number
- State - field that takes the values of "In queue", "Consent" ", "Executed" ", "Confirmed" ", "Completed" ".
The state values change sequentially, the only exception being the "Confirmed" state; the task may return to the "Executed" state.
You need to create an interface that works with this data. It is also necessary that the form displays for each task “Past time in hours”, which is considered as the sum of time that the task was in the state “Agreement” and “Executed”. Only working days from 9 to 18 are taken into account, and 8 working hours are included.
Time is 3 days.
