drop table performance;
drop table races;
drop table drivers;
drop table pointscale;

create table drivers 
(drivername varchar2 (30) constraint drivers_drivername_pk PRIMARY KEY,
nickname varchar2 (20), phone varchar2 (11) constraint drivers_phone_nn NOT NULL);

create table races 
(racename varchar2 (30) constraint races_racename_pk PRIMARY KEY, 
racedate date,
location varchar2 (30) constraint races_location_nn NOT NULL,
director varchar2 (20) constraint races_director_nn NOT NULL,
director_ph varchar2 (11) constraint races_director_ph_nn NOT NULL);

create table pointscale
(place varchar2 (5) constraint pointscale_place_pk PRIMARY KEY,
points number (2) constraint pointscale_points_nn NOT NULL);

create table performance
(driver varchar2 (30) constraint performance_driver_fk REFERENCES drivers(drivername),
race varchar2 (30) constraint performance_race_fk REFERENCES races(racename),
place varchar2 (5) constraint performance_place_fk REFERENCES pointscale(place),
time varchar2 (10) constraint performance_time_nn NOT NULL);

alter table performance add constraint performance_race_driver_pk PRIMARY KEY (driver,race);


insert into drivers
values ('Bill Elliott','','111-2222');

insert into drivers
values ('Bill Howard','Ticker','222-3333');

insert into drivers
values ('Bobby Labonte','Bob','333-4444');

insert into drivers
values ('Dale Earnhardt','Intimidator','444-5555');

insert into drivers
values ('Dale Jarrett','','656-9876');

insert into drivers
values ('Darrell Waltrip','','876-9870');

insert into drivers
values ('Ernie Irvan','Skittles','987-0987');

insert into drivers
values ('Geoff Bodine','','123-4567');

insert into drivers
values ('Hut Stricklin','','999-8766');

insert into drivers
values ('Jeff Gordon','Pretty Boy','555-5555');

insert into drivers
values ('John Reddy','','111-1111');

insert into drivers
values ('Lake Speed','Speedy','222-2222');

insert into drivers
values ('Rice Milton','','333-3333');

insert into drivers
values ('Richard Petty','The King','444-4444');

insert into drivers
values ('Ricky Rudd','Ruddy','555-5555');

insert into drivers
values ('Rusty Wallace','Weasel','666-6666');

insert into drivers
values ('Sterling Martin','','777-7777');

insert into drivers
values ('Steve Jackson','','888-8888');

insert into drivers
values ('Victor Carpainter','Vick','999-9999');

insert into drivers
values ('Wilker Pace','Skimmer','234-9000');


insert into races
values ('Brickyard 400','15-MAR-00','Indianapolis','Buddy','111-2222');

insert into races
values ('Budlight 600','20-JAN-00','Radford Raceway','Jimmy','222-2222');

insert into races
values ('Coca-Cola 600','05-JAN-00','Charlotte Motor Speedway','JD','333-5684');

insert into races
values ('Daytona 500','01-JAN-00','Daytona','JR','644-8733');

insert into races
values ('DieHard 500','29-JAN-00','Talladega','Bubba','764-8765');

insert into races
values ('Indy 500','20-FEB-00','Richmond Motor Speedway','Butch','888-9876');

insert into races
values ('PRIMESTAR 500','26-FEB-00','Atlanta Motor Speedway','Fred','987-6543');

insert into races
values ('Southern 500','27-FEB-00','Darlington Raceway','Sunny','764-8765');

insert into races
values ('The Bud at the Glen','20-MAR-00','Watkins Glen','Markus','654-9873');

insert into races
values ('Viking 600','26-MAR-00','Las Vegas Motor Speedway','Dot','111-7534');

insert into pointscale
values ('1st',32);

insert into pointscale
values ('2nd',16);

insert into pointscale
values ('3rd',8);

insert into pointscale
values ('4th',4);

insert into pointscale
values ('5th',2);

insert into pointscale
values ('6th',1);

insert into pointscale
values ('7th',0);

insert into pointscale
values ('8th',0);

insert into performance
values ('Jeff Gordon','Brickyard 400','2nd','2:01:12');

insert into performance
values ('Lake Speed','Brickyard 400','3rd','2:02:22');

insert into performance
values ('Richard Petty','Brickyard 400','4th','2:04:45');

insert into performance
values ('Bill Elliott','Brickyard 400','8th','2:10:11');

insert into performance
values ('Dale Jarrett','Brickyard 400','6th','2:07:00');

insert into performance
values ('Ernie Irvan','Brickyard 400','7th','2:08:39');

insert into performance
values ('Hut Stricklin','Brickyard 400','5th','2:06:12');

insert into performance
values ('Bobby Labonte','Brickyard 400','1st','2:00:34');

insert into performance
values ('Jeff Gordon','Budlight 600','3rd','2:28:11');

insert into performance
values ('Hut Stricklin','Budlight 600','2nd','2:28:09');

insert into performance
values ('John Reddy','Budlight 600','4th','2:28:12');

insert into performance
values ('Ernie Irvan','Budlight 600','6th','2:28:14');

insert into performance
values ('Richard Petty','Budlight 600','7th','2:28:15');

insert into performance
values ('Ricky Rudd','Budlight 600','8th','2:28:16');

insert into performance
values ('Lake Speed','Budlight 600','5th','2:28:13');

insert into performance
values ('Geoff Bodine','Budlight 600','1st','2:28:08');

insert into performance
values ('Rice Milton','Coca-Cola 600','8th','2:47:07');

insert into performance
values ('Bill Elliott','Coca-Cola 600','1st','2:45:02');

insert into performance
values ('Dale Earnhardt','Coca-Cola 600','3rd','2:46:23');

insert into performance
values ('Jeff Gordon','Coca-Cola 600','2nd','2:45:07');

insert into performance
values ('Bill Howard','Coca-Cola 600','7th','2:47:05');

insert into performance
values ('Ernie Irvan','Coca-Cola 600','6th','2:47:01');

insert into performance
values ('Darrell Waltrip','Coca-Cola 600','5th','2:47:00');

insert into performance
values ('Dale Jarrett','Coca-Cola 600','4th','2:46:24');

insert into performance
values ('Ernie Irvan','Daytona 500','7th','2:40:43');

insert into performance
values ('Hut Stricklin','Daytona 500','6th','2:32:00');

insert into performance
values ('Victor Carpainter','Daytona 500','8th','2:41:05');

insert into performance
values ('Darrell Waltrip','Daytona 500','5th','2:31:09');

insert into performance
values ('Jeff Gordon','Daytona 500','1st','2:20:21');

insert into performance
values ('Lake Speed','Daytona 500','2nd','2:15:44');

insert into performance
values ('Ricky Rudd','Daytona 500','3rd','2:25:25');

insert into performance
values ('Dale Earnhardt','Daytona 500','4th','2:30:56');

insert into performance
values ('Geoff Bodine','DieHard 500','4th','1:59:00');

insert into performance
values ('Ernie Irvan','DieHard 500','7th','2:09:09');

insert into performance
values ('Jeff Gordon','DieHard 500','5th','1:59:01');

insert into performance
values ('Darrell Waltrip','DieHard 500','3rd','1:58:49');

insert into performance
values ('Dale Jarrett','DieHard 500','2nd','1:58:45');

insert into performance
values ('Bobby Labonte','DieHard 500','1st','1:55:44');

insert into performance
values ('Wilker Pace','DieHard 500','8th','2:10:08');

insert into performance
values ('Richard Petty','DieHard 500','6th','2:01:05');

insert into performance
values ('Ernie Irvan','Indy 500','5th','2:27:09');

insert into performance
values ('Bobby Labonte','Indy 500','1st','2:27:05');

insert into performance
values ('Geoff Bodine','Indy 500','6th','2:28:05');

insert into performance
values ('Hut Stricklin','Indy 500','7th','2:28:06');

insert into performance
values ('Jeff Gordon','Indy 500','8th','2:28:07');

insert into performance
values ('Darrell Waltrip','Indy 500','4th','2:27:08');

insert into performance
values ('Dale Jarrett','Indy 500','3rd','2:27:07');

insert into performance
values ('Dale Earnhardt','Indy 500','2nd','2:27:06');

insert into performance
values ('Wilker Pace','PRIMESTAR 500','1st','2:47:02');

insert into performance
values ('Ernie Irvan','PRIMESTAR 500','2nd','2:47:04');

insert into performance
values ('Jeff Gordon','PRIMESTAR 500','3rd','2:47:05');

insert into performance
values ('Rusty Wallace','PRIMESTAR 500','4th','2:47:06');

insert into performance
values ('Ricky Rudd','PRIMESTAR 500','5th','2:47:07');

insert into performance
values ('Richard Petty','PRIMESTAR 500','6th','2:47:08');

insert into performance
values ('Rice Milton','PRIMESTAR 500','7th','2:47:09');

insert into performance
values ('Lake Speed','PRIMESTAR 500','8th','2:47:15');

insert into performance
values ('Rusty Wallace','Southern 500','2nd','1:58:02');

insert into performance
values ('John Reddy','Southern 500','8th','2:07:5');

insert into performance
values ('Sterling Martin','Southern 500','1st','1:58:01');

insert into performance
values ('Ernie Irvan','Southern 500','7th','2:00:00');

insert into performance
values ('Ricky Rudd','Southern 500','3rd','1:58:03');

insert into performance
values ('Lake Speed','Southern 500','5th','1:58:48');

insert into performance
values ('Jeff Gordon','Southern 500','6th','1:59:00');

insert into performance
values ('Richard Petty','Southern 500','4th','1:58:45');

insert into performance
values ('Darrell Waltrip','Southern 500','6th','2:27:08');

insert into performance
values ('Bill Howard','Southern 500','2nd','2:27:03');

insert into performance
values ('Ernie Irvan','The Bud at the Glen','7th','2:27:09');

insert into performance
values ('Dale Jarrett','The Bud at the Glen','5th','2:27:06');

insert into performance
values ('Dale Earnhardt','The Bud at the Glen','4th','2:27:05');

insert into performance
values ('Bobby Labonte','The Bud at the Glen','3rd','2:27:04');

insert into performance
values ('Bill Elliott','The Bud at the Glen','1st','2:27:02');

insert into performance
values ('Jeff Gordon','The Bud at the Glen','8th','2:27:15');

insert into performance
values ('Jeff Gordon','Viking 600','8th','2:28:28');

insert into performance
values ('Bobby Labonte','Viking 600','1st','2:28:17');

insert into performance
values ('Dale Earnhardt','Viking 600','2nd','2:28:18');

insert into performance
values ('Dale Jarrett','Viking 600','3rd','2:28:19');

insert into performance
values ('Darrell Waltrip','Viking 600','4th','2:28:20');

insert into performance
values ('Ernie Irvan','Viking 600','5th','2:28:21');

insert into performance
values ('Geoff Bodine','Viking 600','6th','2:28:22');

insert into performance
values ('Hut Stricklin','Viking 600','7th','2:28:23');
commit;