INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (151, 'L5J2B5', 'Canada', 'ONT', 'Toronto', '1450 Acme Cr., Suite 4')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (155, 'J5J2B5', 'Canada', 'ALB', 'Calgary', '1111 Mooseland Rd.')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (158, 'W1A2B5', 'Canada', 'ONT', 'Arnprior', '1 Hawthorne Drive')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (157, 'Y5J2N5', 'Canada', 'YK', 'Yellow Knife', '1112 Gold Rush Rd.')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (162, 'K5J2B5', 'Canada', 'ONT', 'Ottawa', '12 Merivale Rd., Suite 5')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (159, 'Y3Q2N9', 'Canada', 'ONT', 'Perth', '234 Caledonia Lane')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (160, 'K3k5DD', 'Canada', 'BC', 'Prince Rupert', '3254 Parkway Place')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (154, 'N5J2N5', 'Canada', 'BC', 'Vancouver', '20 Mountain Blvd. Floor 53, Suite 6')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (153, 'Q2S5Z5', 'Canada', 'QUE', 'Montreal', '1 Canadien Place')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (156, 'Y4F7V6', 'Canada', 'ONT', 'Metcalfe', '2 Anderson Rd.')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (161, 'Z5J2N5', 'Canada', 'BC', 'Victoria', '382 Hyde Park Blvd.')
INSERT INTO ADDRESS (ADDRESS_ID, P_CODE, COUNTRY, PROVINCE, CITY, STREET) VALUES (152, 'C6C6C6', 'Canada', 'ONT', 'Smith Falls', '89 Chocolate Drive')
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('May', 558, 1, 'Jill', 'F', NULL, NULL, NULL, NULL, NULL, 155)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (56232, 558)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Jefferson', 552, 1, 'Jim-Bob', 'M', NULL, NULL, 558, NULL, NULL, 157)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (50000, 552)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Way', 560, 1, 'John', 'M', NULL, NULL, 552, NULL, NULL, 162)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (53000, 560)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Smith', 554, 1, 'Bob', 'M', NULL, NULL, 560, NULL, NULL, 151)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (35000, 554)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Smith', 557, 1, 'Emanual', 'M', NULL, NULL, 554, NULL, NULL, 154)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (49631, 557)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Smitty', 555, 1, 'Sarah-Lou', 'F', NULL, NULL, NULL, NULL, NULL, 158)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (75000, 555)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('White', 553, 1, 'Nancy', 'F', NULL, NULL, 555, NULL, NULL, 156)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (31000, 553)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Way', 562, 1, 'Sarah', 'F', NULL, NULL, 554, NULL, NULL, 160)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (87000, 562)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Jones', 559, 1, 'Fred', 'M', NULL, NULL, NULL, NULL, NULL, 161)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (500000, 559)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Jones', 561, 1, 'Betty', 'F', NULL, NULL, NULL, NULL, NULL, 152)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (500001, 561)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Chanley', 556, 1, 'Charles', 'M', NULL, NULL, 554, NULL, NULL, 153)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (43000, 556)
INSERT INTO EMPLOYEE (L_NAME, EMP_ID, VERSION, F_NAME, GENDER, END_TIME, START_TIME, MANAGER_ID, END_DATE, START_DATE, ADDR_ID) VALUES ('Saunders', 551, 1, 'Marcus', 'M', NULL, NULL, 560, NULL, NULL, 159)
INSERT INTO SALARY (SALARY, EMP_ID) VALUES (54300, 551)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (164, 'Sales Reporting', 'A reporting application to report on the corporations database through TopLink.', 560, 'L', 1)
INSERT INTO LPROJECT (BUDGET, MILESTONE, PROJ_ID) VALUES (5000.0, {ts '1991-11-11 12:00:00.0'}, 164)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (157, 'TOPEmployee Management', 'A management application to report on the corporations database through TopLink.', NULL, 'L', 1)
INSERT INTO LPROJECT (BUDGET, MILESTONE, PROJ_ID) VALUES (4000.98, {ts '1997-11-12 01:00:00.0'}, 157)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (159, 'Enterprise System', 'A enterprise wide application to report on the corporations database through TopLink.', 556, 'L', 1)
INSERT INTO LPROJECT (BUDGET, MILESTONE, PROJ_ID) VALUES (40.98, {ts '1996-09-06 06:40:44.0'}, 159)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (156, 'Problem Reporting System', 'A PRS application to report on the corporations database through TopLink.', 562, 'L', 1)
INSERT INTO LPROJECT (BUDGET, MILESTONE, PROJ_ID) VALUES (101.98, {ts '1997-10-06 01:40:44.0'}, 156)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (163, 'Light Reporter', 'A lightweight application to report on the corporations database through TopLink.', NULL, 'L', 1)
INSERT INTO LPROJECT (BUDGET, MILESTONE, PROJ_ID) VALUES (100.98, {ts '1999-12-25 11:40:44.0'}, 163)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 557)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 560)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2258812', 'Work', '613', 554)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551111', 'Cellular', '416', 555)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551234', 'Home', '613', 555)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5556666', 'Pager', '976', 556)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551234', 'Home', '613', 552)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 556)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551234', 'Home', '613', 553)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2258812', 'Work', '613', 562)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551111', 'Cellular', '416', 559)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2258812', 'Work', '613', 558)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 559)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2258812', 'Work', '613', 561)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551111', 'Cellular', '416', 557)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2255943', 'Work Fax', '613', 555)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 561)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 551)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5556666', 'Pager', '976', 557)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551234', 'Home', '613', 562)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2255943', 'Work Fax', '613', 557)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2258812', 'Work', '613', 551)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2255943', 'Work Fax', '613', 558)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('2258812', 'Work', '613', 560)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5553691', 'ISDN', '905', 562)
INSERT INTO PHONE (P_NUMBER, TYPE, AREA_CODE, EMP_ID) VALUES ('5551111', 'Cellular', '416', 552)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (152, 'Makework', 'A makework project.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (151, 'Shipping Query Tool', 'A tool to help shipping query various things.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (160, 'Staff Query Tool', 'A tool to help staff query various things.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (154, 'TOPEmployee Manager', 'A management application to report on the corporations database through TopLink.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (153, 'Sales Reporter', 'A reporting application using JDK to report on the corporations databasethrough TopLink.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (158, 'Feather Reporter', 'An extremely lightweight application to report on the corporations database through TopLink.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (161, 'Marketing Query Tool', 'A tool to help marketing query various things.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (165, 'Enterprise', 'A enterprise wide application to report on the corporations database through TopLink.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (162, 'Accounting Query Tool', 'A tool to help accounting query various things.', NULL, 'S', 1)
INSERT INTO PROJECT (PROJ_ID, PROJ_NAME, DESCRIP, LEADER_ID, PROJ_TYPE, VERSION) VALUES (155, 'Problem Reporter', 'A PRS application to report on the corporations database through TopLink.', NULL, 'S', 1)
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (560, 'Hire people when more people are required.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (560, 'Lay off employees when less people are required.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (554, 'Water the office plants.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (554, 'Maintain the kitchen facilities.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (557, 'Have to fix the Database problem.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (562, 'Write code documentation.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (556, 'Perform code reviews as required.')
INSERT INTO RESPONS (EMP_ID, DESCRIP) VALUES (551, 'Write user specifications.')
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (155, 560)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (158, 560)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (164, 560)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (165, 554)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (153, 554)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (154, 554)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (163, 553)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (155, 562)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (164, 562)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (157, 562)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (156, 562)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (155, 556)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (159, 556)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (156, 556)
INSERT INTO PROJ_EMP (PROJ_ID, EMP_ID) VALUES (163, 551)