Concerts Schema ERD

Concerts Schema ERD

Concerts Schema Creation Scripts

sqlplus system/system@test @createuser.sql
sqlplus concerts/concerts@test @utlxplan.sql --this is in $ORACLE_HOME/rdbms/admin
sqlplus concerts/concerts@test @schema.sql
sqlplus concerts/concerts@test @sequences.sql
sqlplus concerts/concerts@test @categories.sql
sqlplus concerts/concerts@test @venues.sql
sqlplus concerts/concerts@test @act.sql
sqlplus concerts/concerts@test @show.sql
sqlplus concerts/concerts@test @supportingact.sql

createuser.sql


spool log\createUser.log;
drop user concerts cascade;
create user concerts identified by concerts
default tablespace data
temporary tablespace temp
quota unlimited on data
quota unlimited on INDX
quota unlimited on objects
quota unlimited on temp;
grant connect,resource to concerts;
grant unlimited tablespace to concerts;
grant query rewrite to concerts;
spool off;
exit;

schema.sql


spool log\schema.log;

CREATE TABLE Category (
       category_id          		NUMBER NOT NULL,
       name                 		VARCHAR2(64) NULL,
       parent_id            		NUMBER NULL,
       CONSTRAINT XPKCategory		PRIMARY KEY (category_id) USING INDEX TABLESPACE INDX, 
       CONSTRAINT FKCategory1		FOREIGN KEY (parent_id) REFERENCES Category
) TABLESPACE DATA;
CREATE INDEX XFKCategory1 ON Category(parent_id) TABLESPACE INDX;

CREATE TABLE Venue (
       venue_id             		NUMBER NOT NULL,
       name                 		VARCHAR2(64) NULL,
       city                 		VARCHAR2(32) NULL,
       state                		CHAR(2) NULL,
       country              		VARCHAR2(32) NULL,
       CONSTRAINT XPKVenue		PRIMARY KEY (venue_id) USING INDEX TABLESPACE INDX,
       CONSTRAINT XAKVenue1		UNIQUE (name) USING INDEX TABLESPACE INDX
) TABLESPACE DATA;

CREATE TABLE Act (
       act_id               		NUMBER NOT NULL,
       name                 		VARCHAR2(64) NULL,
       CONSTRAINT XPKAct 		PRIMARY KEY (act_id) USING INDEX TABLESPACE INDX,
       CONSTRAINT XAKAct1		UNIQUE (name) USING INDEX TABLESPACE INDX
) TABLESPACE DATA;

CREATE TABLE Show (
       show_id              		NUMBER NOT NULL,
       category_id          		NUMBER NOT NULL,
       act_id               		NUMBER NOT NULL,
       venue_id             		NUMBER NOT NULL,
       showdate             		DATE NULL,
       CONSTRAINT XPKShow 		PRIMARY KEY (show_id) USING INDEX TABLESPACE INDX, 
       CONSTRAINT FKShow1		FOREIGN KEY (category_id) REFERENCES Category, 
       CONSTRAINT FKShow2		FOREIGN KEY (venue_id) REFERENCES Venue, 
       CONSTRAINT FKShow3		FOREIGN KEY (act_id) REFERENCES Act
) TABLESPACE DATA;
CREATE INDEX XFKShow1 ON Show(act_id) TABLESPACE INDX;
CREATE INDEX XFKShow2 ON Show(venue_id) TABLESPACE INDX;
CREATE INDEX XFXShow3 ON Show(category_id) TABLESPACE INDX;

CREATE TABLE SupportingAct (
       act_id               		NUMBER NOT NULL,
       show_id              		NUMBER NOT NULL,
       CONSTRAINT XPKSupportingAct 	PRIMARY KEY (act_id, show_id) USING INDEX TABLESPACE INDX, 
       CONSTRAINT FKSupportingAct1	FOREIGN KEY (show_id) REFERENCES Show, 
       CONSTRAINT FKSupportingAct2	FOREIGN KEY (act_id) REFERENCES Act
) TABLESPACE DATA;
CREATE INDEX XFKSupportingAct1 ON SupportingAct(act_id) TABLESPACE INDX;
CREATE INDEX XFKSupportingAct2 ON SupportingAct(show_id) TABLESPACE INDX;

