Hi.. im new to web development and we have to do a web development project as part of curriculum.. we are doing Airline ticket Reservation System.. one of the requirement in the project is user should be able to select a seat of choice,if available. I was wondering how to define the db tables for seating arrangements. I mean each flight has different rows n seats.. how do I store seating details for each flight and their status in the database?

Thanks in advance..

You can store the siting arrangement (available/occupied,window/middle/aisle) of flights in database as per flight code.

pls send me airline reservation system source code in j2ee, database for it.

commented: no +0
commented: Lazy -2

i will to provide the table for seat only, u have to determine other tables
table name: Seat
parent table : FlightNumber
Field:
- record ID: record identifier
- flight number: flight number of the trip (including flight number and date)
- row id
- seat number in the row
- seat position: (windows, aisle, middle)
- seat class : economy, business, first class
- status: available, occupied, not applicable

hope it will help

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.