DDL for Homework Assignments

TAL TABLES

Create TAL Table Statements

CREATE TABLE REP
(Rep_Num Char(2) PRIMARY KEY,
LAST_NAME CHAR(15) NOT NULL,
FIRST_NAME CHAR(15) NOT NULL,
STREET CHAR(15),
CITY CHAR(15),
STATE CHAR(2),
POSTAL_CODE CHAR(5),
COMMISSION DECIMAL(7,2),
RATE DECIMAL(3,2) );

CREATE TABLE CUSTOMER
(CUSTOMER_NUM CHAR(3) PRIMARY KEY,
CUSTOMER_NAME CHAR(35) NOT NULL,
STREET CHAR(20),
CITY CHAR(15),
STATE CHAR(2),
POSTAL_CODE CHAR(5),
BALANCE DECIMAL(8,2),
CREDIT_LIMIT DECIMAL(8,2),
REP_NUM CHAR(2) );

CREATE TABLE ORDERS
(ORDER_NUM CHAR(5) PRIMARY KEY,
ORDER_DATE DATE,
CUSTOMER_NUM CHAR(3) );

CREATE TABLE ITEM
(ITEM_NUM CHAR(4) PRIMARY KEY,
DESCRIPTION CHAR(30),
ON_HAND DECIMAL(4,0),
CATEGORY CHAR(3),
STOREHOUSE CHAR(1),
PRICE DECIMAL(6,2) );

CREATE TABLE ORDER_LINE
(ORDER_NUM CHAR(5),
ITEM_NUM CHAR(4),
NUM_ORDERED DECIMAL(3,0),
QUOTED_PRICE DECIMAL(6,2),
PRIMARY KEY (ORDER_NUM, ITEM_NUM) );

[back to top]

Insert TAL Table Statements

INSERT INTO REP
VALUES
(’15’,’Campos’,’Rafael’,’724 Vinca Dr.’,’Grove’,’CA’,’90092′,23457.50,0.06);
INSERT INTO REP
VALUES
(’30’,’Grady’,’Megan’,’632 Liatris St.’,’Fullton’,’CA’,’90085′,41317.00,0.08);
INSERT INTO REP
VALUES
(’45’,’Tian’,’Hui’,’1785 Tyler Ave’,’Northfield’,’CA’,’90098′,27789.25,0.06);
INSERT INTO REP
VALUES
(’60’,’Sefton’,’Janet’,’267 Oakley St’,’Congaree’,’CA’,’90097′,0.00,0.06);

INSERT INTO CUSTOMER
VALUES
(‘126′,’Toy Galore’,’28 Laketon St.’,’Fullton’,’CA’,’90085′,1210.25,7500.00,’15’);
INSERT INTO CUSTOMER
VALUES
(‘260′,’Brooking Direct’,’452 Columbus Dr. .’,’Grove’,’CA’,’90092′,575.00,10000.00,’30’);
INSERT INTO CUSTOMER
VALUES
(‘334′,’The Everything Shop’,’342 Magee St.’,’Congaree’,’CA’,’90097′,2345.75,7500.00,’45’);
INSERT INTO CUSTOMER
VALUES
(‘386′,’Johnson”s Department Store’,’124 Main St.’,’Northfield’,’CA’,’90098′,879.25,7500.00,’30’);
INSERT INTO CUSTOMER
VALUES
(‘440′,’Grove Historical Museum Store’,’3456 Central Ave.’,’Fullton’,’CA’,’90085′,345.00,5000.00,’45’);
INSERT INTO CUSTOMER
VALUES
(‘502′,’Cards and More’,’167 Hale St.’,’Mesa’,’CA’,’90104′,5025.75,5000.00,’15’);
INSERT INTO CUSTOMER
VALUES
(‘586′,’Almondton General Store’,’3345 Devon Ave.’,’Almondton’,’CA’,’90125′,3456.75,15000.00,’45’);
INSERT INTO CUSTOMER
VALUES
(‘665′,’Criket Gift Shop’,’372 Oxford St.’,’Grove’,’CA’,’90092′,678.90,7500.00,’30’);
INSERT INTO CUSTOMER
VALUES
(‘713′,’Cress Store’,’12 Rising Sun Ave.’,’Congaree’,’CA’,’90097′,4234.60,10000.00,’15’);
INSERT INTO CUSTOMER
VALUES
(‘796′,’Unigue Gifts’,’756 Passmore St.’,’Northfield’,’CA’,’90098′,124.75,7500.00,’45’);
INSERT INTO CUSTOMER
VALUES
(‘824′,’Kline”s’,’945 Gilham St.’,’Mesa’,’CA’,’90104′,2475.99,15000.00,’30’);
INSERT INTO CUSTOMER
VALUES
(‘893′,’All Season Gifts’,’382 Wildwood Ave’,’Fullton’,’CA’,’90085′,935.75,7500.00,’15’);

