REM DEPARTMENT TABLE

PROMPT
PROMPT
PROMPT ***********************************************************************
PROMPT ****************** STARTING DEPARTMENT TABLE INSERTS ******************
PROMPT ***********************************************************************

insert into dept values(  'A00'  ,'SPIFFY COMPUTER SERVICE DIV.'  ,'000010'  ,'A00');
insert into dept values(  'B01'  ,'PLANNING'                      ,'000020'  ,'A00');
insert into dept values(  'C01'  ,'INFORMATION CENTER'            ,'000030'  ,'A00');
insert into dept values(  'D01'  ,'DEVELOPMENT CENTER'            ,'------'  ,'A00');
insert into dept values(  'D11'  ,'MANUFACTURING SYSTEMS'         ,'000060'  ,'D01');
insert into dept values(  'D21'  ,'ADMINISTRATION SYSTEMS'        ,'000070'  ,'D01');
insert into dept values(  'E01'  ,'SUPPORT SERVICES'              ,'000050'  ,'A00');
insert into dept values(  'E11'  ,'OPERATIONS'                    ,'000090'  ,'E01');
insert into dept values(  'E21'  ,'SOFTWARE SUPPORT'              ,'000100'  ,'E01');
insert into dept values(  'F22'  ,'BRANCH OFFICE F2'              ,'------'  ,'E01');
insert into dept values(  'G22'  ,'BRANCH OFFICE G2'              ,'------'  ,'E01');
insert into dept values(  'H22'  ,'BRANCH OFFICE H2'              ,'------'  ,'E01');
insert into dept values(  'I22'  ,'BRANCH OFFICE I2'              ,'------'  ,'E01');
insert into dept values(  'J22'  ,'BRANCH OFFICE J2'              ,'------'  ,'E01');



PROMPT ***********************************************************************
PROMPT ****************** ENDING DEPARTMENT TABLE INSERTES *******************
PROMPT ***********************************************************************