ALTER TABLE departments ALTER CONSTRAINT dept_mgr_fk DEFERRABLE INITIALLY DEFERRED;

BEGIN;

INSERT INTO departments VALUES

( 10

, 'Administration'

, 200

, 1700

);

INSERT INTO departments VALUES

( 20

, 'Marketing'

, 201

, 1800

);

INSERT INTO departments VALUES

( 30

, 'Purchasing'

, 114

, 1700

);

INSERT INTO departments VALUES

( 40

, 'Human Resources'

, 203

, 2400

);

INSERT INTO departments VALUES

( 50

, 'Shipping'

, 121

, 1500

);

INSERT INTO departments VALUES

( 60

, 'IT'

, 103

, 1400

);

INSERT INTO departments VALUES

( 70

, 'Public Relations'

, 204

, 2700

);

INSERT INTO departments VALUES

( 80

, 'Sales'

, 145

, 2500

);

INSERT INTO departments VALUES

( 90

, 'Executive'

, 100

, 1700

);

INSERT INTO departments VALUES

( 100

, 'Finance'

, 108

, 1700

);

INSERT INTO departments VALUES

( 110

, 'Accounting'

, 205

, 1700

);

INSERT INTO departments VALUES

( 120

, 'Treasury'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 130

, 'Corporate Tax'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 140

, 'Control And Credit'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 150

, 'Shareholder Services'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 160

, 'Benefits'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 170

, 'Manufacturing'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 180

, 'Construction'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 190

, 'Contracting'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 200

, 'Operations'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 210

, 'IT Support'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 220

, 'NOC'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 230

, 'IT Helpdesk'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 240

, 'Government Sales'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 250

, 'Retail Sales'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 260

, 'Recruiting'

, NULL

, 1700

);

INSERT INTO departments VALUES

( 270

, 'Payroll'

, NULL

, 1700

);

INSERT INTO jobs VALUES

( 'AD_PRES'

, 'President'

, 20080

, 40000

);

INSERT INTO jobs VALUES

( 'AD_VP'

, 'Administration Vice President'

, 15000

, 30000

);

INSERT INTO jobs VALUES

( 'AD_ASST'

, 'Administration Assistant'

, 3000

, 6000

);

INSERT INTO jobs VALUES

( 'FI_MGR'

, 'Finance Manager'

, 8200

, 16000

);

INSERT INTO jobs VALUES

( 'FI_ACCOUNT'

, 'Accountant'

, 4200

, 9000

);

INSERT INTO jobs VALUES

( 'AC_MGR'

, 'Accounting Manager'

, 8200

, 16000

);

INSERT INTO jobs VALUES

( 'AC_ACCOUNT'

, 'Public Accountant'

, 4200

, 9000

);

INSERT INTO jobs VALUES

( 'SA_MAN'

, 'Sales Manager'

, 10000

, 20080

);

INSERT INTO jobs VALUES

( 'SA_REP'

, 'Sales Representative'

, 6000

, 12008

);

INSERT INTO jobs VALUES

( 'PU_MAN'

, 'Purchasing Manager'

, 8000

, 15000

);

INSERT INTO jobs VALUES

( 'PU_CLERK'

, 'Purchasing Clerk'

, 2500

, 5500

);

INSERT INTO jobs VALUES

( 'ST_MAN'

, 'Stock Manager'

, 5500

, 8500

);

INSERT INTO jobs VALUES

( 'ST_CLERK'

, 'Stock Clerk'

, 2008

, 5000

);

INSERT INTO jobs VALUES

( 'SH_CLERK'

, 'Shipping Clerk'

, 2500

, 5500

);

INSERT INTO jobs VALUES

( 'IT_PROG'

, 'Programmer'

, 4000

, 10000

);

INSERT INTO jobs VALUES

( 'MK_MAN'

, 'Marketing Manager'

, 9000

, 15000

);

INSERT INTO jobs VALUES

( 'MK_REP'

, 'Marketing Representative'

, 4000

, 9000

);

INSERT INTO jobs VALUES

( 'HR_REP'

, 'Human Resources Representative'

, 4000

, 9000

);

INSERT INTO jobs VALUES

( 'PR_REP'

, 'Public Relations Representative'

, 4500

, 10500

);

INSERT INTO employees VALUES