INSERT INTO ORDERS
VALUES
(‘51608′,’12-OCT-2015′,’126’);
INSERT INTO ORDERS
VALUES
(‘51610′,’12-OCT-2015′,’334’);
INSERT INTO ORDERS
VALUES
(‘51613′,’13-OCT-2015′,’386’);
INSERT INTO ORDERS
VALUES
(‘51614′,’13-OCT-2015′,’260’);
INSERT INTO ORDERS
VALUES
(‘51617′,’15-OCT-2015′,’586’);
INSERT INTO ORDERS
VALUES
(‘51619′,’15-OCT-2015′,’126’);
INSERT INTO ORDERS
VALUES
(‘51623′,’15-OCT-2015′,’586’);
INSERT INTO ORDERS
VALUES
(‘51625′,’16-OCT-2015′,’796’);

INSERT INTO ORDER_LINE
VALUES
(‘51608′,’CD33’,5,86.99);
INSERT INTO ORDER_LINE
VALUES
(‘51610′,’KL78’,25,10.95);
INSERT INTO ORDER_LINE
VALUES
(‘51610′,’TR40’,10,13.99);
INSERT INTO ORDER_LINE
VALUES
(‘51613′,’DL51’,5,104.95);
INSERT INTO ORDER_LINE
VALUES
(‘51614′,’FD11’,1,124.95);
INSERT INTO ORDER_LINE
VALUES
(‘51617′,’NL89’,4,115.99);
INSERT INTO ORDER_LINE
VALUES
(‘51617′,’TW35’,3,116.95);
INSERT INTO ORDER_LINE
VALUES
(‘51619′,’FD11’,2,121.95);
INSERT INTO ORDER_LINE
VALUES
(‘51623′,’DR67’,5,29.95);
INSERT INTO ORDER_LINE
VALUES
(‘51623′,’FH24’,12,36.95);
INSERT INTO ORDER_LINE
VALUES
(‘51623′,’KD34’,10,13.10);
INSERT INTO ORDER_LINE
VALUES
(‘51625′,’MT03’,8,45.79);

INSERT INTO ITEM
VALUES
(‘AH74′,’Patience’,9,’GME’,’3′,22.99);
INSERT INTO ITEM
VALUES
(‘BR23′,’Skittles’,21,’GME’,’2′,29.99);
INSERT INTO ITEM
VALUES
(‘CD33′,’Wood Block Set (4 piece)’,36,’TOY’,’1′,89.49);
INSERT INTO ITEM
VALUES
(‘DL51′,’Classic Railway Set’,12,’TOY’,’3′,107.95);
INSERT INTO ITEM
VALUES
(‘DR67′,’Giant Star Brain Teaser’,24,’PZL’,’2′,31.95);
INSERT INTO ITEM
VALUES
(‘DW23′,’Mancala’,40,’GME’,’3′,50.00);
INSERT INTO ITEM
VALUES
(‘FD11′,’Rocking Horse’,8,’TOY’,’3′,124.95);
INSERT INTO ITEM
VALUES
(‘FH24′,’Puzzle Gift Set’,65,’PZL’,’1′,38.95);
INSERT INTO ITEM
VALUES
(‘KA12′,’Cribbage Set’,56,’GME’,’3′,75.00);
INSERT INTO ITEM
VALUES
(‘KD34′,’Pentominoes Brain Teaser’,60,’PZL’,’2′,14.95);
INSERT INTO ITEM
VALUES
(‘KL78′,’Pick Up Sticks’,110,’GME’,’1′,10.95);
INSERT INTO ITEM
VALUES
(‘MT03′,’Zauberkasten Brain Teaser’,45,’PZL’,’1′,45.79);
INSERT INTO ITEM
VALUES
(‘NL89′,’Wood Block Set (62 piece)’,32,’TOY’,’3′,119.75);
INSERT INTO ITEM
VALUES
(‘TR40′,’Tic Tac Toe’,75,’GME’,’2′,13.99);
INSERT INTO ITEM
VALUES
(‘TW35′,’Fire Engine’,30,’TOY’,’2′,118.95);

[back to top]

SOLMARIS TABLES

Create SOLMARIS Table Statements

