Ready Access database "Tourist Club"
The subject area is a tourist club.
Solved problems - issuing information on tourist services (description of tours, where, which firm has these vouchers and how much is available, price, coordinates of the firm). It is necessary to normalize the database.
Arrange tours to the fields: country, firm, price.
Search: company info ХХ,
Sampling: information about companies that have vouchers to the UU at a price not higher than NN.
Calculations: the average cost of the tour to the UU country.
Correction: removal of data on travel agency XX and its permits; the cost of a trip to the country XX on the UU days increased by M%.
Limitations of integrity: a) each tour has a link to at least one firm; b) the price of the voucher is not less than 50 rubles;
Tabular report: list of tours with grouping by country;
Free report: a file of tourist firms.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)