Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Question about DB and booking flights

 
Donald Wedding
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a question regarding the Database.
In a "real world" application, if I were to book flights, I would need a second database to hold information such as a passenger's name / address / etc. This information is obviously not in the db.db file. So, should I create a *NEW* database to hold customer information? Or is that going way beyond the scope of the assignment?
In addition, the file db.db only has a field "available seats". Is that the number of seats left, or the total allowable? Don't we need to know the maximum number of seats available on each flight as well as the number of seats that have been booked?
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think holding Passenger information is over the requirements and not needed, and available seat means how many seats are left that can be booked, you don't need to know the capacity of the flight.
Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic