assume that no more than 9999 officers need to be maintained in the table; update office_id field width to agree with office.id width