Insert into Route values(1,'bang','shim',6,395,1,2,435);
Insert into Route values(2,'myso','shim',8,310,1,3,347);
Insert into route_frequency values(1,8,60,6,0);
Insert into route_frequency values(2,1,60,6,0);
Insert into route_frequency values(2,2,90,6,0);
Insert into route_frequency values(2,6,30,6,0);
Insert into route_frequency values(2,5,40,6,0);
Insert into service_class values(1,8,0);
Insert into service_class values(1,8,1);
Insert into service_class values(1,8,3);
Insert into service_class values(1,8,4);
Insert into service_class values(2,1,0);
Insert into service_class values(2,1,1);
Insert into service_class values(2,1,3);
Insert into service_class values(2,2,0);
Insert into service_class values(2,2,1);
Insert into service_class values(2,2,3);
Insert into service_class values(2,5,0);
Insert into service_class values(2,5,1);
Insert into service_class values(2,5,2);
Insert into service_class values(2,5,3);
Insert into service_class values(2,6,0);
Insert into service_class values(2,6,3);
Insert into Route_element values(1,'bang','tumk',100);
Insert into Route_element values(2,'tumk','arsi',150);
Insert into Route_element values(3,'arsi','kadu',40);
Insert into Route_element values(4,'kadu','bhad',75);
Insert into Route_element values(5,'bhad','shim',30);
Insert into Route_element values(11,'myso','hole',85);
Insert into Route_element values(12,'hole','hass',40);
Insert into Route_element values(18,'hass','arsi',40);
Insert into place values('bang','Bangalore');
Insert into place values('myso','Mysore');
Insert into place values('tumk','Tumkur');
Insert into place values('arsi','Arsikere');
Insert into place values('kadu','Kadur');
Insert into place values('bhad','Bhadravathi');
Insert into place values('hole','Hole Narsipura');
Insert into place values('hass','Hassan');
Insert into place values('shim','Shimoga');
Insert into path_order values(1,1,1);
Insert into path_order values(1,2,2);
Insert into path_order values(1,3,3);
Insert into path_order values(1,4,4);
Insert into path_order values(1,5,5);
Insert into path_order values(2,1,11);
Insert into path_order values(2,2,12);
Insert into path_order values(2,3,18);
Insert into path_order values(2,4,3);
Insert into path_order values(2,5,4);
Insert into path_order values(2,6,5);
Insert into bus_stand values(0,'Open Stop','Open Stop',10);
Insert into bus_stand values(2,'M.G Road','Bangalore',10);
Insert into bus_stand values(7,'Palace Road','Mysore',10);
Insert into bus_info values('KA-03-N-1071',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1072',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1073',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1074',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1075',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1076',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1077',50,0,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1078',30,1,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1079',50,2,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1081',40,3,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1091',50,0,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-1171',20,1,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-3081',67,1,'Cors',SYSDATE,'Y');
Insert into bus_info values('KA-03-N-5384',67,1,'Cors',SYSDATE,'Y');
Insert into class_type values(0, 'Shuttle',5,1.05);
Insert into class_type values(1, 'Express',5,1.15);
Insert into class_type values(2, 'Semi-Luxury',15,1.25);
Insert into class_type values(3, 'Luxury',20,1.35);
Insert into class_type values(4, 'Air-Bus',25,1.8);
Insert into fuel_index values(1,0.3);
Insert into fuel_index values(2,0.38);
Insert into fuel_index values(3,0.43);
