CREATE TABLE office
(
   office_id NUMBER,
   manager_id NUMBER,
   pager_number CHAR(8) UNIQUE NOT NULL,
   CONSTRAINT fk_office_person FOREIGN KEY (manager_id)
     REFERENCES person (id) ON DELETE CASCADE,
   CONSTRAINT pk_office PRIMARY KEY (office_id, manager_id)
)
/
