The id value (an 8 digit number) of the customer who has booked this. Note that for this application, you should assume that customers and CSRs know their customer ids. The system you are writing does not interact with these numbers, rather it simply records them. If this field is all blanks, the record is available for sale.
does the above mean i should not consider of using owner field as the key ?
Because this field can be empty, it is not applicable as a primary key.
If your specification is nearly similar to mine, then it is only possible to use the position of the record in the database file as the primary key because no other field, or combination of fields would allow to be used as the pk.
I used the record number as the primary key. I mean, this is the parameter I use to delete or update records. Since the record number is the position that the record appears in the database, and records cannot fit the same position, I create the record in the first free position (or in the end, in case of no free positions), return this number, and never throw a DuplicateKeyException.
Cheers, Roberto Perillo
SCJP, SCWCD, SCJD, SCBCD
Listen. That's my theme music. That's how I know I'm a super hero. That, and this tiny ad told me: