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

CASE#5

a)
INSERT INTO category VALUES (1, 'Women''s Clothing');
INSERT INTO category VALUES (2, 'Children''s Clothing');
INSERT INTO category VALUES (3, 'Men''s Clothing');
INSERT INTO category VALUES (4, 'Outdoor Gear');

b)
INSERT INTO item VALUES
(1, 'Men''s Expedition Parka', 3, EMPTY_BLOB());

INSERT INTO item VALUES
(2, '3-Season Tent', 4, EMPTY_BLOB());

c)
UPDATE item
SET item_desc='Men''s Tundra Parka'
WHERE item_id=1;

d)
DELETE FROM item;
DELETE FROM category;