( 100

, 'Steven'

, 'King'

, 'SKING'

, '515.123.4567'

, TO_DATE('17-06-2003', 'dd-MM-yyyy')

, 'AD_PRES'

, 24000

, NULL

, NULL

, 90

);

INSERT INTO employees VALUES

( 101

, 'Neena'

, 'Kochhar'

, 'NKOCHHAR'

, '515.123.4568'

, TO_DATE('21-09-2005', 'dd-MM-yyyy')

, 'AD_VP'

, 17000

, NULL

, 100

, 90

);

INSERT INTO employees VALUES

( 102

, 'Lex'

, 'De Haan'

, 'LDEHAAN'

, '515.123.4569'

, TO_DATE('13-01-2001', 'dd-MM-yyyy')

, 'AD_VP'

, 17000

, NULL

, 100

, 90

);

INSERT INTO employees VALUES

( 103

, 'Alexander'

, 'Hunold'

, 'AHUNOLD'

, '590.423.4567'

, TO_DATE('03-01-2006', 'dd-MM-yyyy')

, 'IT_PROG'

, 9000

, NULL

, 102

, 60

);

INSERT INTO employees VALUES

( 104

, 'Bruce'

, 'Ernst'

, 'BERNST'

, '590.423.4568'

, TO_DATE('21-05-2007', 'dd-MM-yyyy')

, 'IT_PROG'

, 6000

, NULL

, 103

, 60

);

INSERT INTO employees VALUES

( 105

, 'David'

, 'Austin'

, 'DAUSTIN'

, '590.423.4569'

, TO_DATE('25-06-2005', 'dd-MM-yyyy')

, 'IT_PROG'

, 4800

, NULL

, 103

, 60

);

INSERT INTO employees VALUES

( 106

, 'Valli'

, 'Pataballa'

, 'VPATABAL'

, '590.423.4560'

, TO_DATE('05-02-2006', 'dd-MM-yyyy')

, 'IT_PROG'

, 4800

, NULL

, 103

, 60

);

INSERT INTO employees VALUES

( 107

, 'Diana'

, 'Lorentz'

, 'DLORENTZ'

, '590.423.5567'

, TO_DATE('07-02-2007', 'dd-MM-yyyy')

, 'IT_PROG'

, 4200

, NULL

, 103

, 60

);

INSERT INTO employees VALUES

( 108

, 'Nancy'

, 'Greenberg'

, 'NGREENBE'

, '515.124.4569'

, TO_DATE('17-08-2002', 'dd-MM-yyyy')

, 'FI_MGR'

, 12008

, NULL

, 101

, 100

);

INSERT INTO employees VALUES

( 109

, 'Daniel'

, 'Faviet'

, 'DFAVIET'

, '515.124.4169'

, TO_DATE('16-08-2002', 'dd-MM-yyyy')

, 'FI_ACCOUNT'

, 9000

, NULL

, 108

, 100

);

INSERT INTO employees VALUES

( 110

, 'John'

, 'Chen'

, 'JCHEN'

, '515.124.4269'

, TO_DATE('28-09-2005', 'dd-MM-yyyy')

, 'FI_ACCOUNT'

, 8200

, NULL

, 108

, 100

);

INSERT INTO employees VALUES

( 111

, 'Ismael'

, 'Sciarra'

, 'ISCIARRA'

, '515.124.4369'

, TO_DATE('30-09-2005', 'dd-MM-yyyy')

, 'FI_ACCOUNT'

, 7700

, NULL

, 108

, 100

);

INSERT INTO employees VALUES

( 112

, 'Jose Manuel'

, 'Urman'

, 'JMURMAN'

, '515.124.4469'

, TO_DATE('07-03-2006', 'dd-MM-yyyy')

, 'FI_ACCOUNT'

, 7800

, NULL

, 108

, 100

);

INSERT INTO employees VALUES

( 113

, 'Luis'

, 'Popp'

, 'LPOPP'

, '515.124.4567'

, TO_DATE('07-12-2007', 'dd-MM-yyyy')

, 'FI_ACCOUNT'

, 6900

, NULL

, 108

, 100

);

INSERT INTO employees VALUES

( 114

, 'Den'

, 'Raphaely'

, 'DRAPHEAL'

, '515.127.4561'

, TO_DATE('07-12-2002', 'dd-MM-yyyy')

, 'PU_MAN'

, 11000

, NULL

, 100

, 30

);

INSERT INTO employees VALUES

( 115

, 'Alexander'

, 'Khoo'

, 'AKHOO'

, '515.127.4562'

, TO_DATE('18-05-2003', 'dd-MM-yyyy')

, 'PU_CLERK'

, 3100

, NULL

, 114

, 30

);

INSERT INTO employees VALUES

( 116

, 'Shelli'

, 'Baida'

, 'SBAIDA'

, '515.127.4563'

, TO_DATE('24-12-2005', 'dd-MM-yyyy')

, 'PU_CLERK'

, 2900

, NULL

, 114

, 30

);

INSERT INTO employees VALUES

( 117

, 'Sigal'

, 'Tobias'

, 'STOBIAS'

, '515.127.4564'

, TO_DATE('24-07-2005', 'dd-MM-yyyy')

, 'PU_CLERK'

, 2800

, NULL

, 114

, 30

);

INSERT INTO employees VALUES

( 118

, 'Guy'

, 'Himuro'

, 'GHIMURO'

, '515.127.4565'

, TO_DATE('15-11-2006', 'dd-MM-yyyy')

, 'PU_CLERK'

, 2600

, NULL

, 114

, 30

);

INSERT INTO employees VALUES

( 119

, 'Karen'

, 'Colmenares'

, 'KCOLMENA'

, '515.127.4566'

, TO_DATE('10-08-2007', 'dd-MM-yyyy')

, 'PU_CLERK'

, 2500

, NULL

, 114

, 30

);

INSERT INTO employees VALUES

( 120

, 'Matthew'

, 'Weiss'

, 'MWEISS'

, '650.123.1234'

, TO_DATE('18-07-2004', 'dd-MM-yyyy')

, 'ST_MAN'

, 8000

, NULL

, 100

, 50

);

INSERT INTO employees VALUES

( 121

, 'Adam'

, 'Fripp'

, 'AFRIPP'

, '650.123.2234'

, TO_DATE('10-04-2005', 'dd-MM-yyyy')

, 'ST_MAN'

, 8200

, NULL

, 100

, 50

);

INSERT INTO employees VALUES

( 122

, 'Payam'

, 'Kaufling'

, 'PKAUFLIN'

, '650.123.3234'

, TO_DATE('01-05-2003', 'dd-MM-yyyy')

, 'ST_MAN'

, 7900

, NULL

, 100

, 50

);

INSERT INTO employees VALUES

( 123

, 'Shanta'

, 'Vollman'

, 'SVOLLMAN'

, '650.123.4234'

, TO_DATE('10-10-2005', 'dd-MM-yyyy')

, 'ST_MAN'

, 6500

, NULL

, 100

, 50

);

INSERT INTO employees VALUES

( 124

, 'Kevin'

, 'Mourgos'

, 'KMOURGOS'

, '650.123.5234'

, TO_DATE('16-11-2007', 'dd-MM-yyyy')

, 'ST_MAN'

, 5800

, NULL

, 100

, 50

);

INSERT INTO employees VALUES

