• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

"booking" question

 
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic