I need to make an flight reservation system. vb.net ? where can i get sample projects?

Question

Airlines Reservation System in VB.Net 2003

With MS Access

Answer 1

It sounds like a cool project!  I used to work for an airline as a Java/JSP developer for their website.  We used an API called Datalex to talk to Sabre, which is a popular reservations system.  Obviously you're not going to do that "for real" but you might want to Google those terms to see if you can learn anything about their APIs.

I would suggest starting with tables such as:

* PersonUniqueID, FrequentFlyerNumber, Name, Address, etc // FrequentFlyerNumber can be null

* PersonUniqueID, ReservationNumber, SeatNumber // Remember to handle multiperson reservations - in this schema, this means that there can be multiple rows with identical PersonUniqueID + ReservationNumber.  And since SeatNumber can be null...you'd have to either not have a primary key, or you'd have to change the schema somehow.

* FlightSegmentUniqueID,  FlightNumber, FlightDate, AircraftType, Origin, Destination  // UniqueID required since flight 123 could go from London to New York to LA

* FlightSegmentUniqueID, ReservationNumber, SeatNumber

* AircraftType, NumberOfSeats, and perhaps NumberOfRows

* It would violate BNF, since you're storing it on the people, but you might want to separately track the number of available seats on each flight segment