Small program for a Travel Agency

Small program for a Travel Agency is project number 141586 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider Ajz
Budget:	$100-300
Created:	04/27/2007 at 9:32 EDT
Bidding Ends:	04/30/2007 at 9:32 EDT
Project Creator:	ManuelBarbancho   Buyer Rating: (1 reviews)
Description:	Small program in VB, VB.NET or ACCESS for a Travel Agency. It includes the maintenaince of 3 entities: Travels, Occurrence of a travel, and Customers; plus the reservations from customers to travels. Entity 1: Travel (Id, Name, Description). Ex: (1, 'Egypt', 'Travel throght the land of pharaos, from the birth of Nile to Alexandrias') Entity 2: Occurrence(TravelOcurrenceId, TravelId, DateFrom, DateUntil, Price, Price (if paid on advanced), Taxes, Supplement 1, Supplement 2, Supplement 3, Supplement 4, Supplement 5, Supplement 6, Notes). Ex: (1, 1, '10/04/2007', '16/04/2007', 560.00, 490.00, 15.00, 2.00, 0.00, 0.00, 0.00, 15.00, 0.00, 'these are the notes to this travel') Entity 3: Customers (Id, Name, Surname, Telephone, Cell Phone, Email, Address, Identification Card). Ex: (24, 'John', 'Smith', '23423322', '30920280', 'customer_email', 'my address, 20', '123456789') Entity 4: Reservations (Id, CustomerId, TravelOcurrenceId, Reserved in advance (y/n), date_reserved, reserve_quantity, date_total_payment, total_payment, taxes, supplement_1_payment, supplement_2_payment, supplement_3_payment, supplement_4_payment, supplement_5_payment, supplement_6_payment, coming_from, housing [hotel, cabin, camping], notes). Example: (3, 12, 1, ‘y’, ‘10/02/2007’, 150.00, ‘30/03/2007’, 490, 15.00, 2.00, 0.00, 0.00, 0.00, 15.00, 0.00, ‘Rome’, ‘hotel’, ‘Good customer, no problem’). Some considerations: Should generate three reports: Report of participants of a travel occurrence, with name and surname, coming from field, housing, reserve_quantity, total_payment, taxes, supplement_[1..6]_payment (from entity ‘Reservations’) Report of advanced reservations made, with name and surname and travel occurrence. Report of customers, with name and surname and travel occurrences they participated. That’s all, please feel free to ask me whatever you doubt about. P.S.: Sorry for my English…
Job Type:	.NET Visual Basic
Database:	(None)
Operating system:	MS Windows
Bid count:	21
Average bid:	$ 244