CREATE TABLE LOCATION
(LOCATION_NUM DECIMAL(2,0) PRIMARY KEY,
LOCATION_NAME CHAR(25),
ADDRESS CHAR(25),
CITY CHAR(25),
STATE CHAR(2),
POSTAL_CODE CHAR(5) );

CREATE TABLE OWNER
(OWNER_NUM CHAR(5) PRIMARY KEY,
LAST_NAME CHAR(25),
FIRST_NAME CHAR(25),
ADDRESS CHAR(25),
CITY CHAR(25),
STATE CHAR(2),
POSTAL_CODE CHAR(5) );

CREATE TABLE CONDO_UNIT
(CONDO_ID DECIMAL(4,0) PRIMARY KEY,
LOCATION_NUM DECIMAL(2,0),
UNIT_NUM CHAR(3),
SQR_FT DECIMAL(5,0),
BDRMS DECIMAL(2,0),
BATHS DECIMAL(2,0),
CONDO_FEE DECIMAL(6,2),
OWNER_NUM CHAR(5) );

CREATE TABLE SERVICE_CATEGORY
(CATEGORY_NUM DECIMAL(4,0) PRIMARY KEY,
CATEGORY_DESCRIPTION CHAR(35) );

CREATE TABLE SERVICE_REQUEST
(SERVICE_ID DECIMAL(4,0) PRIMARY KEY,
CONDO_ID DECIMAL(4,0),
CATEGORY_NUM DECIMAL(4,0),
DESCRIPTION VARCHAR(40),
STATUS VARCHAR(40),
EST_HOURS DECIMAL(4,2),
SPENT_HOURS DECIMAL(4,2),
NEXT_SERVICE_DATE DATE);

[back to top]

Insert SOLMARIS Table Statements

INSERT INTO LOCATION

VALUES

(1,’Solmaris Ocean’,’100 Ocean Ave.’,’Bowton’,’FL’,’31313′);

INSERT INTO LOCATION

VALUES

(2,’Solmaris Bayside’,’405 Bayside Blvd.’,’Glander Bay’,’FL’,’31044′);

INSERT INTO OWNER

VALUES

(‘AD057′,’Adney’,’Bruce and Jean’,’100 Ocean Ave.’,’Bowton’,’FL’,’31313′);

INSERT INTO OWNER

VALUES

(‘AN175′,’Anderson’,’Bill’,’18Wilcox St.’,’Brunswick’,’GA’,’31522′);

INSERT INTO OWNER

VALUES

(‘BL720′,’Blake’,’Jack’,’267 Condor St.’,’Mills’,’SC’,’29707′);

INSERT INTO OWNER

VALUES

(‘EL025′,’Elend’,’Bill and Sandy’,’100 Ocean Ave.’,’Bowton’,’FL’,’31313′);

INSERT INTO OWNER

VALUES

(‘FE182′,’Feenstra’,’Daniel’,’7822 Coventry Dr.’,’Rivard’,’FL’,’31062′);

INSERT INTO OWNER

VALUES

(‘JU092′,’Juarez’,’Maria’,’892 Oak St.’,’Kaleva’,’FL’,’31521′);

INSERT INTO OWNER

VALUES

(‘KE122′,’Kelly’,’Alyssa’,’527 Waters St.’,’Norton’,’MI’,’49441′);

INSERT INTO OWNER

VALUES

(‘NO225′,’Norton’,’Peter and Caitlin’,’281 Lakewood Ave.’,’Lawndale’,’PA’,’19111′);

INSERT INTO OWNER

VALUES

(‘RO123′,’Robinson’,’Mike and Jane’,’900 Spring Lake Dr.’,’Springs’,’MI’,’49456′);

INSERT INTO OWNER

VALUES

(‘SM072′,’Smeltz’,’Jim and Cathy’,’922 Garland Dr.’,’Lewiston’,’FL’,’31313′);

INSERT INTO OWNER

VALUES

(‘TR222′,’Trent’,’Michael’,’405 Bayside Blvd.’,’Glander Bay’,’FL’,’31044′);

INSERT INTO OWNER

VALUES

(‘WS032′,’Wilson’,’Henry and Karen’,’25 Nichols St.’,’Lewiston’,’FL’,’32765′);

INSERT INTO SERVICE_CATEGORY

VALUES

(1,’Plumbing’);

INSERT INTO SERVICE_CATEGORY

VALUES

(2,’Heating/Air Conditioning’);

INSERT INTO SERVICE_CATEGORY

VALUES

(3,’Painting’);

INSERT INTO SERVICE_CATEGORY

VALUES

(4,’Electrical Systems’);

INSERT INTO SERVICE_CATEGORY

VALUES

(5,’Carpentry’);

INSERT INTO SERVICE_CATEGORY

VALUES

(6,’Janitorial’);

INSERT INTO CONDO_UNIT

VALUES

(1,1,’102′,675,1,1,475,’AD057′);

INSERT INTO CONDO_UNIT

VALUES

(2,1,’201′,1030,2,1,550,’EL025′);

INSERT INTO CONDO_UNIT

VALUES

(3,1,’306′,1575,3,2,625,’AN175′);

INSERT INTO CONDO_UNIT

VALUES

(4,1,’204′,1164,2,2,575,’BL720′);

INSERT INTO CONDO_UNIT

VALUES

(5,1,’405′,1575,3,2,625,’FE182′);

INSERT INTO CONDO_UNIT

VALUES

(6,1,’401′,1030,2,2,550,’KE122′);

INSERT INTO CONDO_UNIT

VALUES

(7,1,’502′,745,1,1,490,’JU092′);

INSERT INTO CONDO_UNIT

VALUES

(8,1,’503′,1680,3,3,670,’RO123′);

INSERT INTO CONDO_UNIT

VALUES

(9,2,’A03′,725,1,1,190,’TR222′);

INSERT INTO CONDO_UNIT

VALUES

(10,2,’A01′,1084,2,1,235,’NO225′);

INSERT INTO CONDO_UNIT

VALUES

(11,2,’B01′,1084,2,2,250,’SM075′);

INSERT INTO CONDO_UNIT

VALUES

(12,2,’C01′,750,1,1,190,’AN175′);

INSERT INTO CONDO_UNIT

VALUES

(13,2,’C02′,1245,2,2,250,’WS032′);

INSERT INTO CONDO_UNIT

VALUES

(14,2,’C06′,1540,3,2,300,’RO123′);

INSERT INTO SERVICE_REQUEST

VALUES

