Member Avatar for helloshurite

i want a travel management system which has following details:

ABC ltd. is a travel agency provides the services of reservation and cancellation of tickets for buses, trains and airlines. They require a travel management system to store the information regarding reservations and cancellations done by the passengers through them and also to automate their procedures. This system should consists of 5 modules namely - Reservation, cancellation, debit report, search utility and administration. Reservation and cancellation module should contan all the information regarding the passenger, who makes reservation and cancellation respectively. Debit report maintains the debit information regarding the passener along with the taxes; they need to pay along with the ticket. Search utility provides a facility to the user to search the record with the different options and administration module provides different options for updating / changing different rules, schedules of bus / train / airlines and other permissions to create / delete new users / booking officers and change his /her password.

This travel management system needs to be done in visual basic with access as database.

  • 2 Contributors
  • 3 Replies
  • 83 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by abu taher

Dani AI

Generated

Practical starting plan and focused tips for the travel-management project described by . Following ’s advice, implement one module at a time, fully test the core booking/cancellation flows, then add reporting and admin features.

Suggested core tables and keys (minimum):

  • Passengers: PassengerID (AutoNumber), Name, Contact, GovtID, DOB.
  • Schedules/Trips: TripID, TransportType, RouteID, Departure, Arrival, Capacity, Fare.
  • Bookings: BookingID, PassengerID (FK), TripID (FK), SeatNo, Status, BookingDate, OfficerID.
  • Payments/Debit: PaymentID, BookingID (FK), Amount, TaxRate, TaxAmount, TotalDue, PaymentStatus.
  • Users: UserID, Username, PasswordHash, Role, LastLogin.
  • Routes/Audit: Route definitions and an AuditLog for changes.

Implementation and operational tips:

  • Split the Access file into backend (data) + frontend (forms/logic) for each client to reduce corruption. Keep regular compact/repair and automated backups.
  • Use parameterized queries via ADO/OLEDB to avoid injection and to pass values safely. Use transactions (BeginTrans/CommitTrans/Rollback) around reservation + payment + seat decrement to keep data consistent.
  • For concurrency, implement optimistic checks (LastModified timestamp) before updates rather than relying on file locks. Index travel/date fields used in searches for speed.
  • Debit report = sum(Payment.Amount) + computed taxes; build it as a persisted query with date-range parameters so it can be exported.
  • Store salted password hashes (use PBKDF2/Rfc2898 in .NET) rather than plaintext. If multi-user load or concurrency becomes an issue, consider upsizing the backend to SQL Server Express.

These steps provide a practical scaffold for development and testing before polishing UI and permissions.

Recommended Answers

All 3 Replies

Member Avatar for abu taher

nice. go ahead. and plz tell the problem.

Member Avatar for helloshurite

nice. go ahead. and plz tell the problem.

This travel management system PROGRAM needs to be done in visual basic with access as database.

Member Avatar for abu taher

ok do it. It is possible to done in vb and ms access. so 1st start and when you face problem then start thread.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.