--**********************************************************************00010000 --* MEMBER NAME: CRE8IX *00020000 --* *00030000 --* DESCRIPTION: CEJCO CLASS INDEX AND KEY 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 --* CEJCOSG TO YOUR STOGROUP NAME *00110000 --* BP0 TO YOUR INDEX BUFFER POOL *00120000 --**********************************************************************00130000 -- 00140000 CREATE UNIQUE INDEX SCHEMA00.XDEPTPK 00150000 ON SCHEMA00.DEPARTMENT 00160000 ( DEPTNO ASC ) 00170000 USING STOGROUP CEJCOSG 00180000 PRIQTY 12 00190000 ERASE NO 00200000 BUFFERPOOL BP0 00210000 CLOSE YES 00220000 ; 00230000 CREATE UNIQUE INDEX SCHEMA00.XEMPPK 00240000 ON SCHEMA00.EMPLOYEE 00250000 ( EMPNO ASC ) 00260000 USING STOGROUP CEJCOSG 00270000 PRIQTY 12 00280000 ERASE NO 00290000 BUFFERPOOL BP0 00300000 CLOSE YES 00310000 ; 00320000 CREATE UNIQUE INDEX SCHEMA00.XPROJPK 00330000 ON SCHEMA00.PROJECT 00340000 ( PROJNO ASC ) 00350000 USING STOGROUP CEJCOSG 00360000 PRIQTY 12 00370000 ERASE NO 00380000 BUFFERPOOL BP0 00390000 CLOSE YES 00400000 ; 00410000 ALTER TABLE SCHEMA00.DEPARTMENT 00420000 ADD PRIMARY KEY (DEPTNO) 00430000 ; 00440000 ALTER TABLE SCHEMA00.EMPLOYEE 00450000 ADD PRIMARY KEY (EMPNO) 00460000 ; 00470000 ALTER TABLE SCHEMA00.PROJECT 00480000 ADD PRIMARY KEY (PROJNO) 00490000 ; 00500000 COMMIT 00510000 ; 00520000 CREATE UNIQUE INDEX SCHEMA01.XDEPTPK 00530000 ON SCHEMA01.DEPARTMENT 00540000 ( DEPTNO ASC ) 00550000 USING STOGROUP CEJCOSG 00560000 PRIQTY 12 00570000 ERASE NO 00580000 BUFFERPOOL BP0 00590000 CLOSE YES 00600000 ; 00610000 CREATE UNIQUE INDEX SCHEMA01.XEMPPK 00620000 ON SCHEMA01.EMPLOYEE 00630000 ( EMPNO ASC ) 00640000 USING STOGROUP CEJCOSG 00650000 PRIQTY 12 00660000 ERASE NO 00670000 BUFFERPOOL BP0 00680000 CLOSE YES 00690000 ; 00700000 CREATE UNIQUE INDEX SCHEMA01.XPROJPK 00710000 ON SCHEMA01.PROJECT 00720000 ( PROJNO ASC ) 00730000 USING STOGROUP CEJCOSG 00740000 PRIQTY 12 00750000 ERASE NO 00760000 BUFFERPOOL BP0 00770000 CLOSE YES 00780000 ; 00790000 ALTER TABLE SCHEMA01.DEPARTMENT 00800000 ADD PRIMARY KEY (DEPTNO) 00810000 ; 00820000 ALTER TABLE SCHEMA01.EMPLOYEE 00830000 ADD PRIMARY KEY (EMPNO) 00840000 ; 00850000 ALTER TABLE SCHEMA01.PROJECT 00860000 ADD PRIMARY KEY (PROJNO) 00870000 ; 00880000 COMMIT 00890000 ; 00900000 CREATE UNIQUE INDEX SCHEMA02.XDEPTPK 00910000 ON SCHEMA02.DEPARTMENT 00920000 ( DEPTNO ASC ) 00930000 USING STOGROUP CEJCOSG 00940000 PRIQTY 12 00950000 ERASE NO 00960000 BUFFERPOOL BP0 00970000 CLOSE YES 00980000 ; 00990000 CREATE UNIQUE INDEX SCHEMA02.XEMPPK 01000000 ON SCHEMA02.EMPLOYEE 01010000 ( EMPNO ASC ) 01020000 USING STOGROUP CEJCOSG 01030000 PRIQTY 12 01040000 ERASE NO 01050000 BUFFERPOOL BP0 01060000 CLOSE YES 01070000 ; 01080000 CREATE UNIQUE INDEX SCHEMA02.XPROJPK 01090000 ON SCHEMA02.PROJECT 01100000 ( PROJNO ASC ) 01110000 USING STOGROUP CEJCOSG 01120000 PRIQTY 12 01130000 ERASE NO 01140000 BUFFERPOOL BP0 01150000 CLOSE YES 01160000 ; 01170000 ALTER TABLE SCHEMA02.DEPARTMENT 01180000 ADD PRIMARY KEY (DEPTNO) 01190000 ; 01200000 ALTER TABLE SCHEMA02.EMPLOYEE 01210000 ADD PRIMARY KEY (EMPNO) 01220000 ; 01230000 ALTER TABLE SCHEMA02.PROJECT 01240000 ADD PRIMARY KEY (PROJNO) 01250000 ; 01260000 COMMIT 01270000 ; 01280000 CREATE UNIQUE INDEX SCHEMA03.XDEPTPK 01290000 ON SCHEMA03.DEPARTMENT 01300000 ( DEPTNO ASC ) 01310000 USING STOGROUP CEJCOSG 01320000 PRIQTY 12 01330000 ERASE NO 01340000 BUFFERPOOL BP0 01350000 CLOSE YES 01360000 ; 01370000 CREATE UNIQUE INDEX SCHEMA03.XEMPPK 01380000 ON SCHEMA03.EMPLOYEE 01390000 ( EMPNO ASC ) 01400000 USING STOGROUP CEJCOSG 01410000 PRIQTY 12 01420000 ERASE NO 01430000 BUFFERPOOL BP0 01440000 CLOSE YES 01450000 ; 01460000 CREATE UNIQUE INDEX SCHEMA03.XPROJPK 01470000 ON SCHEMA03.PROJECT 01480000 ( PROJNO ASC ) 01490000 USING STOGROUP CEJCOSG 01500000 PRIQTY 12 01510000 ERASE NO 01520000 BUFFERPOOL BP0 01530000 CLOSE YES 01540000 ; 01550000 ALTER TABLE SCHEMA03.DEPARTMENT 01560000 ADD PRIMARY KEY (DEPTNO) 01570000 ; 01580000 ALTER TABLE SCHEMA03.EMPLOYEE 01590000 ADD PRIMARY KEY (EMPNO) 01600000 ; 01610000 ALTER TABLE SCHEMA03.PROJECT 01620000 ADD PRIMARY KEY (PROJNO) 01630000 ; 01640000 COMMIT 01650000 ; 01660000 CREATE UNIQUE INDEX SCHEMA04.XDEPTPK 01670000 ON SCHEMA04.DEPARTMENT 01680000 ( DEPTNO ASC ) 01690000 USING STOGROUP CEJCOSG 01700000 PRIQTY 12 01710000 ERASE NO 01720000 BUFFERPOOL BP0 01730000 CLOSE YES 01740000 ; 01750000 CREATE UNIQUE INDEX SCHEMA04.XEMPPK 01760000 ON SCHEMA04.EMPLOYEE 01770000 ( EMPNO ASC ) 01780000 USING STOGROUP CEJCOSG 01790000 PRIQTY 12 01800000 ERASE NO 01810000 BUFFERPOOL BP0 01820000 CLOSE YES 01830000 ; 01840000 CREATE UNIQUE INDEX SCHEMA04.XPROJPK 01850000 ON SCHEMA04.PROJECT 01860000 ( PROJNO ASC ) 01870000 USING STOGROUP CEJCOSG 01880000 PRIQTY 12 01890000 ERASE NO 01900000 BUFFERPOOL BP0 01910000 CLOSE YES 01920000 ; 01930000 ALTER TABLE SCHEMA04.DEPARTMENT 01940000 ADD PRIMARY KEY (DEPTNO) 01950000 ; 01960000 ALTER TABLE SCHEMA04.EMPLOYEE 01970000 ADD PRIMARY KEY (EMPNO) 01980000 ; 01990000 ALTER TABLE SCHEMA04.PROJECT 02000000 ADD PRIMARY KEY (PROJNO) 02010000 ; 02020000 COMMIT 02030000 ; 02040000 CREATE UNIQUE INDEX SCHEMA05.XDEPTPK 02050000 ON SCHEMA05.DEPARTMENT 02060000 ( DEPTNO ASC ) 02070000 USING STOGROUP CEJCOSG 02080000 PRIQTY 12 02090000 ERASE NO 02100000 BUFFERPOOL BP0 02110000 CLOSE YES 02120000 ; 02130000 CREATE UNIQUE INDEX SCHEMA05.XEMPPK 02140000 ON SCHEMA05.EMPLOYEE 02150000 ( EMPNO ASC ) 02160000 USING STOGROUP CEJCOSG 02170000 PRIQTY 12 02180000 ERASE NO 02190000 BUFFERPOOL BP0 02200000 CLOSE YES 02210000 ; 02220000 CREATE UNIQUE INDEX SCHEMA05.XPROJPK 02230000 ON SCHEMA05.PROJECT 02240000 ( PROJNO ASC ) 02250000 USING STOGROUP CEJCOSG 02260000 PRIQTY 12 02270000 ERASE NO 02280000 BUFFERPOOL BP0 02290000 CLOSE YES 02300000 ; 02310000 ALTER TABLE SCHEMA05.DEPARTMENT 02320000 ADD PRIMARY KEY (DEPTNO) 02330000 ; 02340000 ALTER TABLE SCHEMA05.EMPLOYEE 02350000 ADD PRIMARY KEY (EMPNO) 02360000 ; 02370000 ALTER TABLE SCHEMA05.PROJECT 02380000 ADD PRIMARY KEY (PROJNO) 02390000 ; 02400000 COMMIT 02410000 ; 02420000 CREATE UNIQUE INDEX SCHEMA06.XDEPTPK 02430000 ON SCHEMA06.DEPARTMENT 02440000 ( DEPTNO ASC ) 02450000 USING STOGROUP CEJCOSG 02460000 PRIQTY 12 02470000 ERASE NO 02480000 BUFFERPOOL BP0 02490000 CLOSE YES 02500000 ; 02510000 CREATE UNIQUE INDEX SCHEMA06.XEMPPK 02520000 ON SCHEMA06.EMPLOYEE 02530000 ( EMPNO ASC ) 02540000 USING STOGROUP CEJCOSG 02550000 PRIQTY 12 02560000 ERASE NO 02570000 BUFFERPOOL BP0 02580000 CLOSE YES 02590000 ; 02600000 CREATE UNIQUE INDEX SCHEMA06.XPROJPK 02610000 ON SCHEMA06.PROJECT 02620000 ( PROJNO ASC ) 02630000 USING STOGROUP CEJCOSG 02640000 PRIQTY 12 02650000 ERASE NO 02660000 BUFFERPOOL BP0 02670000 CLOSE YES 02680000 ; 02690000 ALTER TABLE SCHEMA06.DEPARTMENT 02700000 ADD PRIMARY KEY (DEPTNO) 02710000 ; 02720000 ALTER TABLE SCHEMA06.EMPLOYEE 02730000 ADD PRIMARY KEY (EMPNO) 02740000 ; 02750000 ALTER TABLE SCHEMA06.PROJECT 02760000 ADD PRIMARY KEY (PROJNO) 02770000 ; 02780000 COMMIT 02790000 ; 02800000 CREATE UNIQUE INDEX SCHEMA07.XDEPTPK 02810000 ON SCHEMA07.DEPARTMENT 02820000 ( DEPTNO ASC ) 02830000 USING STOGROUP CEJCOSG 02840000 PRIQTY 12 02850000 ERASE NO 02860000 BUFFERPOOL BP0 02870000 CLOSE YES 02880000 ; 02890000 CREATE UNIQUE INDEX SCHEMA07.XEMPPK 02900000 ON SCHEMA07.EMPLOYEE 02910000 ( EMPNO ASC ) 02920000 USING STOGROUP CEJCOSG 02930000 PRIQTY 12 02940000 ERASE NO 02950000 BUFFERPOOL BP0 02960000 CLOSE YES 02970000 ; 02980000 CREATE UNIQUE INDEX SCHEMA07.XPROJPK 02990000 ON SCHEMA07.PROJECT 03000000 ( PROJNO ASC ) 03010000 USING STOGROUP CEJCOSG 03020000 PRIQTY 12 03030000 ERASE NO 03040000 BUFFERPOOL BP0 03050000 CLOSE YES 03060000 ; 03070000 ALTER TABLE SCHEMA07.DEPARTMENT 03080000 ADD PRIMARY KEY (DEPTNO) 03090000 ; 03100000 ALTER TABLE SCHEMA07.EMPLOYEE 03110000 ADD PRIMARY KEY (EMPNO) 03120000 ; 03130000 ALTER TABLE SCHEMA07.PROJECT 03140000 ADD PRIMARY KEY (PROJNO) 03150000 ; 03160000 COMMIT 03170000 ; 03180000 CREATE UNIQUE INDEX SCHEMA08.XDEPTPK 03190000 ON SCHEMA08.DEPARTMENT 03200000 ( DEPTNO ASC ) 03210000 USING STOGROUP CEJCOSG 03220000 PRIQTY 12 03230000 ERASE NO 03240000 BUFFERPOOL BP0 03250000 CLOSE YES 03260000 ; 03270000 CREATE UNIQUE INDEX SCHEMA08.XEMPPK 03280000 ON SCHEMA08.EMPLOYEE 03290000 ( EMPNO ASC ) 03300000 USING STOGROUP CEJCOSG 03310000 PRIQTY 12 03320000 ERASE NO 03330000 BUFFERPOOL BP0 03340000 CLOSE YES 03350000 ; 03360000 CREATE UNIQUE INDEX SCHEMA08.XPROJPK 03370000 ON SCHEMA08.PROJECT 03380000 ( PROJNO ASC ) 03390000 USING STOGROUP CEJCOSG 03400000 PRIQTY 12 03410000 ERASE NO 03420000 BUFFERPOOL BP0 03430000 CLOSE YES 03440000 ; 03450000 ALTER TABLE SCHEMA08.DEPARTMENT 03460000 ADD PRIMARY KEY (DEPTNO) 03470000 ; 03480000 ALTER TABLE SCHEMA08.EMPLOYEE 03490000 ADD PRIMARY KEY (EMPNO) 03500000 ; 03510000 ALTER TABLE SCHEMA08.PROJECT 03520000 ADD PRIMARY KEY (PROJNO) 03530000 ; 03540000 COMMIT 03550000 ; 03560000 CREATE UNIQUE INDEX SCHEMA09.XDEPTPK 03570000 ON SCHEMA09.DEPARTMENT 03580000 ( DEPTNO ASC ) 03590000 USING STOGROUP CEJCOSG 03600000 PRIQTY 12 03610000 ERASE NO 03620000 BUFFERPOOL BP0 03630000 CLOSE YES 03640000 ; 03650000 CREATE UNIQUE INDEX SCHEMA09.XEMPPK 03660000 ON SCHEMA09.EMPLOYEE 03670000 ( EMPNO ASC ) 03680000 USING STOGROUP CEJCOSG 03690000 PRIQTY 12 03700000 ERASE NO 03710000 BUFFERPOOL BP0 03720000 CLOSE YES 03730000 ; 03740000 CREATE UNIQUE INDEX SCHEMA09.XPROJPK 03750000 ON SCHEMA09.PROJECT 03760000 ( PROJNO ASC ) 03770000 USING STOGROUP CEJCOSG 03780000 PRIQTY 12 03790000 ERASE NO 03800000 BUFFERPOOL BP0 03810000 CLOSE YES 03820000 ; 03830000 ALTER TABLE SCHEMA09.DEPARTMENT 03840000 ADD PRIMARY KEY (DEPTNO) 03850000 ; 03860000 ALTER TABLE SCHEMA09.EMPLOYEE 03870000 ADD PRIMARY KEY (EMPNO) 03880000 ; 03890000 ALTER TABLE SCHEMA09.PROJECT 03900000 ADD PRIMARY KEY (PROJNO) 03910000 ; 03920000 COMMIT 03930000 ; 03940000 CREATE UNIQUE INDEX SCHEMA10.XDEPTPK 03950000 ON SCHEMA10.DEPARTMENT 03960000 ( DEPTNO ASC ) 03970000 USING STOGROUP CEJCOSG 03980000 PRIQTY 12 03990000 ERASE NO 04000000 BUFFERPOOL BP0 04010000 CLOSE YES 04020000 ; 04030000 CREATE UNIQUE INDEX SCHEMA10.XEMPPK 04040000 ON SCHEMA10.EMPLOYEE 04050000 ( EMPNO ASC ) 04060000 USING STOGROUP CEJCOSG 04070000 PRIQTY 12 04080000 ERASE NO 04090000 BUFFERPOOL BP0 04100000 CLOSE YES 04110000 ; 04120000 CREATE UNIQUE INDEX SCHEMA10.XPROJPK 04130000 ON SCHEMA10.PROJECT 04140000 ( PROJNO ASC ) 04150000 USING STOGROUP CEJCOSG 04160000 PRIQTY 12 04170000 ERASE NO 04180000 BUFFERPOOL BP0 04190000 CLOSE YES 04200000 ; 04210000 ALTER TABLE SCHEMA10.DEPARTMENT 04220000 ADD PRIMARY KEY (DEPTNO) 04230000 ; 04240000 ALTER TABLE SCHEMA10.EMPLOYEE 04250000 ADD PRIMARY KEY (EMPNO) 04260000 ; 04270000 ALTER TABLE SCHEMA10.PROJECT 04280000 ADD PRIMARY KEY (PROJNO) 04290000 ; 04300000 COMMIT 04310000 ; 04320000 CREATE UNIQUE INDEX SCHEMA11.XDEPTPK 04330000 ON SCHEMA11.DEPARTMENT 04340000 ( DEPTNO ASC ) 04350000 USING STOGROUP CEJCOSG 04360000 PRIQTY 12 04370000 ERASE NO 04380000 BUFFERPOOL BP0 04390000 CLOSE YES 04400000 ; 04410000 CREATE UNIQUE INDEX SCHEMA11.XEMPPK 04420000 ON SCHEMA11.EMPLOYEE 04430000 ( EMPNO ASC ) 04440000 USING STOGROUP CEJCOSG 04450000 PRIQTY 12 04460000 ERASE NO 04470000 BUFFERPOOL BP0 04480000 CLOSE YES 04490000 ; 04500000 CREATE UNIQUE INDEX SCHEMA11.XPROJPK 04510000 ON SCHEMA11.PROJECT 04520000 ( PROJNO ASC ) 04530000 USING STOGROUP CEJCOSG 04540000 PRIQTY 12 04550000 ERASE NO 04560000 BUFFERPOOL BP0 04570000 CLOSE YES 04580000 ; 04590000 ALTER TABLE SCHEMA11.DEPARTMENT 04600000 ADD PRIMARY KEY (DEPTNO) 04610000 ; 04620000 ALTER TABLE SCHEMA11.EMPLOYEE 04630000 ADD PRIMARY KEY (EMPNO) 04640000 ; 04650000 ALTER TABLE SCHEMA11.PROJECT 04660000 ADD PRIMARY KEY (PROJNO) 04670000 ; 04680000 COMMIT 04690000 ; 04700000 CREATE UNIQUE INDEX SCHEMA12.XDEPTPK 04710000 ON SCHEMA12.DEPARTMENT 04720000 ( DEPTNO ASC ) 04730000 USING STOGROUP CEJCOSG 04740000 PRIQTY 12 04750000 ERASE NO 04760000 BUFFERPOOL BP0 04770000 CLOSE YES 04780000 ; 04790000 CREATE UNIQUE INDEX SCHEMA12.XEMPPK 04800000 ON SCHEMA12.EMPLOYEE 04810000 ( EMPNO ASC ) 04820000 USING STOGROUP CEJCOSG 04830000 PRIQTY 12 04840000 ERASE NO 04850000 BUFFERPOOL BP0 04860000 CLOSE YES 04870000 ; 04880000 CREATE UNIQUE INDEX SCHEMA12.XPROJPK 04890000 ON SCHEMA12.PROJECT 04900000 ( PROJNO ASC ) 04910000 USING STOGROUP CEJCOSG 04920000 PRIQTY 12 04930000 ERASE NO 04940000 BUFFERPOOL BP0 04950000 CLOSE YES 04960000 ; 04970000 ALTER TABLE SCHEMA12.DEPARTMENT 04980000 ADD PRIMARY KEY (DEPTNO) 04990000 ; 05000000 ALTER TABLE SCHEMA12.EMPLOYEE 05010000 ADD PRIMARY KEY (EMPNO) 05020000 ; 05030000 ALTER TABLE SCHEMA12.PROJECT 05040000 ADD PRIMARY KEY (PROJNO) 05050000 ; 05060000 COMMIT 05070000 ; 05080000