(1,2,1,’Back wall in pantry has mold.’,4,2,’12-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(2,5,2,’Air conditioner does not cool.’,’Air cond contractor has been called.’,3,1,’12-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(3,4,6,’Hardwood floors must be refinished.’,’Service call has been scheduled.’,8,0,’16-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(4,1,4,’Kitchen switches and adjoining dining room are reversed.’,’Open’,1,0,’13-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(5,2,5,’Molding in pantry must be replaced.’,’Can not schedule until water leak is corrected.’,2,0,”);

INSERT INTO SERVICE_REQUEST

VALUES

(6,14,3,’Unit needs to be re-painted due to previous tenant damage.’,’Scheduled’,7,0,’19-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(7,11,4,’Tenant complained microwave caused short circuits on two occasions.’,’Service rep unable to duplicate the problem.’,1,1,”);

INSERT INTO SERVICE_REQUEST

VALUES

(8,9,3,’Kitchen must be repainted.  Walls discolored due to kitchen fire.’,’Scheduled’,5,0,’16-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(9,7,6,’Shampoo all carpets’,’Open’,5,0,’19-OCT-2015′);

INSERT INTO SERVICE_REQUEST

VALUES

(10,9,5,’Repair window sills’,’Scheduled’,4,0,’20-OCT-2015′);

[back to top]

COLONIAL TABLES

Create COLONIAL Table Statements

CREATE TABLE GUIDE
(GUIDE_NUM CHAR(4) PRIMARY KEY,
LAST_NAME CHAR(15),
FIRST_NAME CHAR(15),
ADDRESS CHAR(25),
CITY CHAR(25),
STATE CHAR(2),
POSTAL_CODE CHAR(5),
PHONE_NUM CHAR(12),
HIRE_DATE DATE);

CREATE TABLE TRIP
(TRIP_ID DECIMAL(3,0) PRIMARY KEY,
TRIP_NAME CHAR(25),
START_LOCATION CHAR(25),
STATE CHAR(2),
DISTANCE DECIMAL(4,0),
MAX_GRP_SIZE DECIMAL(4,0),
TYPE CHAR(20),
SEASON CHAR(20) );

CREATE TABLE TRIP_CUSTOMER
(CUSTOMER_NUM CHAR(4) PRIMARY KEY,
LAST_NAME CHAR(30),
FIRST_NAME CHAR(30),
ADDRESS CHAR(35),
CITY CHAR(35),
STATE CHAR(2),
POSTAL_CODE CHAR(5),
PHONE CHAR(12) );

CREATE TABLE RESERVATION
(RESERVATION_ID CHAR(7) PRIMARY KEY,
TRIP_ID DECIMAL(3,0),
TRIP_DATE DATE,
NUM_PERSONS DECIMAL(3,0),
TRIP_PRICE DECIMAL(6,2),
OTHER_FEES DECIMAL(6,2),
CUSTOMER_NUM CHAR(4) );

CREATE TABLE TRIP_GUIDES
(TRIP_ID DECIMAL(3,0),
GUIDE_NUM CHAR(4),
PRIMARY KEY(TRIP_ID, GUIDE_NUM) );

[back to top]

Insert COLONIAL Table Statements

INSERT INTO GUIDE
VALUES
(‘AM01′,’Abrams’, ‘Miles’,’54 Quest Ave.’,’Williamsburg’,’MA’,’01096′,’617-555-6032′,’3-JUN-2012′);
INSERT INTO GUIDE
VALUES
(‘BR01′,’Boyers’, ‘Rita’,’140 Oakton Rd.’,’Jaffrey’,’MA’,’03452′,’603-555-2134′,’4-MAR-2012′);
INSERT INTO GUIDE
VALUES
(‘DH01′,’Devon’, ‘Harley’,’Old Ranch Rd.’,’Sunderland’,’MA’,’01375′,’781-555-7767′,’8-JAN-2012′);
INSERT INTO GUIDE
VALUES
(‘GZ01′,’Gregory’, ‘Zach’,’7 Moose Head Rd.’,’Dummer’,’NH’,’03588′,’603-555-8765′,’4-NOV-2012′);
INSERT INTO GUIDE
VALUES
(‘KS01′,’Kiley’, ‘Susan’,’943 Oakton Rd.’,’Jaffrey’,’NH’,’03452′,’603-555-1230′,’8-APR-2013′);
INSERT INTO GUIDE
VALUES
(‘KS02′,’Kelly’, ‘Sam’,’9 Congaree Ave.’,’Franconia’,’NH’,’03580′,’603-555-0003′,’10-JUN-2013′);
INSERT INTO GUIDE
VALUES
(‘MR01′,’Marston’, ‘Ray’,’24 Shenandoah Rd.’,’Springfield’,’MA’,’01101′,’781-555-2323′,’14-SEP-2015′);
INSERT INTO GUIDE
VALUES
(‘RH01′,’Rowan’, ‘Hal’,’12 Heather Rd.’,’Mount Desert’,’ME’,’04660′,’207-555-9009′,’2-JUN-2014′);
INSERT INTO GUIDE
VALUES
(‘SL01′,’Stevens’, ‘Lori’,’15 Riverton Rd.’,’Coventry’,’VT’,’05825′,’802-555-3339′,’5-SEP-2014′);
INSERT INTO GUIDE
VALUES
(‘UG01′,’Unser’, ‘Glory’,’342 Pineview St.’,’Danbury’,’CT’,’06810′,’203-555-8534′,’2-FEB-2015′);

INSERT INTO TRIP
VALUES
(1,’Arethusa Falls’, ‘Harris Location’,’NH’,5,10,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(2,’Mt Ascutney – North Peak’, ‘Weatherfield’,’VT’,5,6,’Hiking’,’Late Spring’);
INSERT INTO TRIP
VALUES
(3,’Mt Ascutney – West Peak’, ‘Weatherfield’,’VT’,6,10,’Hiking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(4,’Bradbury Mountain Ride’, ‘Lewiston-Auburn’,’Me’,25,8,’Biking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(5,’Baldpate Mountain’, ‘North Newry’,’Me’,6,10,’Hiking’,’Late Spring’);
INSERT INTO TRIP
VALUES
(6,’Blueberry Mountain’, ‘Batchelders Grant’,’Me’,8,8,’Hiking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(7,’Bloomfield – Maidstone’, ‘Bloomfield’,’CT’,10,6,’Paddling’,’Late Spring’);
INSERT INTO TRIP
VALUES
(8,’Black Pond’, ‘Lincoln’,’NH’,8,12,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(9,’Big Rock Cave’, ‘Tamworth’,’NH’,6,10,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(10,’Mt Cardigan – Firescrew’, ‘Orange’,’NH’,7,8,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(11,’Chocorua Lake Tour’, ‘Tamworth’,’NH’,12,15,’Paddling’,’Summer’);
INSERT INTO TRIP
VALUES
(12,’Cadillac Mountain Ride’, ‘Bar Harbor’,’ME’,8,16,’Biking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(13,’Cadillac Mountain’, ‘Bar Harbor’,’ME’,7,8,’Hiking’,’Late Spring’);
INSERT INTO TRIP
VALUES
(14,’Camnon Mtn’, ‘Franconia’,’NH’,6,6,’Hiking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(15,’Crawford Path Presidentials Hike’, ‘Crawford Notch’,’NH’,16,4,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(16,’Cherry Pond’, ‘Whitefield’,’NH’,6,16,’Hiking’,’Spring’);
INSERT INTO TRIP
VALUES
(17,’Huguenot Head Hike’, ‘Bar Harbor’,’ME’,5,10,’Hiking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(18,’Low Bald Spot Hike’, ‘Pinkam Notch’,’NH’,8,6,’Hiking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(19,’Mason”s Farm’, ‘North Stradford’,’CT’,12,7,’Paddling’,’Late Spring’);
INSERT INTO TRIP
VALUES
(20,’Lake Mephremagog Tour’, ‘Newport’,’VT’,8,15,’Paddling’,’Late Spring’);
INSERT INTO TRIP
VALUES
(21,’Long Pond’, ‘Rutland’,’MA’,8,12,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(22,’Long Pond Tour’, ‘Greenville’,’ME’,12,10,’Paddling’,’Summer’);
INSERT INTO TRIP
VALUES
(23,’Lower Pond Tour’, ‘Poland’,’ME’,8,15,’Paddling’,’Late Spring’);
INSERT INTO TRIP
VALUES
(24,’Mt. Adams’, ‘Randolph’,’NH’,9,6,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(25,’Mount Battle Ride’, ‘Camden’,’Me’,20,8,’Biking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(26,’Mount Cardigan Hike’, ‘Cardigan’,’NH’,4,16,’Hiking’,’Late Fall’);
INSERT INTO TRIP
VALUES
(27,’Mt Chocorua’, ‘Albany’,’NH’,6,10,’Hiking’,’Spring’);
INSERT INTO TRIP
VALUES
(28,’Mt Garfield Hike’, ‘Woodstock’,’NH’,5,10,’Hiking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(29,’Metacomet – Monadnock Trail Hike’, ‘Pelham’,’MA’,10,12,’Hiking’,’Lake Spring’);
INSERT INTO TRIP
VALUES
(30,’McLennan Reservation Hike’, ‘Tyringham’,’MA’,6,16,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(31,’Missisquoi River – VT’, ‘Lowell’,’VT’,12,10,’Paddling’,’Summer’);
INSERT INTO TRIP
VALUES
(32,’Northern Forest Canoe Trail’, ‘Stark’,’NH’,15,10,’Paddling’,’Summer’);
INSERT INTO TRIP
VALUES
(33,’Park Loop Ride’, ‘Mount Desert Island’,’ME’,27,8,’Biking’,’Late Spring’);
INSERT INTO TRIP
VALUES
(34,’Pontook Reservoir Tour’, ‘Dummer’,’NH’,15,14,’Paddling’,’Late Spring’);
INSERT INTO TRIP
VALUES
(35,’Pisgah State Park Ride’, ‘NorthBorough’,’NH’,12,10,’Biking’,’Summer’);
INSERT INTO TRIP
VALUES
(36,’Pondcherry Trail Ride’, ‘White Mountains’,’NH’,15,16,’Biking’,’Late Spring’);
INSERT INTO TRIP
VALUES
(37,’Seal Beach Harbor’, ‘Bar Harbor’,’ME’,5,16,’Hiking’,’Early Spring’);
INSERT INTO TRIP
VALUES
(38,’Sawyer River Ride’, ‘Mount Carrigain’,’NH’,10,18,’Biking’,’Early Fall’);
INSERT INTO TRIP
VALUES
(39,’Welch and Dickey Mountains Hike’, ‘Thorton’,’NH’,5,10,’Hiking’,’Summer’);
INSERT INTO TRIP
VALUES
(40,’Wachusett Mountain’, ‘Princeton’,’MA’,8,8,’Hiking’,’Early Spring’);
INSERT INTO TRIP
VALUES
(41,’Westfield River Loop’, ‘Port Fairfield’,’ME’,20,10,’Biking’,’Late Spring’);

INSERT INTO TRIP_CUSTOMER
VALUES
(‘101′,’Northfold’,’Liam’,’9 Old Mill Rd.’,’Londonderry’,’NH’,’03053′,’603-555-7563′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘102′,’Ocean’,’Arnold’,’2332 South St. Apt 3′,’Springfield’,’MA’,’01101′,’413-555-3212′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘103′,’Kasuma’,’Sujata’,’132 Main St. #1′,’East Hartford’,’CT’,’06108′,’860-555-0703′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘104′,’Goff’,’Ryan’,’164 South Bend Rd.’,’Lowell’,’MA’,’01854′,’781-555-8423′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘105′,’McLean’,’Kyle’,’345 Lower Ave.’,’Wolcott’,’NY’,’14590′,’585-555-5321′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘106′,’Morontoia’,’Joseph’,’156 Scholar St..’,’Johnston’,’RI’,’02919′,’401-555-4848′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘107′,’Marchand’,’Quinn’,’76 Cross Rd.’,’Bath’,’NH’,’03740′,’603-555-0456′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘108′,’Rulfd’,’Uschi’,’32 Sheep Stop St.’,’Edinboro’,’PA’,’16412′,’814-555-5521′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘109′,’Caron’,’Jean Luc’,’10 Greenfield St.’,’Rome’,’ME’,’04963′,’207-555-9643′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘110′,’Bers’,’Martha’,’65 Granite St.’,’York’,’NY’,’14592′,’585-555-0111′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘112′,’Jones’,’Laura’,’373 Highland Ave.’,’Somerville’,’MA’,’02143′,’857-555-6258′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘115′,’Vaccari’,’Adam’,’128 Ocean Walk’,’Ocean City’,’NJ’,’08226′,’609-555-5231′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘116′,’Marukami’,’Iris’,’7 Cherry Blossom St.’,’Weymouth’,’MA’,’02188′,’617-555-6665′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘119′,’Chau’,’Clement’,’18 Ark Ledge Ln.’,’Londonderry’,’VT’,’05148′,’802-555-3096′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘120′,’Gernowski’,’Sadie’,’24 Stump Rd.’,’Athens’,’ME’,’04912′,’207-555-4507′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘121′,’Bretton-Borak’,’Siam’,’10 Old Main St.’,’Cambridge’,’VT’,’05444′,’802-555-3443′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘122′,’Hefferson’,’Orlauh’,’132 South St. Apt 27′,’Manchester’,’NH’,’03101′,’603-555-3476′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘123′,’Barnett’,’Larry’,’25 Stag rd.’,’Fairfield’,’CT’,’06824′,’860-555-9876′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘124′,’Busa’,’Karen’,’12 Foster St.’,’South Windsor’,’CT’,’06074′,’857-555-5532′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘125′,’Peterson’,’Becca’,’51 Fredrick St.’,’Albany’,’NY’,’14411′,’585-555-0900′);
INSERT INTO TRIP_CUSTOMER
VALUES
(‘126′,’Brown’,’Brianne’,’154 Central St.’,’Vernon’,’CT’,’06066′,’806-555-3234′);

INSERT INTO TRIP_GUIDES VALUES (1,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (1,’RH01′);
INSERT INTO TRIP_GUIDES VALUES (2,’AM01′);
INSERT INTO TRIP_GUIDES VALUES (2,’SL01′);
INSERT INTO TRIP_GUIDES VALUES (3,’SL01′);
INSERT INTO TRIP_GUIDES VALUES (4,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (4,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (5,’KS01′);
INSERT INTO TRIP_GUIDES VALUES (5,’UG01′);
INSERT INTO TRIP_GUIDES VALUES (6,’RH01′);
INSERT INTO TRIP_GUIDES VALUES (7,’SL01′);
INSERT INTO TRIP_GUIDES VALUES (8,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (9,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (10,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (11,’DH01′);
INSERT INTO TRIP_GUIDES VALUES (11,’KS01′);
INSERT INTO TRIP_GUIDES VALUES (11,’UG01′);
INSERT INTO TRIP_GUIDES VALUES (12,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (13,’RH01′);
INSERT INTO TRIP_GUIDES VALUES (14,’KS02′);
INSERT INTO TRIP_GUIDES VALUES (15,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (16,’KS02′);
INSERT INTO TRIP_GUIDES VALUES (17,’RH01′);
INSERT INTO TRIP_GUIDES VALUES (18,’KS02′);
INSERT INTO TRIP_GUIDES VALUES (19,’DH01′);
INSERT INTO TRIP_GUIDES VALUES (20,’SL01′);
INSERT INTO TRIP_GUIDES VALUES (21,’AM01′);
INSERT INTO TRIP_GUIDES VALUES (22,’UG01′);
INSERT INTO TRIP_GUIDES VALUES (23,’DH01′);
INSERT INTO TRIP_GUIDES VALUES (23,’SL01′);
INSERT INTO TRIP_GUIDES VALUES (24,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (25,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (26,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (27,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (28,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (29,’DH01′);
INSERT INTO TRIP_GUIDES VALUES (30,’AM01′);
INSERT INTO TRIP_GUIDES VALUES (31,’SL01′);
INSERT INTO TRIP_GUIDES VALUES (32,’KS01′);
INSERT INTO TRIP_GUIDES VALUES (33,’UG01′);
INSERT INTO TRIP_GUIDES VALUES (34,’KS01′);
INSERT INTO TRIP_GUIDES VALUES (35,’GZ01′);
INSERT INTO TRIP_GUIDES VALUES (36,’KS02′);
INSERT INTO TRIP_GUIDES VALUES (37,’RH01′);
INSERT INTO TRIP_GUIDES VALUES (38,’KS02′);
INSERT INTO TRIP_GUIDES VALUES (39,’BR01′);
INSERT INTO TRIP_GUIDES VALUES (40,’DH01′);
INSERT INTO TRIP_GUIDES VALUES (41,’BR01′);

INSERT INTO RESERVATION VALUES (‘1600001′,40,’26-MAR-2016′,2,55.00,0.00,’101’);
INSERT INTO RESERVATION VALUES (‘1600002′,21,’8-JUN-2016′,2,95.00,0.00,’101’);
INSERT INTO RESERVATION VALUES (‘1600003′,28,’12-SEP-2016′,1,35.00,0.00,’103’);
INSERT INTO RESERVATION VALUES (‘1600004′,26,’16-OCT-2016′,4,45.00,15.00,’104’);
INSERT INTO RESERVATION VALUES (‘1600005′,39,’25-JUN-2016′,5,55.00,0.00,’105’);
INSERT INTO RESERVATION VALUES (‘1600006′,32,’18-JUN-2016′,1,80.00,20.00,’106’);
INSERT INTO RESERVATION VALUES (‘1600007′,22,’9-JUL-2016′,8,75.00,10.00,’107’);
INSERT INTO RESERVATION VALUES (‘1600008′,28,’12-SEP-2016′,2,35.00,0.00,’108’);
INSERT INTO RESERVATION VALUES (‘1600009′,38,’11-SEP-2016′,2,90.00,40.00,’109’);
INSERT INTO RESERVATION VALUES (‘1600010′,2,’14-MAY-2016′,3,25.00,0.00,’102’);
INSERT INTO RESERVATION VALUES (‘1600011′,3,’15-SEP-2016′,3,25.00,0.00,’102’);
INSERT INTO RESERVATION VALUES (‘1600012′,1,’12-JUN-2016′,4,15.00,0.00,’115’);
INSERT INTO RESERVATION VALUES (‘1600013′,8,’9-JUL-2016′,1,20.00,5.00,’116’);
INSERT INTO RESERVATION VALUES (‘1600014′,12,’1-OCT-2016′,2,40.00,5.00,’119’);
INSERT INTO RESERVATION VALUES (‘1600015′,10,’23-JUL-2016′,1,20.00,0.00,’120’);
INSERT INTO RESERVATION VALUES (‘1600016′,11,’23-JUL-2016′,6,75.00,15.00,’121’);
INSERT INTO RESERVATION VALUES (‘1600017′,39,’18-JUN-2016′,3,20.00,5.00,’122’);
INSERT INTO RESERVATION VALUES (‘1600018′,38,’18-SEP-2016′,4,85.00,15.00,’126’);
INSERT INTO RESERVATION VALUES (‘1600019′,25,’29-AUG-2016′,2,110.00,25.00,’124’);
INSERT INTO RESERVATION VALUES (‘1600020′,28,’27-AUG-2016′,2,35.00,10.00,’124’);
INSERT INTO RESERVATION VALUES (‘1600021′,32,’11-JUN-2016′,3,90.00,20.00,’112’);
INSERT INTO RESERVATION VALUES (‘1600022′,21,’8-JUN-2016′,1,95.00,25.00,’119’);
INSERT INTO RESERVATION VALUES (‘1600024′,38,’11-NOV-2016′,1,70.00,30.00,’121’);
INSERT INTO RESERVATION VALUES (‘1600025′,38,’11-NOV-2016′,2,70.00,45.00,’125’);
INSERT INTO RESERVATION VALUES (‘1600026′,40,’1-OCT-2016′,2,40.00,0.00,’126’);
INSERT INTO RESERVATION VALUES (‘1600029′,4,’19-SEP-2016′,4,105.00,25.00,’120’);
INSERT INTO RESERVATION VALUES (‘1600030′,15,’25-JUL-2016′,6,60.00,15.00,’104’);

[back to top]