Hello Guys!
I want to make a "Log book" say for a Railway, Transport company, airline etc
Now I want to maintain a complete record of their move, maintenance, drivers scheduling and even of those transport of other companies which are arriving at my bus station or you say air planes on my air port.
Now which type of data I want to keep for a record.
Airplane A
Move From Airport#1 to Airport#2 Time Start 0500 Arrival Time-------
--->Now another Move entry comes in
Airplane B
Move From Airport#3 to Airport#4 Time Start 0600 Arrival Time-------
--->Now Maintenance entry comes in
Airplane C
Airplane C UnServiceable Time Start 0700 Serviceable Time-------
Reason:_________
Say after 20 entries Airplane B reaches its destination at 1100 hrs
Airplane C becomes serviceable at 1300 hrs
and its Journey starts at 1330 hrs Arrival Time -------
and after 25 different entries Airplane A also reaches its destination at 1400 hrs. and becomes unavailable start time 1430 due to weather, available Time ---------- will be written when when it will get available for flying.
Question:
1. How should I update record of move, unserviceability or non availability of air planes as there are many entries in between them. There may be other entries of same airplane in between its move, maintenance etc.
I want to keep every thing logged so that I can get consolidated report of all under different headings, Individual airplane consolidated report and under different headings etc in between two dates, from specific time and date etc
Looking forward for help and suggestions
I want to make a "Log book" say for a Railway, Transport company, airline etc
Now I want to maintain a complete record of their move, maintenance, drivers scheduling and even of those transport of other companies which are arriving at my bus station or you say air planes on my air port.
Now which type of data I want to keep for a record.
Airplane A
Move From Airport#1 to Airport#2 Time Start 0500 Arrival Time-------
--->Now another Move entry comes in
Airplane B
Move From Airport#3 to Airport#4 Time Start 0600 Arrival Time-------
--->Now Maintenance entry comes in
Airplane C
Airplane C UnServiceable Time Start 0700 Serviceable Time-------
Reason:_________
Say after 20 entries Airplane B reaches its destination at 1100 hrs
Airplane C becomes serviceable at 1300 hrs
and its Journey starts at 1330 hrs Arrival Time -------
and after 25 different entries Airplane A also reaches its destination at 1400 hrs. and becomes unavailable start time 1430 due to weather, available Time ---------- will be written when when it will get available for flying.
Question:
1. How should I update record of move, unserviceability or non availability of air planes as there are many entries in between them. There may be other entries of same airplane in between its move, maintenance etc.
I want to keep every thing logged so that I can get consolidated report of all under different headings, Individual airplane consolidated report and under different headings etc in between two dates, from specific time and date etc
Looking forward for help and suggestions