DROP TABLE contract; DROP TABLE client; DROP TABLE organization; DROP TABLE expertise; DROP TABLE consultant; DROP TABLE classification; DROP TABLE region; CREATE TABLE region (reg_num NUMBER(2) CONSTRAINT region_regnum_pk PRIMARY KEY, reg_name VARCHAR2(30) CONSTRAINT region_reg_name_nn NOT NULL); CREATE TABLE classification (class_num NUMBER(4) CONSTRAINT classification_classnum_pk PRIMARY KEY, class_type VARCHAR2(30) CONSTRAINT classification_classtype_nn NOT NULL); CREATE TABLE consultant (cons_num NUMBER(8) CONSTRAINT consultant_consnum_pk PRIMARY …showed first 75 words of 922 total…

…showed last 75 words of 922 total…VALUES (1006, TO_DATE('12/02/99', 'MM/DD/YY'), 'Routers', 'IP', NULL, 104, 02, 203); INSERT INTO contract VALUES (1007, TO_DATE('04/01/00', 'MM/DD/YY'), 'Government Planning', 'IP', NULL, 102, 01, 205); INSERT INTO contract VALUES (1008, TO_DATE('10/30/99', 'MM/DD/YY'), 'International Peace Foundation', 'completed', 80, 103, 02, 209); INSERT INTO contract VALUES (1009, TO_DATE('03/24/00', 'MM/DD/YY'), 'Viacom', 'IP', NULL, 101, 02, 208); INSERT INTO contract VALUES (1010, TO_DATE('02/01/00', 'MM/DD/YY'), 'Nova', 'IP', NULL, 109, 02, 210); COMMIT; Bibliography Tables foe computer science