( 125

, 'Julia'

, 'Nayer'

, 'JNAYER'

, '650.124.1214'

, TO_DATE('16-07-2005', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3200

, NULL

, 120

, 50

);

INSERT INTO employees VALUES

( 126

, 'Irene'

, 'Mikkilineni'

, 'IMIKKILI'

, '650.124.1224'

, TO_DATE('28-09-2006', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2700

, NULL

, 120

, 50

);

INSERT INTO employees VALUES

( 127

, 'James'

, 'Landry'

, 'JLANDRY'

, '650.124.1334'

, TO_DATE('14-01-2007', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2400

, NULL

, 120

, 50

);

INSERT INTO employees VALUES

( 128

, 'Steven'

, 'Markle'

, 'SMARKLE'

, '650.124.1434'

, TO_DATE('08-03-2008', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2200

, NULL

, 120

, 50

);

INSERT INTO employees VALUES

( 129

, 'Laura'

, 'Bissot'

, 'LBISSOT'

, '650.124.5234'

, TO_DATE('20-08-2005', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3300

, NULL

, 121

, 50

);

INSERT INTO employees VALUES

( 130

, 'Mozhe'

, 'Atkinson'

, 'MATKINSO'

, '650.124.6234'

, TO_DATE('30-10-2005', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2800

, NULL

, 121

, 50

);

INSERT INTO employees VALUES

( 131

, 'James'

, 'Marlow'

, 'JAMRLOW'

, '650.124.7234'

, TO_DATE('16-02-2005', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2500

, NULL

, 121

, 50

);

INSERT INTO employees VALUES

( 132

, 'TJ'

, 'Olson'

, 'TJOLSON'

, '650.124.8234'

, TO_DATE('10-04-2007', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2100

, NULL

, 121

, 50

);

INSERT INTO employees VALUES

( 133

, 'Jason'

, 'Mallin'

, 'JMALLIN'

, '650.127.1934'

, TO_DATE('14-06-2004', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3300

, NULL

, 122

, 50

);

INSERT INTO employees VALUES

( 134

, 'Michael'

, 'Rogers'

, 'MROGERS'

, '650.127.1834'

, TO_DATE('26-08-2006', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2900

, NULL

, 122

, 50

);

INSERT INTO employees VALUES

( 135

, 'Ki'

, 'Gee'

, 'KGEE'

, '650.127.1734'

, TO_DATE('12-12-2007', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2400

, NULL

, 122

, 50

);

INSERT INTO employees VALUES

( 136

, 'Hazel'

, 'Philtanker'

, 'HPHILTAN'

, '650.127.1634'

, TO_DATE('06-02-2008', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2200

, NULL

, 122

, 50

);

INSERT INTO employees VALUES

( 137

, 'Renske'

, 'Ladwig'

, 'RLADWIG'

, '650.121.1234'

, TO_DATE('14-07-2003', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3600

, NULL

, 123

, 50

);

INSERT INTO employees VALUES

( 138

, 'Stephen'

, 'Stiles'

, 'SSTILES'

, '650.121.2034'

, TO_DATE('26-10-2005', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3200

, NULL

, 123

, 50

);

INSERT INTO employees VALUES

( 139

, 'John'

, 'Seo'

, 'JSEO'

, '650.121.2019'

, TO_DATE('12-02-2006', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2700

, NULL

, 123

, 50

);

INSERT INTO employees VALUES

( 140

, 'Joshua'

, 'Patel'

, 'JPATEL'

, '650.121.1834'

, TO_DATE('06-04-2006', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2500

, NULL

, 123

, 50

);

INSERT INTO employees VALUES

( 141

, 'Trenna'

, 'Rajs'

, 'TRAJS'

, '650.121.8009'

, TO_DATE('17-10-2003', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3500

, NULL

, 124

, 50

);

INSERT INTO employees VALUES

( 142

, 'Curtis'

, 'Davies'

, 'CDAVIES'

, '650.121.2994'

, TO_DATE('29-01-2005', 'dd-MM-yyyy')

, 'ST_CLERK'

, 3100

, NULL

, 124

, 50

);

INSERT INTO employees VALUES

( 143

, 'Randall'

, 'Matos'

, 'RMATOS'

, '650.121.2874'

, TO_DATE('15-03-2006', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2600

, NULL

, 124

, 50

);

INSERT INTO employees VALUES

( 144

, 'Peter'

, 'Vargas'

, 'PVARGAS'

, '650.121.2004'

, TO_DATE('09-07-2006', 'dd-MM-yyyy')

, 'ST_CLERK'

, 2500

, NULL

, 124

, 50

);

INSERT INTO employees VALUES

( 145

, 'John'

, 'Russell'

, 'JRUSSEL'

, '011.44.1344.429268'

, TO_DATE('01-10-2004', 'dd-MM-yyyy')

, 'SA_MAN'

, 14000

, .4

, 100

, 80

);

INSERT INTO employees VALUES

( 146

, 'Karen'

, 'Partners'

, 'KPARTNER'

, '011.44.1344.467268'

, TO_DATE('05-01-2005', 'dd-MM-yyyy')

, 'SA_MAN'

, 13500

, .3

, 100

, 80

);

INSERT INTO employees VALUES

( 147

, 'Alberto'

, 'Errazuriz'

, 'AERRAZUR'

, '011.44.1344.429278'

, TO_DATE('10-03-2005', 'dd-MM-yyyy')

, 'SA_MAN'

, 12000

, .3

, 100

, 80

);