text: /*Customer table*/
  INSERT INTO CUSTOMER VALUES('123456E7', 'GHI',
  NULL,'GHI','9098123429', 'ghighi@gmail.com','122 DALLAS DOWNTOWN',
  'DALLAS','TEXAS',50932,'N',NULL);
  INSERT INTO CUSTOMER VALUES('T0981237', 'DEF',
  NULL,'DEF','4245985740', 'defdef@gmail.com','212 MIDWAY STREET',
  'RALEIGH','NORTH CAROLINA',42571,'M','M1004');
  INSERT INTO CUSTOMER VALUES('F0091266', 'ABC',
  NULL,'ABC','7892340918', 'abcabc@gmail.com','300 COLLEGE STATION',
  'COLLEGE STATION','TEXAS',56784,'N',NULL);
  
  /*Bike_category table*/
  INSERT INTO BIKE_CATEGORY VALUES('OFFROADING',55,30);
  INSERT INTO BIKE_CATEGORY VALUES('EXTREME',70,40);
  INSERT INTO BIKE_CATEGORY VALUES('RACING',50,30);
  INSERT INTO BIKE_CATEGORY VALUES('HYBRID',40,20);
  INSERT INTO BIKE_CATEGORY VALUES('NORMAL',30,10);
  
  /*Location table*/
  INSERT INTO LOCATION VALUES('L101','DAL AIRPORT',
  'Herb Kelleher Way','Dallas','Texas',75235);
  INSERT INTO LOCATION VALUES('L102',LA INTL AIRPORT',
  'World Way','Los Angeles','California',90045);
  INSERT INTO LOCATION VALUES('L103',DFW INTL AIRPORT',
  'International Pkwy','DFW Airport','Texas',75261);
  INSERT INTO LOCATION VALUES('L104','HOUSTON AIRPORT',
  'Groschke Rd','Houston','Texas',77094);
  
  /*Bike table*/
  INSERT INTO BIKE VALUES('KRX1234','ROADRUNNER','KAWASAKI',
  2014,100,'RACING','L101','A');
  INSERT INTO BIKE VALUES('HCD4567','CRUISER','HONDA',
  2015,150,'NORMAL','L102','N');
  INSERT INTO BIKE VALUES('HHD3245','HYBRID','HONDA',
  2014,123,'HYBRID','L103','A');
  INSERT INTO BIKE VALUES('HLD3231','LANDCRUISER','HONDA',
  2016,130,'OFFROADING','L102','A');
  INSERT INTO BIKE VALUES('YTD2451','EXTRAVAGANZA','YAMAHA',
  2015,70,'EXTREME','L103','A');
  INSERT INTO BIKE VALUES('HRD3135','RACER','HERO',
  2016,110,'RACING','L102','A');
  INSERT INTO BIKE VALUES('HTC1355','THUNDERCAT','HARLEY-DAVIDSON',
  2016,114,'HYBRID','L101','A');
  INSERT INTO BIKE VALUES('HLO2143','LIBERIO','HERO',
  2015,123,'NORMAL','L104','A');
  
  /*Discount table*/
  INSERT INTO DISCOUNT VALUES ('A111','ORACLE',
  to_date('2018-01-21','YYYY-MM-DD'),25);
  INSERT INTO DISCOUNT VALUES ('B111','AMAZON',
  to_date('2019-09-25','YYYY-MM-DD'),20);
  INSERT INTO DISCOUNT VALUES ('C111','WEEKENDER SPL',
  to_date('2017-10-14','YYYY-MM-DD'),10);
  
  /*Insurance table*/
  INSERT INTO INSURANCE VALUES('I111', 'COLLISION/ MINOR ACCIDENT WAIVER', 'Covers theft and damage to the rental bike',15);
  INSERT INTO INSURANCE VALUES('I112', 'SUPPLEMENTAL LIABILITY PROTECTION', 'Covers damage to others',12);
  
  /*Booking table*/
  INSERT INTO BOOKING VALUES('B1113',TO_TIMESTAMP('2017-04-10 13:00:00',
  'YYYY-MM-DD HH24:MI:SS'),TO_TIMESTAMP('2017-04-15 13:00:00', 'YYYY-MM-DD HH24:MI:SS'),
  450,'R','L101','L101','KRX1234','123456E7','I111',
  TO_TIMESTAMP('2017-04-16 13:00:00', 'YYYY-MM-DD HH24:MI:SS'),'A111');
  INSERT INTO BOOKING VALUES('B1114',TO_TIMESTAMP('2017-04-23 13:00:00',
  'YYYY-MM-DD HH24:MI:SS'),TO_TIMESTAMP('2017-04-25 20:30:00', 'YYYY-MM-DD HH24:MI:SS'),
  48,'R','L102','L102','HCD4567','T0981237','I112',
  TO_TIMESTAMP('2017-04-25 20:30:00', 'YYYY-MM-DD HH24:MI:SS'),'B111'); 
  
  /*Billing table*/
  INSERT INTO BILLING VALUES('BL1111',to_date('2017-04-16','YYYY-MM-DD'),
  'P',35 ,138.03,12.38 ,'B1113',720);
  INSERT INTO BILLING VALUES('BL1112',to_date('2017-04-25','YYYY-MM-DD'),
  'P',85 ,487.13 ,12.38 ,'B1114',0);
  