|
 |
 |
tables
Title: tables
Category: Literature / English
Details: Words: 984 | Pages: 4.2 (approximately 235 words/page)
tables
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 984 total…
You are viewing only a small portion of the paper.
Please login or register to access the full copy.
|
|
…showed last 75 words of 984 total…DATE('01/14/00', 'MM/DD/YY'), 'Internal Affairs', 'completed', 48,
105, 01, 206);
INSERT INTO contract 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
Need a custom written paper?
|
|
275 words per page