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? Please give me a start up idea.. im very much struck with this and can't get any forward..

thanks in advance