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.
Closed
(Selected Service Provider Ajz)
| Status: |
Closed
|
| 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: |
|
| Database: |
(None)
|
| Operating system: |
MS Windows
|
| Bid count: |
21
|
| Average bid: |
$ 244
|
|

|