Andre Long
CISP 350 Oracle
March 15, 2006
Chapter 3A PSC 

CASE#9

a)
--insert values into CONSULTANT
INSERT INTO consultant VALUES
(100, 'Myers', 'Mark', 'F', '1383 Alexander Ave.', 'Eau Claire', 'WI', '54703', '7155559652', 'mmyers@swexpert.com');

INSERT INTO consultant VALUES
(101, 'Hernandez', 'Sheila', 'R', '3227 Brian Street', 'Eau Claire', 'WI', '54702', '7155550282', 'shernandez@earthware.com');

INSERT INTO consultant VALUES
(102, 'Zhang', 'Brian', NULL, '2227 Calumet Place', 'Altoona', 'WI', '54720', '7155558383', 'zhang@swexpert.com');

INSERT INTO consultant VALUES
(103, 'Carlson', 'Sarah', 'J', '1334 Water Street', 'Eau Claire', 'WI', '54703', '7155558008', 'carlsons@swexpert.com');

INSERT INTO consultant VALUES
(104, 'Courtlandt', 'Paul', 'R', '1911 Pine Drive', 'Eau Claire', 'WI', '54701', '7155555225', 'courtlpr@yamail.com');

INSERT INTO consultant VALUES
(105, 'Park', 'Janet', 'S', '2333 157th Street', 'Chippewa Falls', 'WI', '54712', '7155554944', 'jpark@swexpert.com');

--insert values into SKILL
INSERT INTO skill VALUES
(1, 'VB .NET Programming');

INSERT INTO skill VALUES
(2, 'COBOL Programming');

INSERT INTO skill VALUES
(3, 'Java Programming');

INSERT INTO skill VALUES
(4, 'Project Management');

INSERT INTO skill VALUES
(5, 'Web Application Programming');

INSERT INTO skill VALUES
(6, 'Oracle Developer Programming');

INSERT INTO skill VALUES
(7, 'Oracle Database Administration');

INSERT INTO skill VALUES
(8, 'Windows NT/2000 Network Administration');

INSERT INTO skill VALUES
(9, 'Windows XP Network Administration');

INSERT INTO consultant_skill(c_id,skill_id)
VALUES (100,1);


c)
ALTER TABLE consultant_skill
DISABLE CONSTRAINT consultant_skill_c_id_fk;

ALTER TABLE project
DISABLE CONSTRAINT project_mgr_id_fk;

ALTER TABLE project_consultant
DISABLE CONSTRAINT project_consultant_c_id_fk;

ALTER TABLE evaluation
DISABLE CONSTRAINT evaluation_evaluator_id_fk
DISABLE CONSTRAINT evaluation_evaluatee_id_fk;

TRUNCATE TABLE consultant;

ALTER TABLE consultant_skill
ENABLE CONSTRAINT consultant_skill_c_id_fk;

ALTER TABLE project
ENABLE  CONSTRAINT project_mgr_id_fk;

ALTER TABLE project_consultant
ENABLE  CONSTRAINT project_consultant_c_id_fk;

ALTER TABLE evaluation
ENABLE  CONSTRAINT evaluation_evaluator_id_fk
ENABLE  CONSTRAINT evaluation_evaluatee_id_fk;

d)
DELETE  FROM consultant_skill;

DELETE  FROM skill;

DELETE  FROM consultant;