• Post Reply Bookmark Topic Watch Topic
  • New Topic

"booking" question  RSS feed

 
J Hartley
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
ok, is my design right..
1.when the user wants to book a seat, a booking dialog pops up
2.the dialog shows the flight number and the amount of seats left
3. if the user clicks "book" the record is locked and modified
4. unlock
does the above sound ok?
My concern is, what if someone deletes the record and puts in a new record after step 2 and before step 3....the new may have the same record number as the old...therefore the wrong flight would be booked urghh!!
cheers
joe
 
Trevor Dunn
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I do not think you have to worry about it. The assignment does not ask you to implement delete.
Also, somebody can correct me if I am wrong, but if you do delete a record it is only marked as deleted and not actually deleted from the db. As a result the flight numbers do not change, so you are safe from that scenario anyway
Trevor
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!