tables
Title: tables
Category: /Literature/English
Details: Words: 922 | Pages: 3 (approximately 235 words/page)
tables
Category: /Literature/English
Details: Words: 922 | Pages: 3 (approximately 235 words/page)
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…
You are viewing only a small portion of the paper.
Please login or register to access the full copy.
Please login or register to access the full copy.
…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
