data load.txt
--load Depot with data
insert into Depot values
('101','Holloway','Camden Road');
insert into Depot values
('102','Hornsey','High Road');
insert into Depot values
('104','Islington','Upper Street');
--load BusType with data
insert into BusType values
('1','double-decker');
insert into BusType values
('2','metrobus');
insert into BusType values
('3','midibus');
insert into BusType values
('4','bendy bus');
insert into BusType values
('5','open top');
--load Busdriver with data
insert into Busdriver values
('001','Jane Brown',1800,'09-feb-1985','101');
insert into Busdriver values
('006','Sally Smith',1750,'09-mar-1996','');
insert into Busdriver values
('007','James Bond',1500,'09-jan-1999','102');
insert into Busdriver values
('008','Maggie May',2200,'09-jan-2000','102');
insert into Busdriver values
('009','Jack Jones',1400,'09-aug-2001','101');
insert into Busdriver values
('010','Peter Piper',3500,'09-jun-2004','104');
insert into Busdriver values
('011','John Peel',2000,'09-feb-2005','102');
--load Cleaner with data
insert into Cleaner values
('110','John',2550,'101');
insert into Cleaner values
('111','Jean',2500,'101');
insert into Cleaner values
('112','Betty',2400,'102');
insert into Cleaner values
('113','Vince',2800,'102');
insert into Cleaner values
('114','Jay',3000,'102');
insert into Cleaner values
('115','Doug',2000,'102');
insert into Cleaner values
('116','Geeta',4000,'');
--load Route with data
insert into Route values
('10','Tottenham/Angel','102');
insert into Route values
('11','Islington/Highgate','102');
insert into Route values
('6','Camden/Golders Green','101');
insert into Route values
('7','Finchley/Tottenham','101');
insert into Route values
('8','Hendon/Muswell Hill','101');
--load Bus with data
insert into Bus values
('A123ABC','Routemaster','1','101','110');
insert into Bus values
('D678FGH','Volvo 8700','2','101','110');
insert into Bus values
('D345GGG','Volvo 8500','1','101','112');
insert into Bus values
('H259IJK','Daf SB220','3','102','114');
insert into Bus values
('P200IJK','Mercedes 709D','2','102','113');
insert into Bus values
('P300RTY','Mercedes Citaro','4','102','113');
insert into Bus values
('R678FDS','Daf SB220','1','','110');
--load Ability with data
insert into Ability values
('001','6');
insert into Ability values
('001','7');
insert into Ability values
('001','8');
insert into Ability values
('007','6');
insert into Ability values
('007','10');
insert into Ability values
('008','10');
insert into Ability values
('008','11');
insert into Ability values
('009','7');
--load Training with data
insert into Training values
('001','1','09-jan-2006');
insert into Training values
('001','2','09-jan-2006');
insert into Training values
('006','2','09-feb-2006');
insert into Training values
('007','1','09-feb-2006');
insert into Training values
('007','2','09-feb-2006');
insert into Training values
('007','3','09-mar-2006');
insert into Training values
('008','2','09-mar-2006');
insert into Training values
('008','3','09-mar-2006');
insert into Training values
('008','4','09-apr-2006');
insert into Training values
('009','3','09-apr-2006');
insert into Training values
('009','4','09-may-2006');
insert into Training values
('011','1','09-may-2006');
insert into Training values
('011','2','09-may-2006');
insert into Training values
('011','3','09-jun-2006');
insert into Training values
('011','4','09-jun-2006');
insert into Training values
('011','5','09-jun-2006');
--load Restriction with data
insert into Restriction values
('6','1');
insert into Restriction values
('6','2');
insert into Restriction values
('6','3');
insert into Restriction values
('6','4');
insert into Restriction values
('7','1');
insert into Restriction values
('7','2');
insert into Restriction values
('8','3');
insert into Restriction values
('8','4');
insert into Restriction values
('10','1');
insert into Restriction values
('10','2');
insert into Restriction values
('10','3');
insert into Restriction values
('10','4');
insert into Restriction values
('11','1');
insert into Restriction values
('11','2');
insert into Restriction values
('11','3');
insert into Restriction values
('11','4');
commit;
select * from Ability;
select * from Training;
select * from Restriction;
select * from Busdriver;
select * from Route;
select * from Bus;
select * from Cleaner;
select * from BusType;
select * from Depot;
insert into Depot values
('101','Holloway','Camden Road');
insert into Depot values
('102','Hornsey','High Road');
insert into Depot values
('104','Islington','Upper Street');
--load BusType with data
insert into BusType values
('1','double-decker');
insert into BusType values
('2','metrobus');
insert into BusType values
('3','midibus');
insert into BusType values
('4','bendy bus');
insert into BusType values
('5','open top');
--load Busdriver with data
insert into Busdriver values
('001','Jane Brown',1800,'09-feb-1985','101');
insert into Busdriver values
('006','Sally Smith',1750,'09-mar-1996','');
insert into Busdriver values
('007','James Bond',1500,'09-jan-1999','102');
insert into Busdriver values
('008','Maggie May',2200,'09-jan-2000','102');
insert into Busdriver values
('009','Jack Jones',1400,'09-aug-2001','101');
insert into Busdriver values
('010','Peter Piper',3500,'09-jun-2004','104');
insert into Busdriver values
('011','John Peel',2000,'09-feb-2005','102');
--load Cleaner with data
insert into Cleaner values
('110','John',2550,'101');
insert into Cleaner values
('111','Jean',2500,'101');
insert into Cleaner values
('112','Betty',2400,'102');
insert into Cleaner values
('113','Vince',2800,'102');
insert into Cleaner values
('114','Jay',3000,'102');
insert into Cleaner values
('115','Doug',2000,'102');
insert into Cleaner values
('116','Geeta',4000,'');
--load Route with data
insert into Route values
('10','Tottenham/Angel','102');
insert into Route values
('11','Islington/Highgate','102');
insert into Route values
('6','Camden/Golders Green','101');
insert into Route values
('7','Finchley/Tottenham','101');
insert into Route values
('8','Hendon/Muswell Hill','101');
--load Bus with data
insert into Bus values
('A123ABC','Routemaster','1','101','110');
insert into Bus values
('D678FGH','Volvo 8700','2','101','110');
insert into Bus values
('D345GGG','Volvo 8500','1','101','112');
insert into Bus values
('H259IJK','Daf SB220','3','102','114');
insert into Bus values
('P200IJK','Mercedes 709D','2','102','113');
insert into Bus values
('P300RTY','Mercedes Citaro','4','102','113');
insert into Bus values
('R678FDS','Daf SB220','1','','110');
--load Ability with data
insert into Ability values
('001','6');
insert into Ability values
('001','7');
insert into Ability values
('001','8');
insert into Ability values
('007','6');
insert into Ability values
('007','10');
insert into Ability values
('008','10');
insert into Ability values
('008','11');
insert into Ability values
('009','7');
--load Training with data
insert into Training values
('001','1','09-jan-2006');
insert into Training values
('001','2','09-jan-2006');
insert into Training values
('006','2','09-feb-2006');
insert into Training values
('007','1','09-feb-2006');
insert into Training values
('007','2','09-feb-2006');
insert into Training values
('007','3','09-mar-2006');
insert into Training values
('008','2','09-mar-2006');
insert into Training values
('008','3','09-mar-2006');
insert into Training values
('008','4','09-apr-2006');
insert into Training values
('009','3','09-apr-2006');
insert into Training values
('009','4','09-may-2006');
insert into Training values
('011','1','09-may-2006');
insert into Training values
('011','2','09-may-2006');
insert into Training values
('011','3','09-jun-2006');
insert into Training values
('011','4','09-jun-2006');
insert into Training values
('011','5','09-jun-2006');
--load Restriction with data
insert into Restriction values
('6','1');
insert into Restriction values
('6','2');
insert into Restriction values
('6','3');
insert into Restriction values
('6','4');
insert into Restriction values
('7','1');
insert into Restriction values
('7','2');
insert into Restriction values
('8','3');
insert into Restriction values
('8','4');
insert into Restriction values
('10','1');
insert into Restriction values
('10','2');
insert into Restriction values
('10','3');
insert into Restriction values
('10','4');
insert into Restriction values
('11','1');
insert into Restriction values
('11','2');
insert into Restriction values
('11','3');
insert into Restriction values
('11','4');
commit;
select * from Ability;
select * from Training;
select * from Restriction;
select * from Busdriver;
select * from Route;
select * from Bus;
select * from Cleaner;
select * from BusType;
select * from Depot;