In order to simplify life for any future Webmaster (if there is ever one...), we have created a set of simple pages to add new data to the Database. That would allow to make new entries to the database without the need to learn how to use sophisiticatted programs like PhpMyAdmin.
Such sophisticated programs are more complete, more useful but require a lot of learning and of practice to be able to get full results.
The other side of the coin is that a simplifed system will lack all the bells and wistles of those programs, especially the possibilities of editing, deleting and above all to correct mistakes, errors and/or typos.
That is why, at each step, there will be a reminder to check and recheck all entries before they are committed the Form by pressing the SUBMIT button.
The Database consists of 2 tables:
the DATA table named: "RTW", and
the RELATIONSHIP or DISTRIBUTION table named: "RTW2_2".
If one Pilot had done only one Flight, things would be very simple but as several persons can be in one flight and some can have done several flights, a DISTRIBUTION or RELATIONSHIP table is needed. It will point the name of each person to their respective flight. That is the role of the table "RTW2_2".
Example:
(In this example all names and numbers are fictitious and have no connection to the Database).
In the following example, there are:
4 persons in Flight Number 1000
2 persons in Flight Number 1001. and
only 1 person in Flight Number 1002.
John White was in Flight Number 1000
Peter Green was also in Fligh Number 1000
John Black was also in Flight Number 1000
Mary Rose was also in Flight Number 1000
Mary Rose was also in Flight Number 1001
Mary Poppins was in Flight Number 1001
Jiminy Cricket was alone in Flight Number 1002
From this example, we can see that each name must point to a Flight, but that Mary Rose needs 2 separate entries,
one pointing to Flight 1000 and
one pointing to Flight 1001.
Meaning table 'RTW' has 3 entries, while table 'RTW2_2' has 7 entries.
In each table, each entry has a successive number:
in table 'RTW 'ist is called: Flight Number or Record Number and
in table R'TW2_2' it is called ID.
For each table, the last RECORD NUMBER and ID already used is given. The RECORD_NUMBER or ID for the new entry is that RECORD-NUMBER or ID incremented by +1.
Note that in this context, the words: FLIGHT_NUMBER and RECORD_NUMBER are identical.
Adding new Data into the Database is done in TWO steps:
Step ONE: Data is added to the main table 'RTW',
Step TWO: Data is added to the Distribution or Relationship table: 'RTW2_2'.
Such sophisticated programs are more complete, more useful but require a lot of learning and of practice to be able to get full results.
The other side of the coin is that a simplifed system will lack all the bells and wistles of those programs, especially the possibilities of editing, deleting and above all to correct mistakes, errors and/or typos.
That is why, at each step, there will be a reminder to check and recheck all entries before they are committed the Form by pressing the SUBMIT button.
The Database consists of 2 tables:
the DATA table named: "RTW", and
the RELATIONSHIP or DISTRIBUTION table named: "RTW2_2".
If one Pilot had done only one Flight, things would be very simple but as several persons can be in one flight and some can have done several flights, a DISTRIBUTION or RELATIONSHIP table is needed. It will point the name of each person to their respective flight. That is the role of the table "RTW2_2".
Example:
(In this example all names and numbers are fictitious and have no connection to the Database).
In the following example, there are:
4 persons in Flight Number 1000
2 persons in Flight Number 1001. and
only 1 person in Flight Number 1002.
John White was in Flight Number 1000
Peter Green was also in Fligh Number 1000
John Black was also in Flight Number 1000
Mary Rose was also in Flight Number 1000
Mary Rose was also in Flight Number 1001
Mary Poppins was in Flight Number 1001
Jiminy Cricket was alone in Flight Number 1002
From this example, we can see that each name must point to a Flight, but that Mary Rose needs 2 separate entries,
one pointing to Flight 1000 and
one pointing to Flight 1001.
Meaning table 'RTW' has 3 entries, while table 'RTW2_2' has 7 entries.
In each table, each entry has a successive number:
in table 'RTW 'ist is called: Flight Number or Record Number and
in table R'TW2_2' it is called ID.
For each table, the last RECORD NUMBER and ID already used is given. The RECORD_NUMBER or ID for the new entry is that RECORD-NUMBER or ID incremented by +1.
Note that in this context, the words: FLIGHT_NUMBER and RECORD_NUMBER are identical.
Adding new Data into the Database is done in TWO steps:
Step ONE: Data is added to the main table 'RTW',
Step TWO: Data is added to the Distribution or Relationship table: 'RTW2_2'.
