--**********************************************************************00010000 --* MEMBER NAME: CRE8TB *00020000 --* *00030000 --* DESCRIPTION: CEJCO CLASS TABLES SET-UP *00040000 --* *00050000 --* EDIT AND MODIFY AS NECESSARY. THIS SET-UP ASSUMES A SEPARATE SET *00060000 --* OF TABLES FOR THE INSTRUCTOR (00) AND ONE FOR EACH OF TWELVE *00070000 --* STUDENTS (01-12); ADD OR REMOVE AS NECESSARY. *00080000 --* *00090000 --* CHANGE ALL: SCHEMA00-12 TO YOUR TABLE SCHEMA (CREATOR) NAMES *00100000 --* CEJCO00-12 TO YOUR DATABASE NAMES *00110000 --**********************************************************************00120000 -- 00130000 CREATE TABLE SCHEMA00.DEPARTMENT 00140000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 00150000 , DEPTNAME VARCHAR(29) NOT NULL 00160000 , MGRNO CHAR(6) 00170000 , ADMRDEPT CHAR(3) NOT NULL 00180000 , LOCATION CHAR(16) 00190000 ) 00200000 IN CEJCO00.USERSPC1 00210000 ; 00220000 CREATE TABLE SCHEMA00.EMPLOYEE 00230000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 00240000 , FIRSTNME VARCHAR(12) NOT NULL 00250000 , MIDINIT CHAR(1) NOT NULL 00260000 , LASTNAME VARCHAR(15) NOT NULL 00270000 , WORKDEPT CHAR(3) 00280000 , PHONENO CHAR(4) 00290000 , HIREDATE DATE 00300000 , JOB CHAR(8) 00310000 , EDLEVEL SMALLINT NOT NULL 00320000 , SEX CHAR(1) 00330000 , BIRTHDATE DATE 00340000 , SALARY DECIMAL(9, 2) 00350000 , BONUS DECIMAL(9, 2) 00360000 , COMM DECIMAL(9, 2) 00370000 ) 00380000 IN CEJCO00.USERSPC1 00390000 ; 00400000 CREATE TABLE SCHEMA00.PROJECT 00410000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 00420000 , PROJNAME VARCHAR(24) NOT NULL 00430000 , DEPTNO CHAR(3) NOT NULL 00440000 , RESPEMP CHAR(6) NOT NULL 00450000 , PRSTAFF DECIMAL(5, 2) 00460000 , PRSTDATE DATE 00470000 , PRENDATE DATE 00480000 , MAJPROJ CHAR(6) 00490000 ) 00500000 IN CEJCO00.USERSPC1 00510000 ; 00520000 CREATE TABLE SCHEMA00.EMP_ACT 00530000 ( EMPNO CHAR(6) NOT NULL 00540000 , PROJNO CHAR(6) NOT NULL 00550000 , ACTNO SMALLINT NOT NULL 00560000 , EMPTIME DECIMAL(5, 2) 00570000 , EMSTDATE DATE 00580000 , EMENDATE DATE 00590000 ) 00600000 IN CEJCO00.USERSPC1 00610000 ; 00620000 COMMIT 00630000 ; 00640000 CREATE TABLE SCHEMA01.DEPARTMENT 00650000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 00660000 , DEPTNAME VARCHAR(29) NOT NULL 00670000 , MGRNO CHAR(6) 00680000 , ADMRDEPT CHAR(3) NOT NULL 00690000 , LOCATION CHAR(16) 00700000 ) 00710000 IN CEJCO01.USERSPC1 00720000 ; 00730000 CREATE TABLE SCHEMA01.EMPLOYEE 00740000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 00750000 , FIRSTNME VARCHAR(12) NOT NULL 00760000 , MIDINIT CHAR(1) NOT NULL 00770000 , LASTNAME VARCHAR(15) NOT NULL 00780000 , WORKDEPT CHAR(3) 00790000 , PHONENO CHAR(4) 00800000 , HIREDATE DATE 00810000 , JOB CHAR(8) 00820000 , EDLEVEL SMALLINT NOT NULL 00830000 , SEX CHAR(1) 00840000 , BIRTHDATE DATE 00850000 , SALARY DECIMAL(9, 2) 00860000 , BONUS DECIMAL(9, 2) 00870000 , COMM DECIMAL(9, 2) 00880000 ) 00890000 IN CEJCO01.USERSPC1 00900000 ; 00910000 CREATE TABLE SCHEMA01.PROJECT 00920000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 00930000 , PROJNAME VARCHAR(24) NOT NULL 00940000 , DEPTNO CHAR(3) NOT NULL 00950000 , RESPEMP CHAR(6) NOT NULL 00960000 , PRSTAFF DECIMAL(5, 2) 00970000 , PRSTDATE DATE 00980000 , PRENDATE DATE 00990000 , MAJPROJ CHAR(6) 01000000 ) 01010000 IN CEJCO01.USERSPC1 01020000 ; 01030000 CREATE TABLE SCHEMA01.EMP_ACT 01040000 ( EMPNO CHAR(6) NOT NULL 01050000 , PROJNO CHAR(6) NOT NULL 01060000 , ACTNO SMALLINT NOT NULL 01070000 , EMPTIME DECIMAL(5, 2) 01080000 , EMSTDATE DATE 01090000 , EMENDATE DATE 01100000 ) 01110000 IN CEJCO01.USERSPC1 01120000 ; 01130000 COMMIT 01140000 ; 01150000 CREATE TABLE SCHEMA02.DEPARTMENT 01160000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 01170000 , DEPTNAME VARCHAR(29) NOT NULL 01180000 , MGRNO CHAR(6) 01190000 , ADMRDEPT CHAR(3) NOT NULL 01200000 , LOCATION CHAR(16) 01210000 ) 01220000 IN CEJCO02.USERSPC1 01230000 ; 01240000 CREATE TABLE SCHEMA02.EMPLOYEE 01250000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 01260000 , FIRSTNME VARCHAR(12) NOT NULL 01270000 , MIDINIT CHAR(1) NOT NULL 01280000 , LASTNAME VARCHAR(15) NOT NULL 01290000 , WORKDEPT CHAR(3) 01300000 , PHONENO CHAR(4) 01310000 , HIREDATE DATE 01320000 , JOB CHAR(8) 01330000 , EDLEVEL SMALLINT NOT NULL 01340000 , SEX CHAR(1) 01350000 , BIRTHDATE DATE 01360000 , SALARY DECIMAL(9, 2) 01370000 , BONUS DECIMAL(9, 2) 01380000 , COMM DECIMAL(9, 2) 01390000 ) 01400000 IN CEJCO02.USERSPC1 01410000 ; 01420000 CREATE TABLE SCHEMA02.PROJECT 01430000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 01440000 , PROJNAME VARCHAR(24) NOT NULL 01450000 , DEPTNO CHAR(3) NOT NULL 01460000 , RESPEMP CHAR(6) NOT NULL 01470000 , PRSTAFF DECIMAL(5, 2) 01480000 , PRSTDATE DATE 01490000 , PRENDATE DATE 01500000 , MAJPROJ CHAR(6) 01510000 ) 01520000 IN CEJCO02.USERSPC1 01530000 ; 01540000 CREATE TABLE SCHEMA02.EMP_ACT 01550000 ( EMPNO CHAR(6) NOT NULL 01560000 , PROJNO CHAR(6) NOT NULL 01570000 , ACTNO SMALLINT NOT NULL 01580000 , EMPTIME DECIMAL(5, 2) 01590000 , EMSTDATE DATE 01600000 , EMENDATE DATE 01610000 ) 01620000 IN CEJCO02.USERSPC1 01630000 ; 01640000 COMMIT 01650000 ; 01660000 CREATE TABLE SCHEMA03.DEPARTMENT 01670000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 01680000 , DEPTNAME VARCHAR(29) NOT NULL 01690000 , MGRNO CHAR(6) 01700000 , ADMRDEPT CHAR(3) NOT NULL 01710000 , LOCATION CHAR(16) 01720000 ) 01730000 IN CEJCO03.USERSPC1 01740000 ; 01750000 CREATE TABLE SCHEMA03.EMPLOYEE 01760000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 01770000 , FIRSTNME VARCHAR(12) NOT NULL 01780000 , MIDINIT CHAR(1) NOT NULL 01790000 , LASTNAME VARCHAR(15) NOT NULL 01800000 , WORKDEPT CHAR(3) 01810000 , PHONENO CHAR(4) 01820000 , HIREDATE DATE 01830000 , JOB CHAR(8) 01840000 , EDLEVEL SMALLINT NOT NULL 01850000 , SEX CHAR(1) 01860000 , BIRTHDATE DATE 01870000 , SALARY DECIMAL(9, 2) 01880000 , BONUS DECIMAL(9, 2) 01890000 , COMM DECIMAL(9, 2) 01900000 ) 01910000 IN CEJCO03.USERSPC1 01920000 ; 01930000 CREATE TABLE SCHEMA03.PROJECT 01940000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 01950000 , PROJNAME VARCHAR(24) NOT NULL 01960000 , DEPTNO CHAR(3) NOT NULL 01970000 , RESPEMP CHAR(6) NOT NULL 01980000 , PRSTAFF DECIMAL(5, 2) 01990000 , PRSTDATE DATE 02000000 , PRENDATE DATE 02010000 , MAJPROJ CHAR(6) 02020000 ) 02030000 IN CEJCO03.USERSPC1 02040000 ; 02050000 CREATE TABLE SCHEMA03.EMP_ACT 02060000 ( EMPNO CHAR(6) NOT NULL 02070000 , PROJNO CHAR(6) NOT NULL 02080000 , ACTNO SMALLINT NOT NULL 02090000 , EMPTIME DECIMAL(5, 2) 02100000 , EMSTDATE DATE 02110000 , EMENDATE DATE 02120000 ) 02130000 IN CEJCO03.USERSPC1 02140000 ; 02150000 COMMIT 02160000 ; 02170000 CREATE TABLE SCHEMA04.DEPARTMENT 02180000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 02190000 , DEPTNAME VARCHAR(29) NOT NULL 02200000 , MGRNO CHAR(6) 02210000 , ADMRDEPT CHAR(3) NOT NULL 02220000 , LOCATION CHAR(16) 02230000 ) 02240000 IN CEJCO04.USERSPC1 02250000 ; 02260000 CREATE TABLE SCHEMA04.EMPLOYEE 02270000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 02280000 , FIRSTNME VARCHAR(12) NOT NULL 02290000 , MIDINIT CHAR(1) NOT NULL 02300000 , LASTNAME VARCHAR(15) NOT NULL 02310000 , WORKDEPT CHAR(3) 02320000 , PHONENO CHAR(4) 02330000 , HIREDATE DATE 02340000 , JOB CHAR(8) 02350000 , EDLEVEL SMALLINT NOT NULL 02360000 , SEX CHAR(1) 02370000 , BIRTHDATE DATE 02380000 , SALARY DECIMAL(9, 2) 02390000 , BONUS DECIMAL(9, 2) 02400000 , COMM DECIMAL(9, 2) 02410000 ) 02420000 IN CEJCO04.USERSPC1 02430000 ; 02440000 CREATE TABLE SCHEMA04.PROJECT 02450000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 02460000 , PROJNAME VARCHAR(24) NOT NULL 02470000 , DEPTNO CHAR(3) NOT NULL 02480000 , RESPEMP CHAR(6) NOT NULL 02490000 , PRSTAFF DECIMAL(5, 2) 02500000 , PRSTDATE DATE 02510000 , PRENDATE DATE 02520000 , MAJPROJ CHAR(6) 02530000 ) 02540000 IN CEJCO04.USERSPC1 02550000 ; 02560000 CREATE TABLE SCHEMA04.EMP_ACT 02570000 ( EMPNO CHAR(6) NOT NULL 02580000 , PROJNO CHAR(6) NOT NULL 02590000 , ACTNO SMALLINT NOT NULL 02600000 , EMPTIME DECIMAL(5, 2) 02610000 , EMSTDATE DATE 02620000 , EMENDATE DATE 02630000 ) 02640000 IN CEJCO04.USERSPC1 02650000 ; 02660000 COMMIT 02670000 ; 02680000 CREATE TABLE SCHEMA05.DEPARTMENT 02690000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 02700000 , DEPTNAME VARCHAR(29) NOT NULL 02710000 , MGRNO CHAR(6) 02720000 , ADMRDEPT CHAR(3) NOT NULL 02730000 , LOCATION CHAR(16) 02740000 ) 02750000 IN CEJCO05.USERSPC1 02760000 ; 02770000 CREATE TABLE SCHEMA05.EMPLOYEE 02780000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 02790000 , FIRSTNME VARCHAR(12) NOT NULL 02800000 , MIDINIT CHAR(1) NOT NULL 02810000 , LASTNAME VARCHAR(15) NOT NULL 02820000 , WORKDEPT CHAR(3) 02830000 , PHONENO CHAR(4) 02840000 , HIREDATE DATE 02850000 , JOB CHAR(8) 02860000 , EDLEVEL SMALLINT NOT NULL 02870000 , SEX CHAR(1) 02880000 , BIRTHDATE DATE 02890000 , SALARY DECIMAL(9, 2) 02900000 , BONUS DECIMAL(9, 2) 02910000 , COMM DECIMAL(9, 2) 02920000 ) 02930000 IN CEJCO05.USERSPC1 02940000 ; 02950000 CREATE TABLE SCHEMA05.PROJECT 02960000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 02970000 , PROJNAME VARCHAR(24) NOT NULL 02980000 , DEPTNO CHAR(3) NOT NULL 02990000 , RESPEMP CHAR(6) NOT NULL 03000000 , PRSTAFF DECIMAL(5, 2) 03010000 , PRSTDATE DATE 03020000 , PRENDATE DATE 03030000 , MAJPROJ CHAR(6) 03040000 ) 03050000 IN CEJCO05.USERSPC1 03060000 ; 03070000 CREATE TABLE SCHEMA05.EMP_ACT 03080000 ( EMPNO CHAR(6) NOT NULL 03090000 , PROJNO CHAR(6) NOT NULL 03100000 , ACTNO SMALLINT NOT NULL 03110000 , EMPTIME DECIMAL(5, 2) 03120000 , EMSTDATE DATE 03130000 , EMENDATE DATE 03140000 ) 03150000 IN CEJCO05.USERSPC1 03160000 ; 03170000 COMMIT 03180000 ; 03190000 CREATE TABLE SCHEMA06.DEPARTMENT 03200000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 03210000 , DEPTNAME VARCHAR(29) NOT NULL 03220000 , MGRNO CHAR(6) 03230000 , ADMRDEPT CHAR(3) NOT NULL 03240000 , LOCATION CHAR(16) 03250000 ) 03260000 IN CEJCO06.USERSPC1 03270000 ; 03280000 CREATE TABLE SCHEMA06.EMPLOYEE 03290000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 03300000 , FIRSTNME VARCHAR(12) NOT NULL 03310000 , MIDINIT CHAR(1) NOT NULL 03320000 , LASTNAME VARCHAR(15) NOT NULL 03330000 , WORKDEPT CHAR(3) 03340000 , PHONENO CHAR(4) 03350000 , HIREDATE DATE 03360000 , JOB CHAR(8) 03370000 , EDLEVEL SMALLINT NOT NULL 03380000 , SEX CHAR(1) 03390000 , BIRTHDATE DATE 03400000 , SALARY DECIMAL(9, 2) 03410000 , BONUS DECIMAL(9, 2) 03420000 , COMM DECIMAL(9, 2) 03430000 ) 03440000 IN CEJCO06.USERSPC1 03450000 ; 03460000 CREATE TABLE SCHEMA06.PROJECT 03470000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 03480000 , PROJNAME VARCHAR(24) NOT NULL 03490000 , DEPTNO CHAR(3) NOT NULL 03500000 , RESPEMP CHAR(6) NOT NULL 03510000 , PRSTAFF DECIMAL(5, 2) 03520000 , PRSTDATE DATE 03530000 , PRENDATE DATE 03540000 , MAJPROJ CHAR(6) 03550000 ) 03560000 IN CEJCO06.USERSPC1 03570000 ; 03580000 CREATE TABLE SCHEMA06.EMP_ACT 03590000 ( EMPNO CHAR(6) NOT NULL 03600000 , PROJNO CHAR(6) NOT NULL 03610000 , ACTNO SMALLINT NOT NULL 03620000 , EMPTIME DECIMAL(5, 2) 03630000 , EMSTDATE DATE 03640000 , EMENDATE DATE 03650000 ) 03660000 IN CEJCO06.USERSPC1 03670000 ; 03680000 COMMIT 03690000 ; 03700000 CREATE TABLE SCHEMA07.DEPARTMENT 03710000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 03720000 , DEPTNAME VARCHAR(29) NOT NULL 03730000 , MGRNO CHAR(6) 03740000 , ADMRDEPT CHAR(3) NOT NULL 03750000 , LOCATION CHAR(16) 03760000 ) 03770000 IN CEJCO07.USERSPC1 03780000 ; 03790000 CREATE TABLE SCHEMA07.EMPLOYEE 03800000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 03810000 , FIRSTNME VARCHAR(12) NOT NULL 03820000 , MIDINIT CHAR(1) NOT NULL 03830000 , LASTNAME VARCHAR(15) NOT NULL 03840000 , WORKDEPT CHAR(3) 03850000 , PHONENO CHAR(4) 03860000 , HIREDATE DATE 03870000 , JOB CHAR(8) 03880000 , EDLEVEL SMALLINT NOT NULL 03890000 , SEX CHAR(1) 03900000 , BIRTHDATE DATE 03910000 , SALARY DECIMAL(9, 2) 03920000 , BONUS DECIMAL(9, 2) 03930000 , COMM DECIMAL(9, 2) 03940000 ) 03950000 IN CEJCO07.USERSPC1 03960000 ; 03970000 CREATE TABLE SCHEMA07.PROJECT 03980000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 03990000 , PROJNAME VARCHAR(24) NOT NULL 04000000 , DEPTNO CHAR(3) NOT NULL 04010000 , RESPEMP CHAR(6) NOT NULL 04020000 , PRSTAFF DECIMAL(5, 2) 04030000 , PRSTDATE DATE 04040000 , PRENDATE DATE 04050000 , MAJPROJ CHAR(6) 04060000 ) 04070000 IN CEJCO07.USERSPC1 04080000 ; 04090000 CREATE TABLE SCHEMA07.EMP_ACT 04100000 ( EMPNO CHAR(6) NOT NULL 04110000 , PROJNO CHAR(6) NOT NULL 04120000 , ACTNO SMALLINT NOT NULL 04130000 , EMPTIME DECIMAL(5, 2) 04140000 , EMSTDATE DATE 04150000 , EMENDATE DATE 04160000 ) 04170000 IN CEJCO07.USERSPC1 04180000 ; 04190000 COMMIT 04200000 ; 04210000 CREATE TABLE SCHEMA08.DEPARTMENT 04220000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 04230000 , DEPTNAME VARCHAR(29) NOT NULL 04240000 , MGRNO CHAR(6) 04250000 , ADMRDEPT CHAR(3) NOT NULL 04260000 , LOCATION CHAR(16) 04270000 ) 04280000 IN CEJCO08.USERSPC1 04290000 ; 04300000 CREATE TABLE SCHEMA08.EMPLOYEE 04310000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 04320000 , FIRSTNME VARCHAR(12) NOT NULL 04330000 , MIDINIT CHAR(1) NOT NULL 04340000 , LASTNAME VARCHAR(15) NOT NULL 04350000 , WORKDEPT CHAR(3) 04360000 , PHONENO CHAR(4) 04370000 , HIREDATE DATE 04380000 , JOB CHAR(8) 04390000 , EDLEVEL SMALLINT NOT NULL 04400000 , SEX CHAR(1) 04410000 , BIRTHDATE DATE 04420000 , SALARY DECIMAL(9, 2) 04430000 , BONUS DECIMAL(9, 2) 04440000 , COMM DECIMAL(9, 2) 04450000 ) 04460000 IN CEJCO08.USERSPC1 04470000 ; 04480000 CREATE TABLE SCHEMA08.PROJECT 04490000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 04500000 , PROJNAME VARCHAR(24) NOT NULL 04510000 , DEPTNO CHAR(3) NOT NULL 04520000 , RESPEMP CHAR(6) NOT NULL 04530000 , PRSTAFF DECIMAL(5, 2) 04540000 , PRSTDATE DATE 04550000 , PRENDATE DATE 04560000 , MAJPROJ CHAR(6) 04570000 ) 04580000 IN CEJCO08.USERSPC1 04590000 ; 04600000 CREATE TABLE SCHEMA08.EMP_ACT 04610000 ( EMPNO CHAR(6) NOT NULL 04620000 , PROJNO CHAR(6) NOT NULL 04630000 , ACTNO SMALLINT NOT NULL 04640000 , EMPTIME DECIMAL(5, 2) 04650000 , EMSTDATE DATE 04660000 , EMENDATE DATE 04670000 ) 04680000 IN CEJCO08.USERSPC1 04690000 ; 04700000 COMMIT 04710000 ; 04720000 CREATE TABLE SCHEMA09.DEPARTMENT 04730000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 04740000 , DEPTNAME VARCHAR(29) NOT NULL 04750000 , MGRNO CHAR(6) 04760000 , ADMRDEPT CHAR(3) NOT NULL 04770000 , LOCATION CHAR(16) 04780000 ) 04790000 IN CEJCO09.USERSPC1 04800000 ; 04810000 CREATE TABLE SCHEMA09.EMPLOYEE 04820000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 04830000 , FIRSTNME VARCHAR(12) NOT NULL 04840000 , MIDINIT CHAR(1) NOT NULL 04850000 , LASTNAME VARCHAR(15) NOT NULL 04860000 , WORKDEPT CHAR(3) 04870000 , PHONENO CHAR(4) 04880000 , HIREDATE DATE 04890000 , JOB CHAR(8) 04900000 , EDLEVEL SMALLINT NOT NULL 04910000 , SEX CHAR(1) 04920000 , BIRTHDATE DATE 04930000 , SALARY DECIMAL(9, 2) 04940000 , BONUS DECIMAL(9, 2) 04950000 , COMM DECIMAL(9, 2) 04960000 ) 04970000 IN CEJCO09.USERSPC1 04980000 ; 04990000 CREATE TABLE SCHEMA09.PROJECT 05000000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 05010000 , PROJNAME VARCHAR(24) NOT NULL 05020000 , DEPTNO CHAR(3) NOT NULL 05030000 , RESPEMP CHAR(6) NOT NULL 05040000 , PRSTAFF DECIMAL(5, 2) 05050000 , PRSTDATE DATE 05060000 , PRENDATE DATE 05070000 , MAJPROJ CHAR(6) 05080000 ) 05090000 IN CEJCO09.USERSPC1 05100000 ; 05110000 CREATE TABLE SCHEMA09.EMP_ACT 05120000 ( EMPNO CHAR(6) NOT NULL 05130000 , PROJNO CHAR(6) NOT NULL 05140000 , ACTNO SMALLINT NOT NULL 05150000 , EMPTIME DECIMAL(5, 2) 05160000 , EMSTDATE DATE 05170000 , EMENDATE DATE 05180000 ) 05190000 IN CEJCO09.USERSPC1 05200000 ; 05210000 COMMIT 05220000 ; 05230000 CREATE TABLE SCHEMA10.DEPARTMENT 05240000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 05250000 , DEPTNAME VARCHAR(29) NOT NULL 05260000 , MGRNO CHAR(6) 05270000 , ADMRDEPT CHAR(3) NOT NULL 05280000 , LOCATION CHAR(16) 05290000 ) 05300000 IN CEJCO10.USERSPC1 05310000 ; 05320000 CREATE TABLE SCHEMA10.EMPLOYEE 05330000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 05340000 , FIRSTNME VARCHAR(12) NOT NULL 05350000 , MIDINIT CHAR(1) NOT NULL 05360000 , LASTNAME VARCHAR(15) NOT NULL 05370000 , WORKDEPT CHAR(3) 05380000 , PHONENO CHAR(4) 05390000 , HIREDATE DATE 05400000 , JOB CHAR(8) 05410000 , EDLEVEL SMALLINT NOT NULL 05420000 , SEX CHAR(1) 05430000 , BIRTHDATE DATE 05440000 , SALARY DECIMAL(9, 2) 05450000 , BONUS DECIMAL(9, 2) 05460000 , COMM DECIMAL(9, 2) 05470000 ) 05480000 IN CEJCO10.USERSPC1 05490000 ; 05500000 CREATE TABLE SCHEMA10.PROJECT 05510000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 05520000 , PROJNAME VARCHAR(24) NOT NULL 05530000 , DEPTNO CHAR(3) NOT NULL 05540000 , RESPEMP CHAR(6) NOT NULL 05550000 , PRSTAFF DECIMAL(5, 2) 05560000 , PRSTDATE DATE 05570000 , PRENDATE DATE 05580000 , MAJPROJ CHAR(6) 05590000 ) 05600000 IN CEJCO10.USERSPC1 05610000 ; 05620000 CREATE TABLE SCHEMA10.EMP_ACT 05630000 ( EMPNO CHAR(6) NOT NULL 05640000 , PROJNO CHAR(6) NOT NULL 05650000 , ACTNO SMALLINT NOT NULL 05660000 , EMPTIME DECIMAL(5, 2) 05670000 , EMSTDATE DATE 05680000 , EMENDATE DATE 05690000 ) 05700000 IN CEJCO10.USERSPC1 05710000 ; 05720000 COMMIT 05730000 ; 05740000 CREATE TABLE SCHEMA11.DEPARTMENT 05750000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 05760000 , DEPTNAME VARCHAR(29) NOT NULL 05770000 , MGRNO CHAR(6) 05780000 , ADMRDEPT CHAR(3) NOT NULL 05790000 , LOCATION CHAR(16) 05800000 ) 05810000 IN CEJCO11.USERSPC1 05820000 ; 05830000 CREATE TABLE SCHEMA11.EMPLOYEE 05840000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 05850000 , FIRSTNME VARCHAR(12) NOT NULL 05860000 , MIDINIT CHAR(1) NOT NULL 05870000 , LASTNAME VARCHAR(15) NOT NULL 05880000 , WORKDEPT CHAR(3) 05890000 , PHONENO CHAR(4) 05900000 , HIREDATE DATE 05910000 , JOB CHAR(8) 05920000 , EDLEVEL SMALLINT NOT NULL 05930000 , SEX CHAR(1) 05940000 , BIRTHDATE DATE 05950000 , SALARY DECIMAL(9, 2) 05960000 , BONUS DECIMAL(9, 2) 05970000 , COMM DECIMAL(9, 2) 05980000 ) 05990000 IN CEJCO11.USERSPC1 06000000 ; 06010000 CREATE TABLE SCHEMA11.PROJECT 06020000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 06030000 , PROJNAME VARCHAR(24) NOT NULL 06040000 , DEPTNO CHAR(3) NOT NULL 06050000 , RESPEMP CHAR(6) NOT NULL 06060000 , PRSTAFF DECIMAL(5, 2) 06070000 , PRSTDATE DATE 06080000 , PRENDATE DATE 06090000 , MAJPROJ CHAR(6) 06100000 ) 06110000 IN CEJCO11.USERSPC1 06120000 ; 06130000 CREATE TABLE SCHEMA11.EMP_ACT 06140000 ( EMPNO CHAR(6) NOT NULL 06150000 , PROJNO CHAR(6) NOT NULL 06160000 , ACTNO SMALLINT NOT NULL 06170000 , EMPTIME DECIMAL(5, 2) 06180000 , EMSTDATE DATE 06190000 , EMENDATE DATE 06200000 ) 06210000 IN CEJCO11.USERSPC1 06220000 ; 06230000 COMMIT 06240000 ; 06250000 CREATE TABLE SCHEMA12.DEPARTMENT 06260000 ( DEPTNO CHAR(3) NOT NULL -- PRIMARY KEY 06270000 , DEPTNAME VARCHAR(29) NOT NULL 06280000 , MGRNO CHAR(6) 06290000 , ADMRDEPT CHAR(3) NOT NULL 06300000 , LOCATION CHAR(16) 06310000 ) 06320000 IN CEJCO12.USERSPC1 06330000 ; 06340000 CREATE TABLE SCHEMA12.EMPLOYEE 06350000 ( EMPNO CHAR(6) NOT NULL -- PRIMARY KEY 06360000 , FIRSTNME VARCHAR(12) NOT NULL 06370000 , MIDINIT CHAR(1) NOT NULL 06380000 , LASTNAME VARCHAR(15) NOT NULL 06390000 , WORKDEPT CHAR(3) 06400000 , PHONENO CHAR(4) 06410000 , HIREDATE DATE 06420000 , JOB CHAR(8) 06430000 , EDLEVEL SMALLINT NOT NULL 06440000 , SEX CHAR(1) 06450000 , BIRTHDATE DATE 06460000 , SALARY DECIMAL(9, 2) 06470000 , BONUS DECIMAL(9, 2) 06480000 , COMM DECIMAL(9, 2) 06490000 ) 06500000 IN CEJCO12.USERSPC1 06510000 ; 06520000 CREATE TABLE SCHEMA12.PROJECT 06530000 ( PROJNO CHAR(6) NOT NULL -- PRIMARY KEY 06540000 , PROJNAME VARCHAR(24) NOT NULL 06550000 , DEPTNO CHAR(3) NOT NULL 06560000 , RESPEMP CHAR(6) NOT NULL 06570000 , PRSTAFF DECIMAL(5, 2) 06580000 , PRSTDATE DATE 06590000 , PRENDATE DATE 06600000 , MAJPROJ CHAR(6) 06610000 ) 06620000 IN CEJCO12.USERSPC1 06630000 ; 06640000 CREATE TABLE SCHEMA12.EMP_ACT 06650000 ( EMPNO CHAR(6) NOT NULL 06660000 , PROJNO CHAR(6) NOT NULL 06670000 , ACTNO SMALLINT NOT NULL 06680000 , EMPTIME DECIMAL(5, 2) 06690000 , EMSTDATE DATE 06700000 , EMENDATE DATE 06710000 ) 06720000 IN CEJCO12.USERSPC1 06730000 ; 06740000 COMMIT 06750000 ; 06760000