What is to be kept in mind and what should be the tables developed to design a database of site which gives the details of flights, with travel date , destination , departure input by user?
This looks like homework. To be honest, the clues are all there in the question. What do you think the answers might be? What are you stuck on specifically?