create table Station(Station_ID int, Name varchar(15), City varchar(15), State varchar(15));
create table Ticket(Ticket_ID int, Class varchar(30), Price int, Booking_Date date, Booking_Clerk varchar(15), Passenger_ID int, Trip_ID int, Foreign Key(Passenger_ID) references Passenger(Passenger_ID), Foreign Key(Trip_ID) references Trip(Trip_ID));
create table Train(Train_ID int, Model varchar(15), Number_of_seats int, Maximum_Speed int, Number_of_coaches int, Manufacturing_date date, Driver_ID int, Bought_by int, Foreign Key(Driver_ID) references Job(Job_ID));
create table Trip(Trip_ID int, Departure_Time time, Arrival_Time time, Source_ID int, Destination_ID int, Train_ID int, Station_Manager_ID int, Foreign Key(Source_ID) references Station(Station_ID), Foreign Key(Destination_ID) references Station(Station_ID));
insert into Station values ("ST10001", "Howrah Railway Station", "Howrah", "West Bengal"), ("ST10002", "Sealdah Railway Station", "Kolkata", "West Bengal"), ("ST10003", "Chhatrapati Shivaji Terminus Railway Station", "Mumbai", "Maharashtra"), ("ST10004", "New Delhi Railway Station", "New Delhi", "Delhi"), ("ST10005", "Chennai Railway Station", "Chennai", "Tamil Nadu"), ("ST10006", "Kanpur Railway Station", "Kanpur", "Uttar Pradesh"), ("ST10007", "Vijaywada Railway Station", "Vijayawada", "Andhra Pradesh"), ("ST10008", "Kalyan Junction", "Mumbai", "Maharashtra"), ("ST10009", "Nagpur Railway Junction", "Nagpur", "Maharashtra"), ("ST10010", "Pt. Deen Dayal Upadhyaya Junction", "Chandauli district", "Uttar Pradesh");
insert into Ticket values ("T00001", "First", "6000", "44506", "Patricia Smith", "P0001", "Tr01"), ("T00002", "Second", "4000", "44515", "James Moore", "P0002", "Tr02"), ("T00003", "Second", "4000", "44519", "James Taylor", "P0003", "Tr03"), ("T00004", "Second", "4000", "44523", "William Miller", "P0004", "Tr04"), ("T00005", "Third", "2000", "44526", "John Davis", "P0005", "Tr05"), ("T00006", "Third", "2000", "44531", "Charles Johnson", "P0006", "Tr06"), ("T00007", "Third", "2000", "44532", "William Davis", "P0007", "Tr07"), ("T00008", "Third", "2000", "44533", "John Jones", "P0008", "Tr08"), ("T00009", "Third", "2000", "44536", "Richard Johnson", "P0009", "Tr09"), ("T00010", "Third", "2000", "44540", "James Anderson", "P0010", "Tr01"), ("T00011", "First", "6000", "44542", "Robert Taylor", "P0011", "Tr02"), ("T00012", "Second", "4000", "44548", "Barbara Smith", "P0012", "Tr03"), ("T00013", "Second", "4000", "44553", "Michael Moore", "P0013", "Tr04"), ("T00014", "Second", "4000", "44555", "James Martin", "P0014", "Tr05"), ("T00015", "Third", "2000", "44556", "Michael Wilson", "P0015", "Tr06"), ("T00016", "Third", "2000", "44557", "James Thomas", "P0016", "Tr07"), ("T00017", "Third", "2000", "44559", "Joseph Smith", "P0017", "Tr08"), ("T00018", "Third", "2000", "44560", "James White", "P0018", "Tr09"), ("T00019", "Third", "2000", "44561", "Mary Miller", "P0019", "Tr01"), ("T00020", "Third", "2000", "44568", "Robert Anderson", "P0020", "Tr02"), ("T00021", "First", "6000", "44576", "Robert Wilson", "P0021", "Tr03"), ("T00022", "Second", "4000", "44577", "Charles Williams", "P0022", "Tr04"), ("T00023", "Second", "4000", "44582", "Jennifer Johnson", "P0023", "Tr05"), ("T00024", "Second", "4000", "44588", "Michael Anderson", "P0024", "Tr06"), ("T00025", "Third", "2000", "44590", "John Brown", "P0025", "Tr07"), ("T00026", "Third", "2000", "44502", "Patricia Smith", "P0026", "Tr08"), ("T00027", "Third", "2000", "44504", "James Moore", "P0027", "Tr09"), ("T00028", "Third", "2000", "44505", "James Taylor", "P0028", "Tr01"), ("T00029", "Third", "2000", "44507", "William Miller", "P0029", "Tr02"), ("T00030", "Third", "2000", "44513", "John Davis", "P0030", "Tr03"), ("T00031", "First", "6000", "44519", "Charles Johnson", "P0031", "Tr04"), ("T00032", "Second", "4000", "44525", "William Davis", "P0032", "Tr05"), ("T00033", "Second", "4000", "44527", "John Jones", "P0033", "Tr06"), ("T00034", "Second", "4000", "44530", "Richard Johnson", "P0034", "Tr07"), ("T00035", "Third", "2000", "44534", "James Anderson", "P0035", "Tr08"), ("T00036", "Third", "2000", "44541", "Robert Taylor", "P0036", "Tr09"), ("T00037", "Third", "2000", "44542", "Barbara Smith", "P0037", "Tr01"), ("T00038", "Third", "2000", "44546", "Michael Moore", "P0038", "Tr02"), ("T00039", "Third", "2000", "44547", "James Martin", "P0039", "Tr03"), ("T00040", "Third", "2000", "44548", "Michael Wilson", "P0040", "Tr04"), ("T00041", "First", "6000", "44553", "James Thomas", "P0041", "Tr05"), ("T00042", "Second", "4000", "44556", "Joseph Smith", "P0042", "Tr06"), ("T00043", "Second", "4000", "44557", "James White", "P0043", "Tr07"), ("T00044", "Second", "4000", "44558", "Mary Miller", "P0044", "Tr08"), ("T00045", "Third", "2000", "44559", "Robert Anderson", "P0045", "Tr09"), ("T00046", "Third", "2000", "44567", "Robert Wilson", "P0046", "Tr01"), ("T00047", "Third", "2000", "44569", "Charles Williams", "P0047", "Tr02"), ("T00048", "Third", "2000", "44579", "Jennifer Johnson", "P0048", "Tr03"), ("T00049", "Third", "2000", "44581", "Michael Anderson", "P0049", "Tr04"), ("T00050", "Third", "2000", "44584", "John Brown", "P0050", "Tr05"), ("T00051", "First", "6000", "44504", "Patricia Smith", "P0051", "Tr06"), ("T00052", "Second", "4000", "44516", "James Moore", "P0052", "Tr07"), ("T00053", "Second", "4000", "44517", "James Taylor", "P0053", "Tr08"), ("T00054", "Second", "4000", "44518", "William Miller", "P0054", "Tr09"), ("T00055", "Third", "2000", "44522", "John Davis", "P0055", "Tr01"), ("T00056", "Third", "2000", "44523", "Charles Johnson", "P0056", "Tr02"), ("T00057", "Third", "2000", "44528", "William Davis", "P0057", "Tr03"), ("T00058", "Third", "2000", "44529", "John Jones", "P0058", "Tr04"), ("T00059", "Third", "2000", "44537", "Richard Johnson", "P0059", "Tr05"), ("T00060", "Third", "2000", "44546", "James Anderson", "P0060", "Tr06"), ("T00061", "First", "6000", "44552", "Robert Taylor", "P0061", "Tr07"), ("T00062", "Second", "4000", "44553", "Barbara Smith", "P0062", "Tr08"), ("T00063", "Second", "4000", "44555", "Michael Moore", "P0063", "Tr09"), ("T00064", "Second", "4000", "44556", "James Martin", "P0064", "Tr01"), ("T00065", "Third", "2000", "44558", "Michael Wilson", "P0065", "Tr02"), ("T00066", "Third", "2000", "44561", "James Thomas", "P0066", "Tr03"), ("T00067", "Third", "2000", "44563", "Joseph Smith", "P0067", "Tr04"), ("T00068", "Third", "2000", "44564", "James White", "P0068", "Tr05"), ("T00069", "Third", "2000", "44568", "Mary Miller", "P0069", "Tr06"), ("T00070", "Third", "2000", "44571", "Robert Anderson", "P0070", "Tr07"), ("T00071", "First", "6000", "44579", "Robert Wilson", "P0071", "Tr08"), ("T00072", "Second", "4000", "44580", "Charles Williams", "P0072", "Tr09"), ("T00073", "Second", "4000", "44584", "Jennifer Johnson", "P0073", "Tr01"), ("T00074", "Second", "4000", "44585", "Michael Anderson", "P0074", "Tr02"), ("T00075", "Third", "2000", "44588", "John Brown", "P0075", "Tr03"), ("T00076", "Third", "2000", "44505", "Patricia Smith", "P0076", "Tr04"), ("T00077", "Third", "2000", "44508", "James Moore", "P0077", "Tr05"), ("T00078", "Third", "2000", "44513", "James Taylor", "P0078", "Tr06"), ("T00079", "Third", "2000", "44515", "William Miller", "P0079", "Tr07"), ("T00080", "Third", "2000", "44522", "John Davis", "P0080", "Tr08"), ("T00081", "First", "6000", "44523", "Charles Johnson", "P0081", "Tr09"), ("T00082", "Second", "4000", "44527", "William Davis", "P0082", "Tr01"), ("T00083", "Second", "4000", "44528", "John Jones", "P0083", "Tr02"), ("T00084", "Second", "4000", "44529", "Richard Johnson", "P0084", "Tr03"), ("T00085", "Third", "2000", "44533", "James Anderson", "P0085", "Tr04"), ("T00086", "Third", "2000", "44537", "Robert Taylor", "P0086", "Tr05"), ("T00087", "Third", "2000", "44540", "Barbara Smith", "P0087", "Tr06"), ("T00088", "Third", "2000", "44541", "Michael Moore", "P0088", "Tr07"), ("T00089", "Third", "2000", "44542", "James Martin", "P0089", "Tr08"), ("T00090", "Third", "2000", "44545", "Michael Wilson", "P0090", "Tr09"), ("T00091", "First", "6000", "44558", "James Thomas", "P0091", "Tr01"), ("T00092", "Second", "4000", "44559", "Joseph Smith", "P0092", "Tr02"), ("T00093", "Second", "4000", "44565", "James White", "P0093", "Tr03"), ("T00094", "Second", "4000", "44566", "Mary Miller", "P0094", "Tr04"), ("T00095", "Third", "2000", "44567", "Robert Anderson", "P0095", "Tr05"), ("T00096", "Third", "2000", "44573", "Robert Wilson", "P0096", "Tr06"), ("T00097", "Third", "2000", "44575", "Charles Williams", "P0097", "Tr07"), ("T00098", "Third", "2000", "44577", "Jennifer Johnson", "P0098", "Tr08"), ("T00099", "Third", "2000", "44581", "Michael Anderson", "P0099", "Tr09"), ("T00100", "Third", "2000", "44587", "John Brown", "P0100", "Tr01"), ("T00101", "First", "6000", "44506", "Patricia Smith", "P0101", "Tr02"), ("T00102", "Second", "4000", "44515", "James Moore", "P0102", "Tr03"), ("T00103", "Second", "4000", "44519", "James Taylor", "P0103", "Tr04"), ("T00104", "Second", "4000", "44523", "William Miller", "P0104", "Tr05"), ("T00105", "Third", "2000", "44526", "John Davis", "P0105", "Tr06"), ("T00106", "Third", "2000", "44531", "Charles Johnson", "P0106", "Tr07"), ("T00107", "Third", "2000", "44532", "William Davis", "P0107", "Tr08"), ("T00108", "Third", "2000", "44533", "John Jones", "P0108", "Tr09"), ("T00109", "Third", "2000", "44536", "Richard Johnson", "P0109", "Tr01"), ("T00110", "Third", "2000", "44540", "James Anderson", "P0110", "Tr02"), ("T00111", "First", "6000", "44542", "Robert Taylor", "P0111", "Tr03"), ("T00112", "Second", "4000", "44548", "Barbara Smith", "P0112", "Tr04"), ("T00113", "Second", "4000", "44553", "Michael Moore", "P0113", "Tr05"), ("T00114", "Second", "4000", "44555", "James Martin", "P0114", "Tr06"), ("T00115", "Third", "2000", "44556", "Michael Wilson", "P0115", "Tr07"), ("T00116", "Third", "2000", "44557", "James Thomas", "P0116", "Tr08"), ("T00117", "Third", "2000", "44559", "Joseph Smith", "P0117", "Tr09"), ("T00118", "Third", "2000", "44560", "James White", "P0118", "Tr01"), ("T00119", "Third", "2000", "44561", "Mary Miller", "P0119", "Tr02"), ("T00120", "Third", "2000", "44568", "Robert Anderson", "P0120", "Tr03"), ("T00121", "First", "6000", "44576", "Robert Wilson", "P0121", "Tr04"), ("T00122", "Second", "4000", "44577", "Charles Williams", "P0122", "Tr05"), ("T00123", "Second", "4000", "44582", "Jennifer Johnson", "P0123", "Tr06"), ("T00124", "Second", "4000", "44588", "Michael Anderson", "P0124", "Tr07"), ("T00125", "Third", "2000", "44590", "John Brown", "P0125", "Tr08"), ("T00126", "Third", "2000", "44502", "Patricia Smith", "P0126", "Tr09"), ("T00127", "Third", "2000", "44504", "James Moore", "P0127", "Tr01"), ("T00128", "Third", "2000", "44505", "James Taylor", "P0128", "Tr02"), ("T00129", "Third", "2000", "44507", "William Miller", "P0129", "Tr03"), ("T00130", "Third", "2000", "44513", "John Davis", "P0130", "Tr04"), ("T00131", "First", "6000", "44519", "Charles Johnson", "P0131", "Tr05"), ("T00132", "Second", "4000", "44525", "William Davis", "P0132", "Tr06"), ("T00133", "Second", "4000", "44527", "John Jones", "P0133", "Tr07"), ("T00134", "Second", "4000", "44530", "Richard Johnson", "P0134", "Tr08"), ("T00135", "Third", "2000", "44534", "James Anderson", "P0135", "Tr09"), ("T00136", "Third", "2000", "44541", "Robert Taylor", "P0136", "Tr01"), ("T00137", "Third", "2000", "44542", "Barbara Smith", "P0137", "Tr02"), ("T00138", "Third", "2000", "44546", "Michael Moore", "P0138", "Tr03"), ("T00139", "Third", "2000", "44547", "James Martin", "P0139", "Tr04"), ("T00140", "Third", "2000", "44548", "Michael Wilson", "P0140", "Tr05"), ("T00141", "First", "6000", "44553", "James Thomas", "P0141", "Tr06"), ("T00142", "Second", "4000", "44556", "Joseph Smith", "P0142", "Tr07"), ("T00143", "Second", "4000", "44557", "James White", "P0143", "Tr08"), ("T00144", "Second", "4000", "44558", "Mary Miller", "P0144", "Tr09"), ("T00145", "Third", "2000", "44559", "Robert Anderson", "P0145", "Tr01"), ("T00146", "Third", "2000", "44567", "Robert Wilson", "P0146", "Tr02"), ("T00147", "Third", "2000", "44569", "Charles Williams", "P0147", "Tr03"), ("T00148", "Third", "2000", "44579", "Jennifer Johnson", "P0148", "Tr04"), ("T00149", "Third", "2000", "44581", "Michael Anderson", "P0149", "Tr05"), ("T00150", "Third", "2000", "44584", "John Brown", "P0150", "Tr06"), ("T00151", "First", "6000", "44504", "Patricia Smith", "P0151", "Tr07"), ("T00152", "Second", "4000", "44516", "James Moore", "P0152", "Tr08"), ("T00153", "Second", "4000", "44517", "James Taylor", "P0153", "Tr09"), ("T00154", "Second", "4000", "44518", "William Miller", "P0154", "Tr01"), ("T00155", "Third", "2000", "44522", "John Davis", "P0155", "Tr02"), ("T00156", "Third", "2000", "44523", "Charles Johnson", "P0156", "Tr03"), ("T00157", "Third", "2000", "44528", "William Davis", "P0157", "Tr04"), ("T00158", "Third", "2000", "44529", "John Jones", "P0158", "Tr05"), ("T00159", "Third", "2000", "44537", "Richard Johnson", "P0159", "Tr06"), ("T00160", "Third", "2000", "44546", "James Anderson", "P0160", "Tr07"), ("T00161", "First", "6000", "44552", "Robert Taylor", "P0161", "Tr08"), ("T00162", "Second", "4000", "44553", "Barbara Smith", "P0162", "Tr09"), ("T00163", "Second", "4000", "44555", "Michael Moore", "P0163", "Tr01"), ("T00164", "Second", "4000", "44556", "James Martin", "P0164", "Tr02"), ("T00165", "Third", "2000", "44558", "Michael Wilson", "P0165", "Tr03"), ("T00166", "Third", "2000", "44561", "James Thomas", "P0166", "Tr04"), ("T00167", "Third", "2000", "44563", "Joseph Smith", "P0167", "Tr05"), ("T00168", "Third", "2000", "44564", "James White", "P0168", "Tr06"), ("T00169", "Third", "2000", "44568", "Mary Miller", "P0169", "Tr07"), ("T00170", "Third", "2000", "44571", "Robert Anderson", "P0170", "Tr08"), ("T00171", "First", "6000", "44579", "Robert Wilson", "P0171", "Tr09"), ("T00172", "Second", "4000", "44580", "Charles Williams", "P0172", "Tr01"), ("T00173", "Second", "4000", "44584", "Jennifer Johnson", "P0173", "Tr02"), ("T00174", "Second", "4000", "44585", "Michael Anderson", "P0174", "Tr03"), ("T00175", "Third", "2000", "44588", "John Brown", "P0175", "Tr04"), ("T00176", "Third", "2000", "44505", "Patricia Smith", "P0176", "Tr05"), ("T00177", "Third", "2000", "44508", "James Moore", "P0177", "Tr06"), ("T00178", "Third", "2000", "44513", "James Taylor", "P0178", "Tr07"), ("T00179", "Third", "2000", "44515", "William Miller", "P0179", "Tr08"), ("T00180", "Third", "2000", "44522", "John Davis", "P0180", "Tr09"), ("T00181", "First", "6000", "44523", "Charles Johnson", "P0181", "Tr01"), ("T00182", "Second", "4000", "44527", "William Davis", "P0182", "Tr02"), ("T00183", "Second", "4000", "44528", "John Jones", "P0183", "Tr03"), ("T00184", "Second", "4000", "44529", "Richard Johnson", "P0184", "Tr04"), ("T00185", "Third", "2000", "44533", "James Anderson", "P0185", "Tr05"), ("T00186", "Third", "2000", "44537", "Robert Taylor", "P0186", "Tr06"), ("T00187", "Third", "2000", "44540", "Barbara Smith", "P0187", "Tr07"), ("T00188", "Third", "2000", "44541", "Michael Moore", "P0188", "Tr08"), ("T00189", "Third", "2000", "44542", "James Martin", "P0189", "Tr09"), ("T00190", "Third", "2000", "44545", "Michael Wilson", "P0190", "Tr01"), ("T00191", "First", "6000", "44558", "James Thomas", "P0191", "Tr02"), ("T00192", "Second", "4000", "44559", "Joseph Smith", "P0192", "Tr03"), ("T00193", "Second", "4000", "44565", "James White", "P0193", "Tr04"), ("T00194", "Second", "4000", "44566", "Mary Miller", "P0194", "Tr05"), ("T00195", "Third", "2000", "44567", "Robert Anderson", "P0195", "Tr06"), ("T00196", "Third", "2000", "44573", "Robert Wilson", "P0196", "Tr07"), ("T00197", "Third", "2000", "44575", "Charles Williams", "P0197", "Tr08"), ("T00198", "Third", "2000", "44577", "Jennifer Johnson", "P0198", "Tr09"), ("T00199", "Third", "2000", "44581", "Michael Anderson", "P0199", "Tr01"), ("T00200", "Third", "2000", "44587", "John Brown", "P0200", "Tr02"), ("T00201", "First", "6000", "44506", "Patricia Smith", "P0201", "Tr03"), ("T00202", "Second", "4000", "44515", "James Moore", "P0202", "Tr04"), ("T00203", "Second", "4000", "44519", "James Taylor", "P0203", "Tr05"), ("T00204", "Second", "4000", "44523", "William Miller", "P0204", "Tr06"), ("T00205", "Third", "2000", "44526", "John Davis", "P0205", "Tr07"), ("T00206", "Third", "2000", "44531", "Charles Johnson", "P0206", "Tr08"), ("T00207", "Third", "2000", "44532", "William Davis", "P0207", "Tr09"), ("T00208", "Third", "2000", "44533", "John Jones", "P0208", "Tr01"), ("T00209", "Third", "2000", "44536", "Richard Johnson", "P0209", "Tr02"), ("T00210", "Third", "2000", "44540", "James Anderson", "P0210", "Tr03"), ("T00211", "First", "6000", "44542", "Robert Taylor", "P0211", "Tr04"), ("T00212", "Second", "4000", "44548", "Barbara Smith", "P0212", "Tr05"), ("T00213", "Second", "4000", "44553", "Michael Moore", "P0213", "Tr06"), ("T00214", "Second", "4000", "44555", "James Martin", "P0214", "Tr07"), ("T00215", "Third", "2000", "44556", "Michael Wilson", "P0215", "Tr08"), ("T00216", "Third", "2000", "44557", "James Thomas", "P0216", "Tr09"), ("T00217", "Third", "2000", "44559", "Joseph Smith", "P0217", "Tr01"), ("T00218", "Third", "2000", "44560", "James White", "P0218", "Tr02"), ("T00219", "Third", "2000", "44561", "Mary Miller", "P0219", "Tr03"), ("T00220", "Third", "2000", "44568", "Robert Anderson", "P0220", "Tr04"), ("T00221", "First", "6000", "44576", "Robert Wilson", "P0221", "Tr05"), ("T00222", "Second", "4000", "44577", "Charles Williams", "P0222", "Tr06"), ("T00223", "Second", "4000", "44582", "Jennifer Johnson", "P0223", "Tr07"), ("T00224", "Second", "4000", "44588", "Michael Anderson", "P0224", "Tr08"), ("T00225", "Third", "2000", "44590", "John Brown", "P0225", "Tr09"), ("T00226", "Third", "2000", "44502", "Patricia Smith", "P0226", "Tr01"), ("T00227", "Third", "2000", "44504", "James Moore", "P0227", "Tr02"), ("T00228", "Third", "2000", "44505", "James Taylor", "P0228", "Tr03"), ("T00229", "Third", "2000", "44507", "William Miller", "P0229", "Tr04"), ("T00230", "Third", "2000", "44513", "John Davis", "P0230", "Tr05"), ("T00231", "First", "6000", "44519", "Charles Johnson", "P0231", "Tr06"), ("T00232", "Second", "4000", "44525", "William Davis", "P0232", "Tr07"), ("T00233", "Second", "4000", "44527", "John Jones", "P0233", "Tr08"), ("T00234", "Second", "4000", "44530", "Richard Johnson", "P0234", "Tr09"), ("T00235", "Third", "2000", "44534", "James Anderson", "P0235", "Tr01"), ("T00236", "Third", "2000", "44541", "Robert Taylor", "P0236", "Tr02"), ("T00237", "Third", "2000", "44542", "Barbara Smith", "P0237", "Tr03"), ("T00238", "Third", "2000", "44546", "Michael Moore", "P0238", "Tr04"), ("T00239", "Third", "2000", "44547", "James Martin", "P0239", "Tr05"), ("T00240", "Third", "2000", "44548", "Michael Wilson", "P0240", "Tr06"), ("T00241", "First", "6000", "44553", "James Thomas", "P0241", "Tr07"), ("T00242", "Second", "4000", "44556", "Joseph Smith", "P0242", "Tr08"), ("T00243", "Second", "4000", "44557", "James White", "P0243", "Tr09"), ("T00244", "Second", "4000", "44558", "Mary Miller", "P0244", "Tr01"), ("T00245", "Third", "2000", "44559", "Robert Anderson", "P0245", "Tr02"), ("T00246", "Third", "2000", "44567", "Robert Wilson", "P0246", "Tr03"), ("T00247", "Third", "2000", "44569", "Charles Williams", "P0247", "Tr04"), ("T00248", "Third", "2000", "44579", "Jennifer Johnson", "P0248", "Tr05"), ("T00249", "Third", "2000", "44581", "Michael Anderson", "P0249", "Tr06"), ("T00250", "Third", "2000", "44584", "John Brown", "P0250", "Tr07"), ("T00251", "First", "6000", "44504", "Patricia Smith", "P0251", "Tr08"), ("T00252", "Second", "4000", "44516", "James Moore", "P0252", "Tr09"), ("T00253", "Second", "4000", "44517", "James Taylor", "P0253", "Tr01"), ("T00254", "Second", "4000", "44518", "William Miller", "P0254", "Tr02"), ("T00255", "Third", "2000", "44522", "John Davis", "P0255", "Tr03"), ("T00256", "Third", "2000", "44523", "Charles Johnson", "P0256", "Tr04"), ("T00257", "Third", "2000", "44528", "William Davis", "P0257", "Tr05"), ("T00258", "Third", "2000", "44529", "John Jones", "P0258", "Tr06"), ("T00259", "Third", "2000", "44537", "Richard Johnson", "P0259", "Tr07"), ("T00260", "Third", "2000", "44546", "James Anderson", "P0260", "Tr08"), ("T00261", "First", "6000", "44552", "Robert Taylor", "P0261", "Tr09"), ("T00262", "Second", "4000", "44553", "Barbara Smith", "P0262", "Tr01"), ("T00263", "Second", "4000", "44555", "Michael Moore", "P0263", "Tr02"), ("T00264", "Second", "4000", "44556", "James Martin", "P0264", "Tr03"), ("T00265", "Third", "2000", "44558", "Michael Wilson", "P0265", "Tr04"), ("T00266", "Third", "2000", "44561", "James Thomas", "P0266", "Tr05"), ("T00267", "Third", "2000", "44563", "Joseph Smith", "P0267", "Tr06"), ("T00268", "Third", "2000", "44564", "James White", "P0268", "Tr07"), ("T00269", "Third", "2000", "44568", "Mary Miller", "P0269", "Tr08"), ("T00270", "Third", "2000", "44571", "Robert Anderson", "P0270", "Tr09"), ("T00271", "First", "6000", "44579", "Robert Wilson", "P0271", "Tr01"), ("T00272", "Second", "4000", "44580", "Charles Williams", "P0272", "Tr02"), ("T00273", "Second", "4000", "44584", "Jennifer Johnson", "P0273", "Tr03"), ("T00274", "Second", "4000", "44585", "Michael Anderson", "P0274", "Tr04"), ("T00275", "Third", "2000", "44588", "John Brown", "P0275", "Tr05"), ("T00276", "Third", "2000", "44505", "Patricia Smith", "P0276", "Tr06"), ("T00277", "Third", "2000", "44508", "James Moore", "P0277", "Tr07"), ("T00278", "Third", "2000", "44513", "James Taylor", "P0278", "Tr08"), ("T00279", "Third", "2000", "44515", "William Miller", "P0279", "Tr09"), ("T00280", "Third", "2000", "44522", "John Davis", "P0280", "Tr01"), ("T00281", "First", "6000", "44523", "Charles Johnson", "P0281", "Tr02"), ("T00282", "Second", "4000", "44527", "William Davis", "P0282", "Tr03"), ("T00283", "Second", "4000", "44528", "John Jones", "P0283", "Tr04"), ("T00284", "Second", "4000", "44529", "Richard Johnson", "P0284", "Tr05"), ("T00285", "Third", "2000", "44533", "James Anderson", "P0285", "Tr06"), ("T00286", "Third", "2000", "44537", "Robert Taylor", "P0286", "Tr07"), ("T00287", "Third", "2000", "44540", "Barbara Smith", "P0287", "Tr08"), ("T00288", "Third", "2000", "44541", "Michael Moore", "P0288", "Tr09"), ("T00289", "Third", "2000", "44542", "James Martin", "P0289", "Tr01"), ("T00290", "Third", "2000", "44545", "Michael Wilson", "P0290", "Tr02"), ("T00291", "First", "6000", "44558", "James Thomas", "P0291", "Tr03"), ("T00292", "Second", "4000", "44559", "Joseph Smith", "P0292", "Tr04"), ("T00293", "Second", "4000", "44565", "James White", "P0293", "Tr05"), ("T00294", "Second", "4000", "44566", "Mary Miller", "P0294", "Tr06"), ("T00295", "Third", "2000", "44567", "Robert Anderson", "P0295", "Tr07"), ("T00296", "Third", "2000", "44573", "Robert Wilson", "P0296", "Tr08"), ("T00297", "Third", "2000", "44575", "Charles Williams", "P0297", "Tr09"), ("T00298", "Third", "2000", "44577", "Jennifer Johnson", "P0298", "Tr01"), ("T00299", "Third", "2000", "44581", "Michael Anderson", "P0299", "Tr02"), ("T00300", "Third", "2000", "44587", "John Brown", "P0300", "Tr03");
insert into Train values ("Tn01", "Duronto Express", "400", "130km/h", "20", "43184", "D4001", "M1002"), ("Tn02", "Shatabdi Express", "500", "120km/h", "18", "43247", "D4003", "M1003"), ("Tn03", "Duronto Express", "400", "130km/h", "20", "43376", "D4005", "M1005"), ("Tn04", "Shatabdi Express", "500", "120km/h", "18", "43855", "D4007", "M1006"), ("Tn05", "Duronto Express", "400", "130km/h", "20", "43874", "D4009", "M1008"), ("Tn06", "Rajdhani Express", "600", "140km/h", "22", "43878", "D4011", "M1011"), ("Tn07", "Kavi Guru Express", "300", "110km/h", "12", "44059", "D4013", "M1012"), ("Tn08", "Kavi Guru Express", "300", "110km/h", "12", "44095", "D4015", "M1014"), ("Tn09", "Kavi Guru Express", "300", "110km/h", "12", "44148", "D4016", "M1016"), ("Tn10", "Vande Bharat Express", "700", "200km/h", "16", "44207", "D4017", "M1017"), ("Tn11", "Tejas Express", "750", "130km/h", "13", "44211", "D4019", "M1018"), ("Tn12", "Superfast Express", "640", "100km/h", "15", "44261", "D4021", "M1020"), ("Tn13", "UDAY Express", "550", "110km/h", "12", "44345", "D4022", "M1021"), ("Tn14", "Superfast Express", "640", "100km/h", "15", "44363", "D4024", "M1023"), ("Tn15", "Superfast Express", "640", "100km/h", "15", "44400", "D4025", "M1024");
insert into Trip values ("Tr01", "7:15 AM", "11:15 AM", "ST10001", "ST10006", "Tn01", "Emp026"), ("Tr02", "8:05 AM", "12:35 PM", "ST10002", "ST10004", "Tn03", "Emp029"), ("Tr03", "8:55 AM", "2:15 PM", "ST10003", "ST10007", "Tn05", "Emp032"), ("Tr04", "9:05 AM", "3:15 PM", "ST10004", "ST10001", "Tn06", "Emp035"), ("Tr05", "11:45 AM", "3:50 PM", "ST10005", "ST10010", "Tn08", "Emp038"), ("Tr06", "1:15 PM", "5:25 PM", "ST10006", "ST10002", "Tn09", "Emp041"), ("Tr07", "2:45 PM", "6:15 PM", "ST10007", "ST10005", "Tn11", "Emp044"), ("Tr08", "3:45 PM", "7:40 PM", "ST10008", "ST10003", "Tn12", "Emp046"), ("Tr09", "6:30 PM", "8:20 PM", "ST10009", "ST10008", "Tn14", "Emp048"), ("Tr10", "6:35 PM", "9:50 PM", "ST10010", "ST10009", "Tn15", "Emp050");