TravelOnTheGo_DB_Data_Insertion.sql

# Data Insertion Into The TravelOnTheGo Pasenger Table: 

insert into Passenger values ("Sejal" , "AC" , "F" , "Bengaluru" , "Chennai" , 350 , "Sleeper");
insert into Passenger values ("Anmol" , "Non-AC" , "M" , "Mumbai" , "Hyderabad" , 700 , "Sitting");
insert into Passenger values ("Pallavi" , "AC" , "F" , "Panaji" , "Bengaluru" , 600 , "Sleeper");
insert into Passenger values ("Khushboo" , "AC" , "F" , "Chennai" , "Mumbai" , 1500 , "Sleeper");
insert into Passenger values ("Udit" , "Non-AC" , "M" , "Trivandrum" , "Panaji" , 1000 , "Sleeper");
insert into Passenger values ("Ankur" , "AC" , "M" , "Nagpur" , "Hyderabad" , 500 , "Sitting");
insert into Passenger values ("Hemant" , "Non-AC" , "M" , "Panaji" , "Mumbai" , 700 , "Sleeper");
insert into Passenger values ("Manish" , "Non-AC" , "M" , "Hyderabad" , "Bengaluru" , 500 , "Sitting");
insert into Passenger values ("Piyush" , "AC" , "M" , "Pune" , "Nagpur" , 700 , "Sitting");

# Data Insertion Into The TravelOnTheGo Price Table: 

insert into Price values ("Sleeper" , 350 , 770);
insert into Price values ("Sleeper" , 500 , 1100);
insert into Price values ("Sleeper" , 600 , 1320);
insert into Price values ("Sleeper" , 700 , 1540);
insert into Price values ("Sleeper" , 1000 , 2200);
insert into Price values ("Sleeper" , 1200 , 2640);
insert into Price values ("Sleeper" , 1500 , 2700);
insert into Price values ("Sitting" , 500 , 620);
insert into Price values ("Sitting" , 600 , 744);
insert into Price values ("Sitting" , 700 , 868);
insert into Price values ("Sitting" , 1000 , 1240);
insert into Price values ("Sitting" , 1200 , 1488);
insert into Price values ("Sitting" , 1500 , 1860);