DATABASE EXERCISE 4
SCENARIO
You are working for a travel agency and have been asked to set up a file containing details on major trains used by the agency as part of its European tour operations. The file is to be set up on a computer using a database information retrieval package. It will be mainly used to provide information to both company employees and customers alike.
1. Power on your workstation.
2. Boot up and load A DATABASE:
3. Enter each of the 10 fieldnames as follows:
DEPSTN
DEPCOUN
DEPCURR
DESTSTN
DESTCOUN
DESTCURR
TRAINNO
DEPART
ARRIVE
FARE
4. Enter the data for the first 20 records:
| DEPSTN | DEP CNTRY |
DEP CURR |
DEST STN |
DEST CNTRY |
DEST CURR |
TRAIN NO |
DEP | ARR | FARE |
| Victoria | England | Sterling | ParisNord | France | Francs | 1108 | 0800 | 1615 | 31.00 |
| Victoria | England | Sterling | ParisNord | France | Francs | 404 | 1030 | 1820 | 31.00 |
| Victoria | England | Sterling | ParisLaza | France | Francs | 308 | 0750 | 1807 | 31.00 |
| ParisNord | France | Francs | Amsterdam | Holland | Guilder | 81 | 0719 | 1230 | 28.00 |
| ParisNord | France | Francs | Milan | Italy | Lira | 227 | 0741 | 1700 | 74.00 |
| ParisNord | France | Francs | Milan | Italy | Lira | 23 | 1230 | 2100 | 74.00 |
| Victoria | England | Sterling | ParisNord | France | Francs | 490 | 2058 | 0843 | 31.00 |
| Victoria | England | Sterling | ParisLaza | France | Francs | 3122 | 1110 | 2109 | 31.00 |
| ParisNord | France | Francs | Amsterdam | Holland | Guilder | 283 | 1023 | 1632 | 28.00 |
| ParisNord | France | Francs | Milan | Italy | LLira | 2525 | 2252 | 1055 | 74.00 |
5. Review all your data entries:
6. When you have finished entering and correcting or editing the records on your file you should save your data-file and print it out.
7. Display and print out all trains departing from Victoria station.
8. Add a new record as follows:
Victoria, England, Sterling, Moscow, USSR, Roubles, 1996, 0700, 2300, 186.00
9. A passengers wishes to know details of all trains leaving Victoria station between 0700 and 1200 for France. What trains are available and to what stations in Paris should they arrive? Print out the train details.
10. What are the numbers of all trains going from France to Holland?
11. A passenger in Paris wishes to know of a train which arrives in London between 1700 and 1800 and its fare-price. Is there such a train and, if so, what is its number and departure time? Print out the train details.
12. A passenger in London wishes to have a list of the various currencies in use in the different Continental countries served by the timetable. Prepare such a list for him and print it out.
13. Sort the timetable in descending fare order and produce a printout of the complete timetable.
14. Exit from the DATABASE.