Am I right to state that the record size is fixed, & hence could I obtain the number of records in the database file by this:
Are these safe assumptions?
I'd looked through the schema of my database file & it seems that there're no primary key to uniquely identify a record at all. It is possible that all of the fields have duplicated values. A room number is missing. Am I right, or am I missing something here?
Was thinking of using the indexed sequential search for the file search, but in this case, I won't have an unique key to identify the record. I could have a few rooms available from a same hotel, and/or a few hotels with available rooms in the same city. Or would the plain old sequential search suffice in this case? I'm worried of being penalised for its performance.
One of the UI search criteria states this:
It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user.
I'm not quite sure if I understood the first part of the sentence. Does it means that all fields of the record should be searchable, and also exact matches for name and/or location search should be allowed?
Or does it just means that exact matches for name and/or location search would suffice?