insert into ADDRESS (ID, CITY) values (1, 'aaa');
insert into ADDRESS (ID, CITY) values (2, 'bbb');
insert into ADDRESS (ID, CITY) values (3, 'ccc');
SET IDENTITY_INSERT DEPARTMENT ON;
insert into DEPARTMENT (ID, NAME) values (1, 'aaa');
SET IDENTITY_INSERT DEPARTMENT OFF;
SET IDENTITY_INSERT EMPLOYEE ON;
insert into EMPLOYEE (ID, FIRST_NAME, LAST_NAME, ADDRESS_ID, DEPARTMENT_ID) values (1, 'aaa', 'bbb', 1, 1);
insert into EMPLOYEE (ID, FIRST_NAME, LAST_NAME, ADDRESS_ID, DEPARTMENT_ID) values (2, 'ccc', 'ddd', 2, 1);
insert into EMPLOYEE (ID, FIRST_NAME, LAST_NAME, ADDRESS_ID, DEPARTMENT_ID) values (3, 'eee', 'fff', 3, 1);
SET IDENTITY_INSERT EMPLOYEE OFF;