CREATE TABLE Price (
       price_id             		NUMBER NOT NULL,
       price                		NUMBER(7,2) NULL,
       CONSTRAINT XPKPrice 		PRIMARY KEY (price_id) USING INDEX TABLESPACE INDX,
       CONSTRAINT XAKPrice1		UNIQUE (price) USING INDEX TABLESPACE INDX
) TABLESPACE DATA;

CREATE TABLE Ticket (
       ticket_id            		NUMBER NOT NULL,
       show_id              		NUMBER NOT NULL,
       price_id             		NUMBER NOT NULL,
       seat#                		CHAR(8) NULL,
       CONSTRAINT XPKTicket 		PRIMARY KEY (ticket_id) USING INDEX TABLESPACE INDX, 
       CONSTRAINT FKTicket1		FOREIGN KEY (show_id) REFERENCES Show, 
       CONSTRAINT FKTicket2		FOREIGN KEY (price_id) REFERENCES Price,
       CONSTRAINT XAKTicket1		UNIQUE (seat#) USING INDEX TABLESPACE INDX
) TABLESPACE DATA;
CREATE INDEX XFKTicket1 ON Ticket(price_id) TABLESPACE INDX;
CREATE INDEX XFKTicket2 ON Ticket(show_id) TABLESPACE INDX;

spool off;
exit;

sequences.sql


set timing off;
spool log\sequences.log;
create sequence category_seq start with 1 increment by 1 nomaxvalue nocycle;
create sequence act_seq start with 1 increment by 1 nomaxvalue nocycle;
create sequence show_seq start with 1 increment by 1 nomaxvalue nocycle;
create sequence venue_seq start with 1 increment by 1 nomaxvalue nocycle;
create sequence ticket_seq start with 1 increment by 1 nomaxvalue nocycle;
create sequence price_seq start with 1 increment by 1 nomaxvalue nocycle;
spool off;
exit;

categories.sql


spool log\categories.log;

insert into category(category_id,name) values(category_seq.nextval,'Concerts');
insert into category(category_id,name) values(category_seq.nextval,'Sports');
insert into category(category_id,name) values(category_seq.nextval,'Arts and Theatre');
insert into category(category_id,name) values(category_seq.nextval,'Family');

insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Alternative Rock');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Comedy');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Country/Folk');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Jazz/Blues');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Latin');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'New Age/Spiritual');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Oldies');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Rock/Popular');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'Urban');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Concerts'),'World Music');

insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Baseball');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Basketball');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Boxing');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Football');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Golf');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Hockey');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Motorsports');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Soccer');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Tennis');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Sports'),'Wrestling');

insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Arts and Theatre'),'Ballet/Dance');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Arts and Theatre'),'Classical/Opera');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Arts and Theatre'),'Museums');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Arts and Theatre'),'Theatre');

insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Family'),'Children''s Music and Theatre');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Family'),'Circus');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Family'),'Family Attractions');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Family'),'Ice Shows');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Family'),'Rodeo');
insert into category(category_id,parent_id,name) values(category_seq.nextval,(select category_id from category where name='Family'),'Ski Passes');

commit;
spool off;
exit;

venues.sql

spool log\venues.log;
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'3com Park','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Agenda Lounge','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Altamont Raceway Park','Tracy','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Amador Theatre','Pleasanton','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Arco Arena','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Argent Hotel','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'AutoWest Amphitheatre Formerly Sacramento Valley Amphitheatre','Marysville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Backflip','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Bay Meadows Racetrack','San Mateo','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Berkeley Community Theatre','Berkeley','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Best of Broadway','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Bill Graham Civic Auditorium','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Black Oak Ranch','Laytonville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Bohemia Digital Moviehouse','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Boreal Ski Resort','Truckee','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'BR Cohn Winery','Glen Ellen','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Caesars Tahoe South','Lake Tahoe','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Caesars Tahoe Grand Ballroom','South Lake Tahoe','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'California Ball Room','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'California Palace of the Legion of Honor','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Calveras County Fairgrounds','Angels Camp','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Calvin Simmons Theatre','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Casino San Pablo','San Pablo','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Castro Theater','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Cat Club','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Chico Fairgrounds','Chico','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Chronicle Pavilion At Concord','Concord','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Cinema 9','Santa Cruz','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Cinequest San Jose Film Festival','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Club Monaco','Sunnyvale','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Club Wild','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Colonial Theatre','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Compaq Center','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Consortium','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Cosumnes River College','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'The Cove At Cal Expo','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Cow Palace','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Coyote Creek Golf Club','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Crest Theatre','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Crusher Stadium','Rohnert Park','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Curran Theatre','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Dan Foley Cultural Center','Vallejo','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Dandrea Golf and Country Club','Sparks','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Davies Hall','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Delancey Streeet Theater','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Discovery Meadow','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Discovery Park','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Dominican College','San Rafael','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Douglas County Fairgrounds','Gardnerville','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Expression Center for New Media','Emeryville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Feather Falls Casino','Oroville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fillmore','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fine Arts Cinema','Berkeley','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Flint Center','Cupertino','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Foothill College Stadium','Los Altos Hills','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fort Mason Festival Pavilion','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fox Theatre','Redwood City','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fresno Convention Center','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fresno Convention Center Exhibit Hall','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fresno Fairgrounds','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fresno International Air Terminal','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Fresno State Amphitheatre','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Frogtown','Angels Camp','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Galleria Design Center','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Gift Center','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Glas Kat Supper Club','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Gold Country Casino','Oroville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Golden Gate Park','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Golden Gate Theatre','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Granite Bay At Folsom Lake','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Greek Theatre-U.C. Berkeley','Berkeley','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Harveys Outdoor Amphitheatre At','Lake Tahoe Stateline','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Henry J Kaiser Arena','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Henry J Mello Center','Watsonville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Herbst Pavilion At Fort Mason','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Holiday Inn Northeast-Sacramento','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Hyatt Burlingame','Burlingame','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Hyatt Regency - Embarcadero','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Icon Nightclub','Palo Alto','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Indie Fest','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Indigo','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Ironstone Winery','Murphys','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Jackson Rancheria Hotel and Casino','Jackson','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Johanson High School','Modesto','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Lagoon Park Marin Center','Marin','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Laguna Seca Recreation Area','Monterey','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Laugh House','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Lavash Mediterranean Bistro','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Ledson Winery','Santa Rosa','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Leisl''s Wet Dress Pound','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Lumiere Theatre','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Marin Showcase Theatre','San Rafael','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Marin Veterans Memorial Auditorium','San Rafael','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Mission High School','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Mission Santa Clara De Asis','Santa Clara','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Modesto Junior College Stadium','Modesto','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Moto X and Music Fest Pier 30/32','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Monterey Fairgrounds','Monterey','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Montreux Golf and Country Club','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Mountain Winery','Saratoga','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'New College of California Theater','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'New Oasis','Sparks','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Northstar At Tahoe','Truckee','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Oak Meadow Park','Los Gatos','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Oakport Street','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Opera By the Bay','Sausalito','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Orpheum Theatre','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Pacific Bell Park','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Palace of Fine Arts','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Paradise Performing Art Center','Paradise','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Paramount Theatre','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Parkway Theater','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Pebble Beach Golf Links','Monterey','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Pier 30/32','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Pioneer Center','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Placerville Speedway','Placerville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Pound','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Punch Line Comedy Club - San Francisco','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Punch Line Comedy Club - Sacramento','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Radisson Hotel','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Rainbow Ballroom','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Red Hawk Golf Course','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Redding Convention Center','Redding','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Redwood Amphitheatre At Paramounts Great America','Santa Clara','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Reno Hilton Amphitheatre','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Reno Hilton Pavilion','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Reno Hilton Theatre','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Reno Livestock Events Center','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Reno Stead Airport','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Richmond Memorial Auditorium','Richmond','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Ritz-Carlton Ballroom','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Roxie Cinema','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Sacramento Convention Center Exhibit Hall','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Salinas Sports Complex','Salinas','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'San Joaquin Delta College','Stockton','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'San Jose Center for the Performing Arts','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'San Jose Convention Center','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'San Jose Municipal Stadium','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'San Mateo County Expo Center','San Mateo','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'San Mateo Performing Arts Center','San Mateo','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Sank Park','Oroville','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Santa Clara Convention Center','Santa Clara','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Santa Clara County Fairgrounds','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Santa Cruz Civic Auditorium','Santa Cruz','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Scottish Rite Center','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Selland Arena At Fresno Convention Center','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Serrano Country Club','El Dorado Hills','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Sheraton Palo Alto Hotel','Palo Alto','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Shoreline Amphitheatre','Mountain View','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Sierra At Tahoe','Tahoe','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Silver Creek High School','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Silver State Pavilion','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Small Venue Fresno','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Small Venue Reno/Tahoe','Reno','NV','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Solar Living Center','Hopland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Sonoma Country Day School','Santa Rosa','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Spangenberg Theatre','Palo Alto','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Spartan Stadium','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Steinbeck Forum Conference Center','Monterey','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Studio Z','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Sweet Jimmies','Oakland','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Taube Family Tennis Stadium-Stanford','Palo Alto','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'UA Galaxy','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'The Usual','San Jose','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Vasona Lake County Park','Los Gatos','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Villa Montalvo','Saratoga','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'The W Hotel','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'War Memorial Opera House','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Warfield','San Francisco','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Warren Atherton Auditorium','Stockton','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Waterworld USA - Concord','Concord','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Waterworld USA - Sacramento','Sacramento','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Wente Vineyards','Livermore','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Wheeler Auditorium','Berkeley','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'William Saroyan Theatre At Fresno Convention Center','Fresno','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Yuba Sutter Fairgrounds','Yuba City','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Zellerbach Hall','Berkeley','CA','USA');
insert into venue(venue_id,name,city,state,country) values(venue_seq.nextval,'Zeum','San Francisco','CA','USA');
commit;
spool off;
exit;

act.sql

spool log\act.log;
insert into act(act_id,name) values(act_seq.nextval,'Paul McCartney');
insert into act(act_id,name) values(act_seq.nextval,'Tom Petty');
insert into act(act_id,name) values(act_seq.nextval,'Bob Dylan');
insert into act(act_id,name) values(act_seq.nextval,'Ray Charles');
insert into act(act_id,name) values(act_seq.nextval,'Joan Baez');
insert into act(act_id,name) values(act_seq.nextval,'Ozzfest');
insert into act(act_id,name) values(act_seq.nextval,'Foreigner');
insert into act(act_id,name) values(act_seq.nextval,'O-Town');
insert into act(act_id,name) values(act_seq.nextval,'Lenny Kravitz with P!NK and Abandoned Pools');
insert into act(act_id,name) values(act_seq.nextval,'Bruce Springsteen and the E Street Band');
insert into act(act_id,name) values(act_seq.nextval,'Michael Feinstein and the Israel Philharmonic Orchestra');
insert into act(act_id,name) values(act_seq.nextval,'Mike Tramp From White Lion');
insert into act(act_id,name) values(act_seq.nextval,'Neville Brothers');
insert into act(act_id,name) values(act_seq.nextval,'Doobie Brothers');
insert into act(act_id,name) values(act_seq.nextval,'Lenny Kravitz with Abandoned Pools');
insert into act(act_id,name) values(act_seq.nextval,'Rhythm and Doo Wop');
insert into act(act_id,name) values(act_seq.nextval,'Tony Bennett');
insert into act(act_id,name) values(act_seq.nextval,'Tom Petty and the Heartbreakers with Jackson Browne');
insert into act(act_id,name) values(act_seq.nextval,'Engelbert Humperdinck');
insert into act(act_id,name) values(act_seq.nextval,'Unwritten Law');
insert into act(act_id,name) values(act_seq.nextval,'Wilco');
insert into act(act_id,name) values(act_seq.nextval,'Karl Densons Tiny Universe');
insert into act(act_id,name) values(act_seq.nextval,'Punch Line Comedy Sessions');
insert into act(act_id,name) values(act_seq.nextval,'Dave Attell');
insert into act(act_id,name) values(act_seq.nextval,'Norm MacDonald and Kevin Nealon');
insert into act(act_id,name) values(act_seq.nextval,'Paul Mooney');
insert into act(act_id,name) values(act_seq.nextval,'Doghouse Comedy Jam');
insert into act(act_id,name) values(act_seq.nextval,'S. F. Comedy Showcase');
insert into act(act_id,name) values(act_seq.nextval,'Summer Comedy Session');
insert into act(act_id,name) values(act_seq.nextval,'Dennis Gaxiola');
insert into act(act_id,name) values(act_seq.nextval,'Freddy Soto');
insert into act(act_id,name) values(act_seq.nextval,'Tommy Davidson');
insert into act(act_id,name) values(act_seq.nextval,'Sinbad');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco Freestyle');
insert into act(act_id,name) values(act_seq.nextval,'IFMA Freestyle Motocross');
insert into act(act_id,name) values(act_seq.nextval,'Arenacross');
insert into act(act_id,name) values(act_seq.nextval,'Monster Jam');
insert into act(act_id,name) values(act_seq.nextval,'National Arenacross Series');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs San Diego Chargers');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Denver Broncos');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Washington Redskins');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs St Louis Rams');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Arizona Cardinals');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Kansas City Chiefs');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Philadelphia Eagles');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Seattle Seahawks');
insert into act(act_id,name) values(act_seq.nextval,'San Francisco 49ers vs Green Bay Packers');
insert into act(act_id,name) values(act_seq.nextval,'Mamma Mia');
insert into act(act_id,name) values(act_seq.nextval,'The Tale of the Allergist''s Wife');
insert into act(act_id,name) values(act_seq.nextval,'Disney On Ice');
insert into act(act_id,name) values(act_seq.nextval,'Disney On Ice 75 Years of Disney Magic');
insert into act(act_id,name) values(act_seq.nextval,'Champions On Ice');
insert into act(act_id,name) values(act_seq.nextval,'2002 Grand National Rodeo');
insert into act(act_id,name) values(act_seq.nextval,'Styx');
insert into act(act_id,name) values(act_seq.nextval,'Chicago');
insert into act(act_id,name) values(act_seq.nextval,'The Little River Band');
insert into act(act_id,name) values(act_seq.nextval,'Pat Benatar');
insert into act(act_id,name) values(act_seq.nextval,'Tony Joe White');
insert into act(act_id,name) values(act_seq.nextval,'Gladys Knight');
commit;
spool off;
exit;

show.sql

spool log\show.log;

insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Paul McCartney')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('08/19/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Paul McCartney')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('08/20/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Paul McCartney')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('08/21/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Paul McCartney')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('08/22/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ray Charles')
	,(select venue_id from venue where name='Wente Vineyards')
	,to_date('08/22/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ray Charles')
	,(select venue_id from venue where name='Mountain Winery')
	,to_date('08/23/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Joan Baez')
	,(select venue_id from venue where name='Villa Montalvo')
	,to_date('08/23/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ozzfest')
	,(select venue_id from venue where name='AutoWest Amphitheatre Formerly Sacramento Valley Amphitheatre')
	,to_date('08/24/02 9:00 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ray Charles')
	,(select venue_id from venue where name='Radisson Hotel')
	,to_date('08/24/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Foreigner')
	,(select venue_id from venue where name='Reno Hilton Theatre')
	,to_date('08/24/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ozzfest')
	,(select venue_id from venue where name='Shoreline Amphitheatre')
	,to_date('08/25/02 9:00 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ozzfest')
	,(select venue_id from venue where name='Shoreline Amphitheatre')
	,to_date('08/25/02','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Ray Charles')
	,(select venue_id from venue where name='Marin Veterans Memorial Auditorium')
	,to_date('08/25/02 3:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='O-Town')
	,(select venue_id from venue where name='Redwood Amphitheatre At Paramounts Great America')
	,to_date('08/25/02 7:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Lenny Kravitz with P!NK and Abandoned Pools')
	,(select venue_id from venue where name='Shoreline Amphitheatre')
	,to_date('08/26/02 7:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Bruce Springsteen and the E Street Band')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('08/27/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Michael Feinstein and the Israel Philharmonic Orchestra')
	,(select venue_id from venue where name='Shoreline Amphitheatre')
	,to_date('','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Mike Tramp From White Lion')
	,(select venue_id from venue where name='Leisl''s Wet Dress Pound')
	,to_date('08/27/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Joan Baez')
	,(select venue_id from venue where name='Wente Vineyards')
	,to_date('08/27/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Neville Brothers')
	,(select venue_id from venue where name='Mountain Winery')
	,to_date('08/28/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Doobie Brothers')
	,(select venue_id from venue where name='Wente Vineyards')
	,to_date('08/28/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Doobie Brothers')
	,(select venue_id from venue where name='Mountain Winery')
	,to_date('08/29/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Lenny Kravitz with Abandoned Pools')
	,(select venue_id from venue where name='AutoWest Amphitheatre Formerly Sacramento Valley Amphitheatre')
	,to_date('08/29/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Tom Petty and the Heartbreakers with Jackson Browne')
	,(select venue_id from venue where name='Reno Hilton Amphitheatre')
	,to_date('08/29/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Neville Brothers')
	,(select venue_id from venue where name='Wente Vineyards')
	,to_date('08/29/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Doobie Brothers')
	,(select venue_id from venue where name='Mountain Winery')
	,to_date('08/30/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Rhythm and Doo Wop')
	,(select venue_id from venue where name='Pioneer Center')
	,to_date('','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Tony Bennett')
	,(select venue_id from venue where name='Wente Vineyards')
	,to_date('08/30/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Tom Petty and the Heartbreakers with Jackson Browne')
	,(select venue_id from venue where name='AutoWest Amphitheatre Formerly Sacramento Valley Amphitheatre')
	,to_date('08/31/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Tom Petty and the Heartbreakers with Jackson Browne')
	,(select venue_id from venue where name='Chronicle Pavilion At Concord')
	,to_date('09/01/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Engelbert Humperdinck')
	,(select venue_id from venue where name='Wente Vineyards')
	,to_date('09/03/02 8:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Unwritten Law')
	,(select venue_id from venue where name='Icon Nightclub')
	,to_date('09/04/02 7:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Wilco')
	,(select venue_id from venue where name='Warfield')
	,to_date('09/06/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Karl Densons Tiny Universe')
	,(select venue_id from venue where name='Fillmore')
	,to_date('09/06/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Punch Line Comedy Sessions')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/22/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dave Attell')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/22/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Paul Mooney')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/23/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dave Attell')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/23/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Norm MacDonald and Kevin Nealon')
	,(select venue_id from venue where name='Caesars Tahoe South')
	,to_date('08/23/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Paul Mooney')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/23/02 10:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dave Attell')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/23/02 11:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Doghouse Comedy Jam')
	,(select venue_id from venue where name='Shoreline Amphitheatre')
	,to_date('08/24/02 7:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Paul Mooney')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/24/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dave Attell')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/24/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Norm MacDonald and Kevin Nealon')
	,(select venue_id from venue where name='Caesars Tahoe South')
	,to_date('08/24/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Paul Mooney')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/24/02 10:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dave Attell')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/24/02 11:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Paul Mooney')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/25/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='S. F. Comedy Showcase')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/25/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Summer Comedy Session')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/26/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dennis Gaxiola')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/27/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Freddy Soto')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/28/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dennis Gaxiola')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/28/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Freddy Soto')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/29/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Dennis Gaxiola')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/29/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Freddy Soto')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/30/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Tommy Davidson')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/30/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Freddy Soto')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/30/02 10:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Tommy Davidson')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/30/02 11:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Freddy Soto')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/31/02 8:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Sinbad')
	,(select venue_id from venue where name='Reno Hilton Theatre')
	,to_date('08/31/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Tommy Davidson')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/31/02 9:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Freddy Soto')
	,(select venue_id from venue where name='Punch Line Comedy Club - Sacramento')
	,to_date('08/31/02 10:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Comedy')
	,(select act_id from act where name='Tommy Davidson')
	,(select venue_id from venue where name='Punch Line Comedy Club - San Francisco')
	,to_date('08/31/02 11:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='San Francisco Freestyle')
	,(select venue_id from venue where name='Moto X and Music Fest Pier 30/32')
	,to_date('09/01/02 10:00 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='IFMA Freestyle Motocross')
	,(select venue_id from venue where name='Selland Arena At Fresno Convention Center')
	,to_date('10/04/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='IFMA Freestyle Motocross')
	,(select venue_id from venue where name='Selland Arena At Fresno Convention Center')
	,to_date('10/05/02','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='IFMA Freestyle Motocross')
	,(select venue_id from venue where name='Selland Arena At Fresno Convention Center')
	,to_date('10/05/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Arenacross')
	,(select venue_id from venue where name='Reno Livestock Events Center')
	,to_date('11/15/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Arenacross')
	,(select venue_id from venue where name='Reno Livestock Events Center')
	,to_date('11/16/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Arenacross')
	,(select venue_id from venue where name='Reno Livestock Events Center')
	,to_date('11/17/02 12:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Monster Jam')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('01/24/03 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Monster Jam')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('01/25/03 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Monster Jam')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('01/25/03','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='Monster Jam')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('01/25/03 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='National Arenacross Series')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('02/21/03 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='National Arenacross Series')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('02/22/03 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Motorsports')
	,(select act_id from act where name='National Arenacross Series')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('02/23/03 12:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs San Diego Chargers')
	,(select venue_id from venue where name='3com Park')
	,to_date('08/28/02 6:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Denver Broncos')
	,(select venue_id from venue where name='3com Park')
	,to_date('09/15/02 1:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Washington Redskins')
	,(select venue_id from venue where name='3com Park')
	,to_date('09/22/02 1:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs St Louis Rams')
	,(select venue_id from venue where name='3com Park')
	,to_date('10/06/02 1:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Arizona Cardinals')
	,(select venue_id from venue where name='3com Park')
	,to_date('10/27/02 1:05 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Kansas City Chiefs')
	,(select venue_id from venue where name='3com Park')
	,to_date('11/10/02 1:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Philadelphia Eagles')
	,(select venue_id from venue where name='3com Park')
	,to_date('11/25/02 6:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Seattle Seahawks')
	,(select venue_id from venue where name='3com Park')
	,to_date('12/01/02 1:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Football')
	,(select act_id from act where name='San Francisco 49ers vs Green Bay Packers')
	,(select venue_id from venue where name='3com Park')
	,to_date('12/15/02 1:15 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/22/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/22/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/23/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/23/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/24/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/24/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/24/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/24/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/25/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/25/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/25/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/27/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/27/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/28/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/28/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/28/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/29/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/29/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/30/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/30/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/31/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/31/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('08/31/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('08/31/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('09/01/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('09/01/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('09/01/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='Mamma Mia')
	,(select venue_id from venue where name='Orpheum Theatre')
	,to_date('09/03/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('09/03/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Theatre')
	,(select act_id from act where name='The Tale of the Allergist''s Wife')
	,(select venue_id from venue where name='Curran Theatre')
	,to_date('09/04/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/23/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/24/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/25/02 10:30 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/25/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/26/02 11:30 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/26/02 3:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/26/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/27/02 1:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('10/27/02 5:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('10/30/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('10/31/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/01/02 10:30 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/01/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/02/02 11:30 am','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/02/02 3:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/02/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/03/02 1:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Disney On Ice 75 Years of Disney Magic')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('11/03/02 5:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Champions On Ice')
	,(select venue_id from venue where name='Arco Arena')
	,to_date('05/28/03 7:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Ice Shows')
	,(select act_id from act where name='Champions On Ice')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('05/30/03 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('10/25/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('10/26/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('10/26/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('10/27/02 3:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('10/29/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('10/30/02 7:30 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('11/01/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('11/02/02 2:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('11/02/02 8:00 pm','MM/DD/YY HH:MI am')
);
insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rodeo')
	,(select act_id from act where name='2002 Grand National Rodeo')
	,(select venue_id from venue where name='Cow Palace')
	,to_date('11/03/02 3:00 pm','MM/DD/YY HH:MI am')
);

insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Styx')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('12/14/02 8:15 pm','MM/DD/YY HH:MI am')
);

insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Styx')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('12/16/02 9:0 pm','MM/DD/YY HH:MI am')
);

insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Chicago')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('12/18/02 8:30 pm','MM/DD/YY HH:MI am')
);

insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Chicago')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('12/19/02 8:15 pm','MM/DD/YY HH:MI am')
);

insert into show(show_id,category_id,act_id,venue_id,showdate)
values
(
	 show_seq.nextval
	,(select category_id from category where name='Rock/Popular')
	,(select act_id from act where name='Chicago')
	,(select venue_id from venue where name='Compaq Center')
	,to_date('12/20/02 8:25 pm','MM/DD/YY HH:MI am')
);
commit;
spool off;
exit;

supportingact.sql

spool log\supportingact.log;

declare
	vact_id INTEGER;
	cursor cShow is select show_id from show where act_id = (select act_id from act where name='Paul McCartney');
begin
	for rShow in cShow loop
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='Tom Petty'));
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='Bob Dylan'));
	end loop;
	commit;
exception when others then
	rollback;
	raise;
end;
/

declare
	vact_id INTEGER;
	cursor cShow is select show_id from show where act_id = (select act_id from act where name='Styx');
begin
	for rShow in cShow loop
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='The Little River Band'));
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='Tony Joe White'));
	end loop;
	commit;
exception when others then
	rollback;
	raise;
end;
/

declare
	vact_id INTEGER;
	cursor cShow is select show_id from show where act_id = (select act_id from act where name='Chicago');
begin
	for rShow in cShow loop
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='The Little River Band'));
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='Tony Joe White'));
		insert into SupportingAct(show_id,act_id) values(rShow.show_id,(select act_id from act where name='Gladys Knight'));
	end loop;
	commit;
exception when others then
	rollback;
	raise;
end;
/

commit;
spool off;
exit;