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
Joined: Jun 13, 2001
Posts: 84
posted
0
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
0
