I have create Bus Reservation.dbf, its having five fields namely 1.name 2.date of reservation 3.class 4.No of tickets 5. Bus No.

No of tickets for a date for First class = 30

No of tickets for a date for 2nd class = 50

I want to wite a source code for a Bus reservation in such away, everyday the Accomodation opens with a fixed number of tickets
(above I have mentioned) that has to be repeated every day so that the process will be repeated infinitely. i e on all day.

suppose the passenger want to cancell the reservation tickets the cancelled tickets were added in to the reservation table.

for example the passenger "X" had reserved 5 tickets for first class tickets and he want to cancell the tickets then cancelled tickets were added in to first class field.

for example the passenger "X" had reserved 5 tickets for second class tickets and he want to cancell the tickets then cancelled tickets were added in to second class field.


How to write code?