Essay Database
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 …
Is this Essay helpful? Join now to read this particular paper
and access over 800,000 just like this GET BETTER GRADES
and access over 800,000 just like this GET BETTER GRADES
…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? Let our professional writers save your time.
Need an original paper?
