Make your own free website on Tripod.com

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.