Are these SQL statements correct?

Not familiar with that particular DBMS, but your code looks reasonable at first glance...I'm assuming FK constraints also forthcoming for orders.client_id -> clients.client_id and orders.officer_id -> officers.officer_id?