Submitted To: Mam Farwa

Name: Hassan Wahla

Registration NO: 24-UON-0380
Semester: BS CS 3rd (M)-B

Project Title: Train Management System

Phase 1: Table Creation (Schema)

 1. Train Table
CREATE TABLE Train_Table (
Train_ID INT PRIMARY KEY,
Name VARCHAR(100),
Type VARCHAR(50),
Status VARCHAR(50)
);

 2. Coach Type Table

CREATE TABLE Coach_Type_Table (
Coach_type_ID INT PRIMARY KEY,
Type_name VARCHAR(50),
Seat_capacity INT
);

 3. Coach Table
CREATE TABLE Coach_Table (
Coach_ID INT PRIMARY KEY,
Train_ID INT,
Coach_type_ID INT,
Coach_No VARCHAR(20),
FOREIGN KEY (Train_ID) REFERENCES Train_Table(Train_ID),
FOREIGN KEY (Coach_type_ID) REFERENCES Coach_Type_Table(Coach_type_ID)
);

 4. Station Table
CREATE TABLE Station_Table (
Station_ID INT PRIMARY KEY,
Station_Name VARCHAR(100),
City VARCHAR(100),
State VARCHAR(100)
);

 5. Route Table
1
CREATE TABLE Route_Table (
Route_ID INT PRIMARY KEY,
Name VARCHAR(100),
Start_station_ID INT,
End_station_ID INT,
Type VARCHAR(50),
FOREIGN KEY (Start_station_ID) REFERENCES Station_Table(Station_ID),
FOREIGN KEY (End_station_ID) REFERENCES Station_Table(Station_ID)
);

 6. Schedule Table
CREATE TABLE Schedule_Table (
Schedule_ID INT PRIMARY KEY,
Route_ID INT,
Train_ID INT,
Depart_Time TIME,
Arrival_time TIME,
Travel_day VARCHAR(20),
FOREIGN KEY (Route_ID) REFERENCES Route_Table(Route_ID),
FOREIGN KEY (Train_ID) REFERENCES Train_Table(Train_ID)
);

 7. Passenger Table
CREATE TABLE Passenger_Table (
Pass_ID INT PRIMARY KEY,
Name VARCHAR(100),
Contact VARCHAR(20),
Gender VARCHAR(10), CNIC VARCHAR(20)
);

 8. Staff Table
CREATE TABLE Staff_Table (
Staff_ID INT PRIMARY KEY,
Name VARCHAR(100),
Role VARCHAR(50),
Email VARCHAR(100),
Train_ID INT,
FOREIGN KEY (Train_ID) REFERENCES Train_Table(Train_ID)
);

 9. Seat Table
CREATE TABLE Seat_Table (
Seat_ID INT PRIMARY KEY,
Coach_ID INT,
Seat_No INT,
Class VARCHAR(50),
2
 Window_side VARCHAR(5),
FOREIGN KEY (Coach_ID) REFERENCES Coach_Table(Coach_ID)
);

 10. Ticket Table

CREATE TABLE Ticket_Table (
Ticket_ID INT PRIMARY KEY,
Pass_ID INT,
Schedule_ID INT,
Seat_ID INT,
Booking_date DATE,
FOREIGN KEY (Pass_ID) REFERENCES Passenger_Table(Pass_ID),
FOREIGN KEY (Schedule_ID) REFERENCES Schedule_Table(Schedule_ID),
FOREIGN KEY (Seat_ID) REFERENCES Seat_Table(Seat_ID)
);
Phase 2: insertion 100 entries
 Train Table:
INSERT INTO Train_Table (Train_ID, Name, Type, Status) VALUES
(1, ‘Green Line Express’, ‘Express’, ‘Active’),
(2, ‘Tezgam’, ‘Express’, ‘Active’),
(3, ‘Karakoram Express’, ‘Luxury’, ‘Active’),
(4, ‘Pak Business Express’, ‘Business’, ‘Active’),
(5, ‘Jaffar Express’, ‘Express’, ‘Active’),
(6, ‘Khyber Mail’, ‘Mail’, ‘Active’),
(7, ‘Awam Express’, ‘Express’, ‘Active’),
(8, ‘Allama Iqbal Express’, ‘Express’, ‘Active’),
(9, ‘Millat Express’, ‘Express’, ‘Maintenance’),
(10, ‘Rehman Baba Express’, ‘Express’, ‘Active’),
(11, ‘Hazara Express’, ‘Passenger’, ‘Active’),
(12, ‘Karachi Express’, ‘Luxury’, ‘Active’),
(13, ‘Shalimar Express’, ‘Business’, ‘Active’),
(14, ‘Buraq Express’, ‘Express’, ‘Active’),
(15, ‘Fareed Express’, ‘Passenger’, ‘Active’),
(16, ‘Mohenjo Daro Express’, ‘Passenger’, ‘Active’),
(17, ‘Sukkur Express’, ‘Express’, ‘Active’),
(18, ‘Musa Pak Express’, ‘Express’, ‘Active’),
(19, ‘Mehran Express’, ‘Passenger’, ‘Active’),
(20, ‘Badar Express’, ‘Passenger’, ‘Maintenance’),
(21, ‘Ghouri Express’, ‘Express’, ‘Active’),
(22, ‘Sandal Express’, ‘Passenger’, ‘Active’),
(23, ‘Sargodha Express’, ‘Express’, ‘Active’),
(24, ‘Chenab Express’, ‘Mail’, ‘Active’),
(25, ‘Abaseen Express’, ‘Mail’, ‘Active’),
(26, ‘Boltan Express’, ‘Express’, ‘Active’),
(27, ‘Mehran Express’, ‘Express’, ‘Active’),
(28, ‘Sindh Express’, ‘Luxury’, ‘Active’),
3
(29, ‘Punjab Express’, ‘Business’, ‘Active’),
(30, ‘Khyber Express’, ‘Express’, ‘Active’),
(31, ‘Marala Express’, ‘Passenger’, ‘Active’),
(32, ‘Ravi Express’, ‘Passenger’, ‘Active’),
(33, ‘Chaman Express’, ‘Mail’, ‘Active’),
(34, ‘Quetta Express’, ‘Luxury’, ‘Active’),
(35, ‘Peshawar Express’, ‘Express’, ‘Active’),
(36, ‘Lahore Express’, ‘Express’, ‘Active’),
(37, ‘Multan Express’, ‘Business’, ‘Active’),
(38, ‘Faisalabad Express’, ‘Express’, ‘Active’),
(39, ‘Sialkot Express’, ‘Passenger’, ‘Active’),
(40, ‘Gujrat Express’, ‘Mail’, ‘Active’),
(41, ‘Wazirabad Express’, ‘Express’, ‘Active’),
(42, ‘Lalamusa Express’, ‘Passenger’, ‘Active’),
(43, ‘Attock Express’, ‘Express’, ‘Active’),
(44, ‘Mardan Express’, ‘Mail’, ‘Active’),
(45, ‘Nowshera Express’, ‘Express’, ‘Active’),
(46, ‘Malakand Express’, ‘Luxury’, ‘Active’),
(47, ‘Swat Express’, ‘Business’, ‘Active’),
(48, ‘Gilgit Express’, ‘Express’, ‘Active’),
(49, ‘Hunza Express’, ‘Express’, ‘Active’),
(50, ‘Skardu Express’, ‘Luxury’, ‘Active’),
(51, ‘Gwadar Express’, ‘Business’, ‘Active’),
(52, ‘Pasni Express’, ‘Express’, ‘Active’),
(53, ‘Ormara Express’, ‘Passenger’, ‘Active’),
(54, ‘Jiwan Express’, ‘Express’, ‘Active’),
(55, ‘Bela Express’, ‘Mail’, ‘Active’),
(56, ‘Hub Express’, ‘Express’, ‘Active’),
(57, ‘Uthal Express’, ‘Passenger’, ‘Active’),
(58, ‘Khuzdar Express’, ‘Express’, ‘Active’),
(59, ‘Kalat Express’, ‘Luxury’, ‘Active’),
(60, ‘Mastungs Express’, ‘Business’, ‘Active’),
(61, ‘Nushki Express’, ‘Express’, ‘Active’),
(62, ‘Chaghi Express’, ‘Express’, ‘Active’),
(63, ‘Kharan Express’, ‘Passenger’, ‘Active’),
(64, ‘Washuk Express’, ‘Mail’, ‘Active’),
(65, ‘Panjgur Express’, ‘Express’, ‘Active’),
(66, ‘Kech Express’, ‘Business’, ‘Active’),
(67, ‘Turbat Express’, ‘Luxury’, ‘Active’),
(68, ‘Sibi Express’, ‘Express’, ‘Active’),
(69, ‘Dera Bugti Express’, ‘Express’, ‘Active’),
(70, ‘Kohlu Express’, ‘Passenger’, ‘Active’),
(71, ‘Barkhan Express’, ‘Mail’, ‘Active’),
(72, ‘Musakhel Express’, ‘Express’, ‘Active’),
(73, ‘Sherani Express’, ‘Business’, ‘Active’),
(74, ‘Zhob Express’, ‘Luxury’, ‘Active’),
(75, ‘Loralai Express’, ‘Express’, ‘Active’),
(76, ‘Dukki Express’, ‘Express’, ‘Active’),
4
(77, ‘Ziarat Express’, ‘Passenger’, ‘Active’),
(78, ‘Harnai Express’, ‘Mail’, ‘Active’),
(79, ‘Boltan Express’, ‘Express’, ‘Active’),
(80, ‘Kachhi Express’, ‘Business’, ‘Active’),
(81, ‘Jhal Magsi Express’, ‘Luxury’, ‘Active’),
(82, ‘Nasirabad Express’, ‘Express’, ‘Active’),
(83, ‘Jaffarabad Express’, ‘Express’, ‘Active’),
(84, ‘Sohbatpur Express’, ‘Passenger’, ‘Active’),
(85, ‘Dera Murad Express’, ‘Mail’, ‘Active’),
(86, ‘Dera Allah Express’, ‘Express’, ‘Active’),
(87, ‘Jacobabad Express’, ‘Business’, ‘Active’),
(88, ‘Shikarpur Express’, ‘Luxury’, ‘Active’),
(89, ‘Larkana Express’, ‘Express’, ‘Active’),
(90, ‘Kamber Express’, ‘Express’, ‘Active’),
(91, ‘Shahdadkot Express’, ‘Passenger’, ‘Active’),
(92, ‘Dadu Express’, ‘Mail’, ‘Active’),
(93, ‘Jamshoro Express’, ‘Express’, ‘Active’),
(94, ‘Thatta Express’, ‘Business’, ‘Active’),
(95, ‘Badin Express’, ‘Luxury’, ‘Active’),
(96, ‘Sujawal Express’, ‘Express’, ‘Active’),
(97, ‘Tando Express’, ‘Express’, ‘Active’),
(98, ‘Hala Express’, ‘Passenger’, ‘Active’),
(99, ‘Sanghar Express’, ‘Mail’, ‘Active’),
(100, ‘Umerkot Express’, ‘Express’, ‘Active’);

 Coach Type Table :

INSERT INTO Coach_Type_Table (Coach_type_ID, Type_name, Seat_capacity) VALUES

(1, 'AC Sleeper Class', 18),
(2, 'AC Business Class', 40),
(3, 'AC Standard Class', 54),
(4, 'Economy Class', 80),
(5, 'First Class Sleeper', 24),
(6, 'Parlor Car', 36),
(7, 'Executive Class', 30),
(8, 'Power Van', 0),
(9, 'Dining Car', 20),
(10, 'Luggage Van', 0),
(11, 'AC Sleeper (A1)', 18),
(12, 'AC Business (B1)', 40),
(13, 'AC Standard (S1)', 54),
(14, 'Economy (E1)', 80),
(15, 'First Class (F1)', 24),
(16, 'Executive (EX1)', 30),
(17, 'Dining (D1)', 20),
(18, 'AC Sleeper (A2)', 18),
(19, 'AC Business (B2)', 40),
5
(20, 'AC Standard (S2)', 54),
(21, 'Economy (E2)', 80),
(22, 'First Class (F2)', 24),
(23, 'Executive (EX2)', 30),
(24, 'Dining (D2)', 20),
(25, 'AC Sleeper (A3)', 18),
(26, 'AC Business (B3)', 40),
(27, 'AC Standard (S3)', 54),
(28, 'Economy (E3)', 80),
(29, 'First Class (F3)', 24),
(30, 'Executive (EX3)', 30),
(31, 'Coach Type T31', 45),
(32, 'Coach Type T32', 45),
(33, 'Coach Type T33', 45),
(34, 'Coach Type T34', 45),
(35, 'Coach Type T35', 45),
(36, 'Coach Type T36', 45),
(37, 'Coach Type T37', 45),
(38, 'Coach Type T38', 45),
(39, 'Coach Type T39', 45),
(40, 'Coach Type T40', 45),
(41, 'Coach Type T41', 50),
(42, 'Coach Type T42', 50),
(43, 'Coach Type T43', 50),
(44, 'Coach Type T44', 50),
(45, 'Coach Type T45', 50),
(46, 'Coach Type T46', 50),
(47, 'Coach Type T47', 50),
(48, 'Coach Type T48', 50),
(49, 'Coach Type T49', 50),
(50, 'Coach Type T50', 50),
(51, 'Coach Type T51', 60),
(52, 'Coach Type T52', 60),
(53, 'Coach Type T53', 60),
(54, 'Coach Type T54', 60),
(55, 'Coach Type T55', 60),
(56, 'Coach Type T56', 60),
(57, 'Coach Type T57', 60),
(58, 'Coach Type T58', 60),
(59, 'Coach Type T59', 60),
(60, 'Coach Type T60', 60),
(61, 'Coach Type T61', 65),
(62, 'Coach Type T62', 65),
(63, 'Coach Type T63', 65),
(64, 'Coach Type T64', 65),
(65, 'Coach Type T65', 65),
(66, 'Coach Type T66', 65),
(67, 'Coach Type T67', 65),
6
 (68, 'Coach Type T68', 65),
(69, 'Coach Type T69', 65),
(70, 'Coach Type T70', 65),
(71, 'Coach Type T71', 70),
(72, 'Coach Type T72', 70),
(73, 'Coach Type T73', 70),
(74, 'Coach Type T74', 70),
(75, 'Coach Type T75', 70),
(76, 'Coach Type T76', 70),
(77, 'Coach Type T77', 70),
(78, 'Coach Type T78', 70),
(79, 'Coach Type T79', 70),
(80, 'Coach Type T80', 70),
(81, 'Coach Type T81', 75),
(82, 'Coach Type T82', 75),
(83, 'Coach Type T83', 75),
(84, 'Coach Type T84', 75),
(85, 'Coach Type T85', 75),
(86, 'Coach Type T86', 75),
(87, 'Coach Type T87', 75),
(88, 'Coach Type T88', 75),
(89, 'Coach Type T89', 75),
(90, 'Coach Type T90', 75),
(91, 'Coach Type T91', 80),
(92, 'Coach Type T92', 80),
(93, 'Coach Type T93', 80),
(94, 'Coach Type T94', 80),
(95, 'Coach Type T95', 80),
(96, 'Coach Type T96', 80),
(97, 'Coach Type T97', 80),
(98, 'Coach Type T98', 80),
(99, 'Coach Type T99', 80),
(100, 'Coach Type T100', 80);

 Coach Table:
INSERT INTO Coach_Table (Coach_ID, Train_ID, Coach_type_ID, Coach_No) VALUES
(1, 1, 1, 'G-01'), (2, 2, 2, 'T-01'), (3, 3, 3, 'K-01'), (4, 4, 4, 'P-01'), (5, 5, 5, 'J-01'),
(6, 6, 6, 'KM-01'), (7, 7, 7, 'A-01'), (8, 8, 8, 'AL-01'), (9, 9, 9, 'M-01'), (10, 10, 10, 'R-01'),
(11, 11, 11, 'H-11'), (12, 12, 12, 'K-12'), (13, 13, 13, 'S-13'), (14, 14, 14, 'B-14'), (15, 15, 15, 'F-15'),
(16, 16, 16, 'M-16'), (17, 17, 17, 'S-17'), (18, 18, 18, 'M-18'), (19, 19, 19, 'M-19'), (20, 20, 20, 'B-20'),
(21, 21, 21, 'G-21'), (22, 22, 22, 'S-22'), (23, 23, 23, 'S-23'), (24, 24, 24, 'C-24'), (25, 25, 25, 'A-25'),
(26, 26, 26, 'B-26'), (27, 27, 27, 'M-27'), (28, 28, 28, 'S-28'), (29, 29, 29, 'P-29'), (30, 30, 30, 'K-30'),
(31, 31, 31, 'M-31'), (32, 32, 32, 'R-32'), (33, 33, 33, 'C-33'), (34, 34, 34, 'Q-34'), (35, 35, 35, 'P-35'),
(36, 36, 36, 'L-36'), (37, 37, 37, 'M-37'), (38, 38, 38, 'F-38'), (39, 39, 39, 'S-39'), (40, 40, 40, 'G-40'),
(41, 41, 41, 'W-41'), (42, 42, 42, 'L-42'), (43, 43, 43, 'A-43'), (44, 44, 44, 'M-44'), (45, 45, 45, 'N-45'),
(46, 46, 46, 'M-46'), (47, 47, 47, 'S-47'), (48, 48, 48, 'G-48'), (49, 49, 49, 'H-49'), (50, 50, 50, 'S-50'),
7
(51, 51, 51, 'G-51'), (52, 52, 52, 'P-52'), (53, 53, 53, 'O-53'), (54, 54, 54, 'J-54'), (55, 55, 55, 'B-55'),
(56, 56, 56, 'H-56'), (57, 57, 57, 'U-57'), (58, 58, 58, 'K-58'), (59, 59, 59, 'K-59'), (60, 60, 60, 'M-60'),
(61, 61, 61, 'N-61'), (62, 62, 62, 'C-62'), (63, 63, 63, 'K-63'), (64, 64, 64, 'W-64'), (65, 65, 65, 'P-65'),
(66, 66, 66, 'K-66'), (67, 67, 67, 'T-67'), (68, 68, 68, 'S-68'), (69, 69, 69, 'D-69'), (70, 70, 70, 'K-70'),
(71, 71, 71, 'B-71'), (72, 72, 72, 'M-72'), (73, 73, 73, 'S-73'), (74, 74, 74, 'Z-74'), (75, 75, 75, 'L-75'),
(76, 76, 76, 'D-76'), (77, 77, 77, 'Z-77'), (78, 78, 78, 'H-78'), (79, 79, 79, 'B-79'), (80, 80, 80, 'K-80'),
(81, 81, 81, 'J-81'), (82, 82, 82, 'N-82'), (83, 83, 83, 'J-83'), (84, 84, 84, 'S-84'), (85, 85, 85, 'D-85'),
(86, 86, 86, 'D-86'), (87, 87, 87, 'J-87'), (88, 88, 88, 'S-88'), (89, 89, 89, 'L-89'), (90, 90, 90, 'K-90'),
(91, 91, 91, 'S-91'), (92, 92, 92, 'D-92'), (93, 93, 93, 'J-93'), (94, 94, 94, 'T-94'), (95, 95, 95, 'B-95'),
(96, 96, 96, 'S-96'), (97, 97, 97, 'T-97'), (98, 98, 98, 'H-98'), (99, 99, 99, 'S-99'), (100, 100, 100, 'U-
100');

 Station Table:
INSERT INTO Station_Table (Station_ID, Station_Name, City, State) VALUES
(1, 'Lahore Junction', 'Lahore', 'Punjab'),
(2, 'Karachi City', 'Karachi', 'Sindh'),
(3, 'Rawalpindi Station', 'Rawalpindi', 'Punjab'),
(4, 'Peshawar Cantt', 'Peshawar', 'KPK'),
(5, 'Quetta Station', 'Quetta', 'Balochistan'),
(6, 'Multan City', 'Multan', 'Punjab'),
(7, 'Faisalabad Station', 'Faisalabad', 'Punjab'),
(8, 'Hyderabad Junction', 'Hyderabad', 'Sindh'),
(9, 'Sialkot Junction', 'Sialkot', 'Punjab'),
(10, 'Gujranwala Station', 'Gujranwala', 'Punjab'),
(11, 'Bahawalpur Station', 'Bahawalpur', 'Punjab'),
(12, 'Sargodha Junction', 'Sargodha', 'Punjab'),
(13, 'Sukkur Station', 'Sukkur', 'Sindh'),
(14, 'Larkana Junction', 'Larkana', 'Sindh'),
(15, 'Nawabshah Station', 'Nawabshah', 'Sindh'),
(16, 'Attock City', 'Attock', 'Punjab'),
(17, 'Jhelum Station', 'Jhelum', 'Punjab'),
(18, 'Khanewal Junction', 'Khanewal', 'Punjab'),
(19, 'Rahim Yar Khan', 'RYK', 'Punjab'),
(20, 'Jacobabad Junction', 'Jacobabad', 'Sindh'),
(21, 'Gujrat Station', 'Gujrat', 'Punjab'),
(22, 'Mardan Station', 'Mardan', 'KPK'),
(23, 'Kasur Station', 'Kasur', 'Punjab'),
(24, 'Sahiwal Station', 'Sahiwal', 'Punjab'),
(25, 'Okara Station', 'Okara', 'Punjab'),
(26, 'Wah Cantt', 'Wah', 'Punjab'),
(27, 'Dera Ghazi Khan', 'DG Khan', 'Punjab'),
(28, 'Mirpur Khas', 'Mirpur', 'Sindh'),
(29, 'Chaman Station', 'Chaman', 'Balochistan'),
(30, 'Ziarat Station', 'Ziarat', 'Balochistan'),
(31, 'Muzaffargarh', 'Muzaffargarh', 'Punjab'),
(32, 'Abbottabad', 'Abbottabad', 'KPK'),
8
(33, 'Kohat Junction', 'Kohat', 'KPK'),
(34, 'Bannu Station', 'Bannu', 'KPK'),
(35, 'Nowshera', 'Nowshera', 'KPK'),
(36, 'Taxila Junction', 'Taxila', 'Punjab'),
(37, 'Chakwal Station', 'Chakwal', 'Punjab'),
(38, 'Mianwali', 'Mianwali', 'Punjab'),
(39, 'Bhakkar', 'Bhakkar', 'Punjab'),
(40, 'Leiah', 'Leiah', 'Punjab'),
(41, 'Kot Addu', 'Kot Addu', 'Punjab'),
(42, 'Rajanpur', 'Rajanpur', 'Punjab'),
(43, 'Lodhran', 'Lodhran', 'Punjab'),
(44, 'Vehari', 'Vehari', 'Punjab'),
(45, 'Burewala', 'Burewala', 'Punjab'),
(46, 'Pakpattan', 'Pakpattan', 'Punjab'),
(47, 'Chishtian', 'Chishtian', 'Punjab'),
(48, 'Bahawalnagar', 'Bahawalnagar', 'Punjab'),
(49, 'Haroonabad', 'Haroonabad', 'Punjab'),
(50, 'Fort Abbas', 'Fort Abbas', 'Punjab'),
(51, 'Tando Adam', 'Tando Adam', 'Sindh'),
(52, 'Shahdadpur', 'Shahdadpur', 'Sindh'),
(53, 'Kairpur', 'Khairpur', 'Sindh'),
(54, 'Ghotki', 'Ghotki', 'Sindh'),
(55, 'Pano Akil', 'Pano Akil', 'Sindh'),
(56, 'Rohri Junction', 'Rohri', 'Sindh'),
(57, 'Daharki', 'Daharki', 'Sindh'),
(58, 'Mirpur Mathelo', 'Mirpur M', 'Sindh'),
(59, 'Umerkot', 'Umerkot', 'Sindh'),
(60, 'Tharparkar', 'Mithi', 'Sindh'),
(61, 'Badin Station', 'Badin', 'Sindh'),
(62, 'Thatta Station', 'Thatta', 'Sindh'),
(63, 'Kotri Junction', 'Kotri', 'Sindh'),
(64, 'Jamshoro', 'Jamshoro', 'Sindh'),
(65, 'Dadu Station', 'Dadu', 'Sindh'),
(66, 'Sehwan Sharif', 'Sehwan', 'Sindh'),
(67, 'Matiari', 'Matiari', 'Sindh'),
(68, 'Tando Allahyar', 'Tando AY', 'Sindh'),
(69, 'Sanghar', 'Sanghar', 'Sindh'),
(70, 'Kashmore', 'Kashmore', 'Sindh'),
(71, 'Sibi Junction', 'Sibi', 'Balochistan'),
(72, 'Harnai', 'Harnai', 'Balochistan'),
(73, 'Loralai', 'Loralai', 'Balochistan'),
(74, 'Zhob Station', 'Zhob', 'Balochistan'),
(75, 'Dalbandin', 'Dalbandin', 'Balochistan'),
(76, 'Nushki', 'Nushki', 'Balochistan'),
(77, 'Gwadar Port', 'Gwadar', 'Balochistan'),
(78, 'Pasni Station', 'Pasni', 'Balochistan'),
(79, 'Turbat Station', 'Turbat', 'Balochistan'),
(80, 'Khuzdar', 'Khuzdar', 'Balochistan'),
9
(81, 'Swat City', 'Saidu Sharif', 'KPK'),
(82, 'Chitral', 'Chitral', 'KPK'),
(83, 'Dir Station', 'Dir', 'KPK'),
(84, 'Malakand', 'Malakand', 'KPK'),
(85, 'Shangla', 'Alpuri', 'KPK'),
(86, 'Bunair', 'Daggar', 'KPK'),
(87, 'Haripur', 'Haripur', 'KPK'),
(88, 'Mansehra', 'Mansehra', 'KPK'),
(89, 'Battagram', 'Battagram', 'KPK'),
(90, 'Kohistan', 'Dassu', 'KPK'),
(91, 'Hangu', 'Hangu', 'KPK'),
(92, 'Karak', 'Karak', 'KPK'),
(93, 'Lakki Marwat', 'Lakki', 'KPK'),
(94, 'Tank Station', 'Tank', 'KPK'),
(95, 'Dera Ismail Khan', 'DI Khan', 'KPK'),
(96, 'Gilgit Station', 'Gilgit', 'GB'),
(97, 'Skardu Station', 'Skardu', 'GB'),
(98, 'Hunza Junction', 'Hunza', 'GB'),
(99, 'Muzaffarabad', 'Muzaffarabad', 'AJK'),
(100, 'Mirpur Station', 'Mirpur', 'AJK');

 Route Table
INSERT INTO Route_Table (Route_ID, Name, Start_station_ID, End_station_ID, Type) VALUES
(1, 'Lahore-Karachi Main', 1, 2, 'Long'),
(2, 'Karachi-Lahore Main', 2, 1, 'Long'),
(3, 'Lahore-Rawalpindi', 1, 3, 'Short'),
(4, 'Rawalpindi-Peshawar', 3, 4, 'Short'),
(5, 'Karachi-Quetta', 2, 5, 'Long'),
(6, 'Multan-Lahore', 6, 1, 'Short'),
(7, 'Faisalabad-Multan', 7, 6, 'Short'),
(8, 'Hyderabad-Karachi', 8, 2, 'Express'),
(9, 'Sialkot-Lahore', 9, 1, 'Short'),
(10, 'Gujranwala-Rawalpindi', 10, 3, 'Short'),
(11, 'Bahawalpur-Multan', 11, 6, 'Short'),
(12, 'Sargodha-Lahore', 12, 1, 'Express'),
(13, 'Sukkur-Hyderabad', 13, 8, 'Long'),
(14, 'Larkana-Sukkur', 14, 13, 'Short'),
(15, 'Nawabshah-Karachi', 15, 2, 'Express'),
(16, 'Attock-Peshawar', 16, 4, 'Short'),
(17, 'Jhelum-Rawalpindi', 17, 3, 'Short'),
(18, 'Khanewal-Lahore', 18, 1, 'Short'),
(19, 'RYK-Bahawalpur', 19, 11, 'Short'),
(20, 'Jacobabad-Quetta', 20, 5, 'Long'),
(21, 'Lahore-Faisalabad', 1, 7, 'Express'),
(22, 'Karachi-Sukkur', 2, 13, 'Long'),
(23, 'Peshawar-Rawalpindi', 4, 3, 'Short'),
1
0
(24, 'Quetta-Lahore', 5, 1, 'Long'),
(25, 'Multan-Karachi', 6, 2, 'Long'),
(26, 'Sargodha-Faisalabad', 12, 7, 'Short'),
(27, 'Sialkot-Rawalpindi', 9, 3, 'Short'),
(28, 'Gujrat-Lahore', 21, 1, 'Short'),
(29, 'Mardan-Peshawar', 22, 4, 'Short'),
(30, 'Kasur-Lahore', 23, 1, 'Short'),
(31, 'Sahiwal-Lahore', 24, 1, 'Short'),
(32, 'Okara-Lahore', 25, 1, 'Short'),
(33, 'Wah-Rawalpindi', 26, 3, 'Short'),
(34, 'DG Khan-Multan', 27, 6, 'Short'),
(35, 'Mirpur-Hyderabad', 28, 8, 'Short'),
(36, 'Chaman-Quetta', 29, 5, 'Short'),
(37, 'Ziarat-Quetta', 30, 5, 'Short'),
(38, 'Muzaffargarh-Multan', 31, 6, 'Short'),
(39, 'Abbottabad-Rawalpindi', 32, 3, 'Long'),
(40, 'Kohat-Peshawar', 33, 4, 'Short'),
(41, 'Bannu-Peshawar', 34, 4, 'Short'),
(42, 'Nowshera-Peshawar', 35, 4, 'Short'),
(43, 'Taxila-Rawalpindi', 36, 3, 'Short'),
(44, 'Chakwal-Lahore', 37, 1, 'Short'),
(45, 'Mianwali-Lahore', 38, 1, 'Long'),
(46, 'Bhakkar-Multan', 39, 6, 'Short'),
(47, 'Leiah-Multan', 40, 6, 'Short'),
(48, 'Kot Addu-Multan', 41, 6, 'Short'),
(49, 'Rajanpur-DG Khan', 42, 27, 'Short'),
(50, 'Lodhran-Bahawalpur', 43, 11, 'Short'),
(51, 'Vehari-Multan', 44, 6, 'Short'),
(52, 'Burewala-Sahiwal', 45, 24, 'Short'),
(53, 'Pakpattan-Sahiwal', 46, 24, 'Short'),
(54, 'Chishtian-Bahawalnagar', 47, 48, 'Short'),
(55, 'Haroonabad-Bahawalnagar', 49, 48, 'Short'),
(56, 'Fort Abbas-Bahawalnagar', 50, 48, 'Short'),
(57, 'Tando Adam-Hyderabad', 51, 8, 'Short'),
(58, 'Shahdadpur-Hyderabad', 52, 8, 'Short'),
(59, 'Khairpur-Sukkur', 53, 13, 'Short'),
(60, 'Ghotki-Sukkur', 54, 13, 'Short'),
(61, 'Pano Akil-Sukkur', 55, 13, 'Short'),
(62, 'Rohri-Sukkur', 56, 13, 'Short'),
(63, 'Daharki-Sukkur', 57, 13, 'Short'),
(64, 'Mirpur M-Sukkur', 58, 13, 'Short'),
(65, 'Umerkot-Mirpur', 59, 28, 'Short'),
(66, 'Mithi-Mirpur', 60, 28, 'Short'),
(67, 'Badin-Hyderabad', 61, 8, 'Short'),
(68, 'Thatta-Karachi', 62, 2, 'Short'),
(69, 'Kotri-Hyderabad', 63, 8, 'Short'),
(70, 'Jamshoro-Hyderabad', 64, 8, 'Short'),
(71, 'Dadu-Hyderabad', 65, 8, 'Short'),
1
1
(72, 'Sehwan-Hyderabad', 66, 8, 'Short'),
(73, 'Matiari-Hyderabad', 67, 8, 'Short'),
(74, 'Tando AY-Hyderabad', 68, 8, 'Short'),
(75, 'Sanghar-Hyderabad', 69, 8, 'Short'),
(76, 'Kashmore-Sukkur', 70, 13, 'Short'),
(77, 'Sibi-Quetta', 71, 5, 'Short'),
(78, 'Harnai-Sibi', 72, 71, 'Short'),
(79, 'Loralai-Quetta', 73, 5, 'Long'),
(80, 'Zhob-Quetta', 74, 5, 'Long'),
(81, 'Dalbandin-Quetta', 75, 5, 'Long'),
(82, 'Nushki-Quetta', 76, 5, 'Short'),
(83, 'Gwadar-Quetta', 77, 5, 'Long'),
(84, 'Pasni-Gwadar', 78, 77, 'Short'),
(85, 'Turbat-Gwadar', 79, 77, 'Short'),
(86, 'Khuzdar-Quetta', 80, 5, 'Long'),
(87, 'Swat-Peshawar', 81, 4, 'Long'),
(88, 'Chitral-Peshawar', 82, 4, 'Long'),
(89, 'Dir-Peshawar', 83, 4, 'Long'),
(90, 'Malakand-Mardan', 84, 22, 'Short'),
(91, 'Shangla-Swat', 85, 81, 'Short'),
(92, 'Bunair-Swat', 86, 81, 'Short'),
(93, 'Haripur-Rawalpindi', 87, 3, 'Short'),
(94, 'Mansehra-Abbottabad', 88, 32, 'Short'),
(95, 'Battagram-Mansehra', 89, 88, 'Short'),
(96, 'DI Khan-Multan', 95, 6, 'Long'),
(97, 'Gilgit-Rawalpindi', 96, 3, 'Long'),
(98, 'Skardu-Gilgit', 97, 96, 'Long'),
(99, 'Muzaffarabad-Rawalpindi', 99, 3, 'Long'),
(100, 'Mirpur-Rawalpindi', 100, 3, 'Short');

 Schedule Table:
INSERT INTO Schedule_Table (Schedule_ID, Route_ID, Train_ID, Depart_Time, Arrival_time,
Travel_day) VALUES
(1, 1, 1, '08:00:00', '20:00:00', 'Monday'),
(2, 2, 2, '09:00:00', '21:00:00', 'Tuesday'),
(3, 3, 3, '10:00:00', '14:00:00', 'Wednesday'),
(4, 4, 4, '11:00:00', '13:00:00', 'Thursday'),
(5, 5, 5, '12:00:00', '23:59:00', 'Friday'),
(6, 6, 6, '13:00:00', '17:00:00', 'Saturday'),
(7, 7, 7, '14:00:00', '18:00:00', 'Sunday'),
(8, 8, 8, '15:00:00', '17:30:00', 'Monday'),
(9, 9, 9, '16:00:00', '19:00:00', 'Tuesday'),
(10, 10, 10, '17:00:00', '21:00:00', 'Wednesday'),
(11, 11, 11, '18:00:00', '20:00:00', 'Thursday'),
(12, 12, 12, '19:00:00', '22:30:00', 'Friday'),
(13, 13, 13, '20:00:00', '02:00:00', 'Saturday'),
1
2
(14, 14, 14, '21:00:00', '23:00:00', 'Sunday'),
(15, 15, 15, '22:00:00', '01:00:00', 'Monday'),
(16, 16, 16, '23:00:00', '01:30:00', 'Tuesday'),
(17, 17, 17, '00:00:00', '03:00:00', 'Wednesday'),
(18, 18, 18, '01:00:00', '05:00:00', 'Thursday'),
(19, 19, 19, '02:00:00', '04:30:00', 'Friday'),
(20, 20, 20, '03:00:00', '15:00:00', 'Saturday'),
(21, 21, 21, '04:00:00', '07:00:00', 'Sunday'),
(22, 22, 22, '05:00:00', '17:00:00', 'Monday'),
(23, 23, 23, '06:00:00', '08:30:00', 'Tuesday'),
(24, 24, 24, '07:00:00', '22:00:00', 'Wednesday'),
(25, 25, 25, '08:30:00', '23:00:00', 'Thursday'),
(26, 26, 26, '09:30:00', '12:00:00', 'Friday'),
(27, 27, 27, '10:30:00', '14:30:00', 'Saturday'),
(28, 28, 28, '11:30:00', '14:00:00', 'Sunday'),
(29, 29, 29, '12:30:00', '15:30:00', 'Monday'),
(30, 30, 30, '13:30:00', '15:00:00', 'Tuesday'),
(31, 31, 31, '14:30:00', '17:00:00', 'Wednesday'),
(32, 32, 32, '15:30:00', '18:00:00', 'Thursday'),
(33, 33, 33, '16:30:00', '19:00:00', 'Friday'),
(34, 34, 34, '17:30:00', '05:00:00', 'Saturday'),
(35, 35, 35, '18:30:00', '21:30:00', 'Sunday'),
(36, 36, 36, '19:30:00', '22:30:00', 'Monday'),
(37, 37, 37, '20:30:00', '23:30:00', 'Tuesday'),
(38, 38, 38, '21:30:00', '00:30:00', 'Wednesday'),
(39, 39, 39, '22:30:00', '06:30:00', 'Thursday'),
(40, 40, 40, '08:15:00', '11:15:00', 'Friday'),
(41, 41, 41, '09:15:00', '13:15:00', 'Saturday'),
(42, 42, 42, '10:15:00', '12:15:00', 'Sunday'),
(43, 43, 43, '11:15:00', '13:45:00', 'Monday'),
(44, 44, 44, '12:15:00', '15:15:00', 'Tuesday'),
(45, 45, 45, '13:15:00', '21:15:00', 'Wednesday'),
(46, 46, 46, '14:15:00', '17:15:00', 'Thursday'),
(47, 47, 47, '15:15:00', '18:15:00', 'Friday'),
(48, 48, 48, '16:15:00', '19:15:00', 'Saturday'),
(49, 49, 49, '17:15:00', '20:15:00', 'Sunday'),
(50, 50, 50, '18:15:00', '04:15:00', 'Monday'),
(51, 51, 51, '07:00:00', '23:00:00', 'Tuesday'),
(52, 52, 52, '08:00:00', '10:00:00', 'Wednesday'),
(53, 53, 53, '09:00:00', '11:00:00', 'Thursday'),
(54, 54, 54, '10:00:00', '12:00:00', 'Friday'),
(55, 55, 55, '11:00:00', '13:00:00', 'Saturday'),
(56, 56, 56, '12:00:00', '14:00:00', 'Sunday'),
(57, 57, 57, '13:00:00', '15:00:00', 'Monday'),
(58, 58, 58, '14:00:00', '16:00:00', 'Tuesday'),
(59, 59, 59, '15:00:00', '17:00:00', 'Wednesday'),
(60, 60, 60, '16:00:00', '18:00:00', 'Thursday'),
(61, 61, 61, '17:00:00', '19:00:00', 'Friday'),
1
3
(62, 62, 62, '18:00:00', '20:00:00', 'Saturday'),
(63, 63, 63, '19:00:00', '21:00:00', 'Sunday'),
(64, 64, 64, '20:00:00', '22:00:00', 'Monday'),
(65, 65, 65, '21:00:00', '23:00:00', 'Tuesday'),
(66, 66, 66, '22:00:00', '00:00:00', 'Wednesday'),
(67, 67, 67, '23:00:00', '01:00:00', 'Thursday'),
(68, 68, 68, '00:30:00', '02:30:00', 'Friday'),
(69, 69, 69, '01:30:00', '03:30:00', 'Saturday'),
(70, 70, 70, '02:30:00', '04:30:00', 'Sunday'),
(71, 71, 71, '03:30:00', '05:30:00', 'Monday'),
(72, 72, 72, '04:30:00', '06:30:00', 'Tuesday'),
(73, 73, 73, '05:30:00', '12:30:00', 'Wednesday'),
(74, 74, 74, '06:30:00', '14:30:00', 'Thursday'),
(75, 75, 75, '07:30:00', '15:30:00', 'Friday'),
(76, 76, 76, '08:45:00', '10:45:00', 'Saturday'),
(77, 77, 77, '09:45:00', '18:45:00', 'Sunday'),
(78, 78, 78, '10:45:00', '12:45:00', 'Monday'),
(79, 79, 79, '11:45:00', '20:45:00', 'Tuesday'),
(80, 80, 80, '12:45:00', '16:45:00', 'Wednesday'),
(81, 81, 81, '13:45:00', '22:45:00', 'Thursday'),
(82, 82, 82, '14:45:00', '16:45:00', 'Friday'),
(83, 83, 83, '15:45:00', '05:45:00', 'Saturday'),
(84, 84, 84, '16:45:00', '18:45:00', 'Sunday'),
(85, 85, 85, '17:45:00', '19:45:00', 'Monday'),
(86, 86, 86, '18:45:00', '20:45:00', 'Tuesday'),
(87, 87, 87, '19:45:00', '23:45:00', 'Wednesday'),
(88, 88, 88, '20:45:00', '22:45:00', 'Thursday'),
(89, 89, 89, '21:45:00', '23:45:00', 'Friday'),
(90, 90, 90, '22:45:00', '00:45:00', 'Saturday'),
(91, 91, 91, '06:00:00', '08:00:00', 'Sunday'),
(92, 92, 92, '07:00:00', '09:00:00', 'Monday'),
(93, 93, 93, '08:00:00', '10:00:00', 'Tuesday'),
(94, 94, 94, '09:00:00', '11:00:00', 'Wednesday'),
(95, 95, 95, '10:00:00', '19:00:00', 'Thursday'),
(96, 96, 96, '11:00:00', '13:00:00', 'Friday'),
(97, 97, 97, '12:00:00', '22:00:00', 'Saturday'),
(98, 98, 98, '13:00:00', '23:00:00', 'Sunday'),
(99, 99, 99, '14:00:00', '22:00:00', 'Monday'),
(100, 100, 100, '15:00:00', '17:00:00', 'Tuesday');

 Passenger Table:
INSERT INTO Passenger_Table (Pass_ID, Name, Contact, Gender, CNIC) VALUES
(1, 'Ahmed Khan', '0300-1111101', 'Male', '35201-1111111-1'),
(2, 'Sara Ali', '0300-1111102', 'Female', '35201-1111111-2'),
(3, 'Usman Sheikh', '0300-1111103', 'Male', '35201-1111111-3'),
1
4
(4, 'Zainab Bibi', '0300-1111104', 'Female', '35201-1111111-4'),
(5, 'Bilal Ahmed', '0300-1111105', 'Male', '35201-1111111-5'),
(6, 'Ayesha Malik', '0300-1111106', 'Female', '35201-1111111-6'),
(7, 'Hamza Jatt', '0300-1111107', 'Male', '35201-1111111-7'),
(8, 'Fatima Noor', '0300-1111108', 'Female', '35201-1111111-8'),
(9, 'Omer Farooq', '0300-1111109', 'Male', '35201-1111111-9'),
(10, 'Sana Javed', '0300-1111110', 'Female', '35201-1111111-0'),
(11, 'Rizwan Shah', '0301-2222111', 'Male', '42101-2222222-1'),
(12, 'Hina Pervez', '0301-2222112', 'Female', '42101-2222222-2'),
(13, 'Mustafa Riaz', '0301-2222113', 'Male', '42101-2222222-3'),
(14, 'Nida Khan', '0301-2222114', 'Female', '42101-2222222-4'),
(15, 'Ibrahim Lodhi', '0301-2222115', 'Male', '42101-2222222-5'),
(16, 'Maria B', '0301-2222116', 'Female', '42101-2222222-6'),
(17, 'Saif Ullah', '0301-2222117', 'Male', '42101-2222222-7'),
(18, 'Kiran Naz', '0301-2222118', 'Female', '42101-2222222-8'),
(19, 'Kamran Akmal', '0301-2222119', 'Male', '42101-2222222-9'),
(20, 'Sadia Imam', '0301-2222120', 'Female', '42101-2222222-0'),
(21, 'Tariq Aziz', '0321-3333221', 'Male', '61101-3333333-1'),
(22, 'Asma Jahangir', '0321-3333222', 'Female', '61101-3333333-2'),
(23, 'Fawad Khan', '0321-3333223', 'Male', '61101-3333333-3'),
(24, 'Bushra Ansari', '0321-3333224', 'Female', '61101-3333333-4'),
(25, 'Junaid Khan', '0321-3333225', 'Male', '61101-3333333-5'),
(26, 'Mahira Khan', '0321-3333226', 'Female', '61101-3333333-6'),
(27, 'Atif Aslam', '0321-3333227', 'Male', '61101-3333333-7'),
(28, 'Sajal Ali', '0321-3333228', 'Female', '61101-3333333-8'),
(29, 'Rahat Ali', '0321-3333229', 'Male', '61101-3333333-9'),
(30, 'Mehwish Hayat', '0321-3333230', 'Female', '61101-3333333-0'),
(31, 'Hassan Ali', '0333-4444331', 'Male', '33101-4444444-1'),
(32, 'Iqra Aziz', '0333-4444332', 'Female', '33101-4444444-2'),
(33, 'Babar Azam', '0333-4444333', 'Male', '33101-4444444-3'),
(34, 'Ayeza Khan', '0333-4444334', 'Female', '33101-4444444-4'),
(35, 'Shaheen Shah', '0333-4444335', 'Male', '33101-4444444-5'),
(36, 'Maya Ali', '0333-4444336', 'Female', '33101-4444444-6'),
(37, 'Naseem Shah', '0333-4444337', 'Male', '33101-4444444-7'),
(38, 'Saba Qamar', '0333-4444338', 'Female', '33101-4444444-8'),
(39, 'Shadab Khan', '0333-4444339', 'Male', '33101-4444444-9'),
(40, 'Yumna Zaidi', '0333-4444340', 'Female', '33101-4444444-0'),
-- Data pattern repeat for remaining to complete 100 entries
(41, 'Nasir Jamshed', '0345-5555441', 'Male', '17301-5555555-1'),
(42, 'Kubra Khan', '0345-5555442', 'Female', '17301-5555555-2'),
(43, 'Imad Wasim', '0345-5555443', 'Male', '17301-5555555-3'),
(44, 'Sanam Saeed', '0345-5555444', 'Female', '17301-5555555-4'),
(45, 'Wahab Riaz', '0345-5555445', 'Male', '17301-5555555-5'),
(46, 'Hania Aamir', '0345-5555446', 'Female', '17301-5555555-6'),
(47, 'Shoaib Malik', '0345-5555447', 'Male', '17301-5555555-7'),
(48, 'Urwa Hocane', '0345-5555448', 'Female', '17301-5555555-8'),
(49, 'Fakhar Zaman', '0345-5555449', 'Male', '17301-5555555-9'),
(50, 'Mawra Hocane', '0345-5555450', 'Female', '17301-5555555-0'),
1
5
(51, 'Asif Ali', '0312-6666551', 'Male', '54401-6666666-1'),
(52, 'Zarnish Khan', '0312-6666552', 'Female', '54401-6666666-2'),
(53, 'Haris Rauf', '0312-6666553', 'Male', '54401-6666666-3'),
(54, 'Syra Yousuf', '0312-6666554', 'Female', '54401-6666666-4'),
(55, 'Mohammad Rizwan', '0312-6666555', 'Male', '54401-6666666-5'),
(56, 'Alizeh Shah', '0312-6666556', 'Female', '54401-6666666-6'),
(57, 'Khushdil Shah', '0312-6666557', 'Male', '54401-6666666-7'),
(58, 'Minal Khan', '0312-6666558', 'Female', '54401-6666666-8'),
(59, 'Iftekhar Ahmed', '0312-6666559', 'Male', '54401-6666666-9'),
(60, 'Aiman Khan', '0312-6666560', 'Female', '54401-6666666-0'),
(61, 'Arshad Nadeem', '0300-7777661', 'Male', '38401-7777777-1'),
(62, 'Momina Mustehsan', '0300-7777662', 'Female', '38401-7777777-2'),
(63, 'Talha Anjum', '0300-7777663', 'Male', '38401-7777777-3'),
(64, 'Aima Baig', '0300-7777664', 'Female', '38401-7777777-4'),
(65, 'Talha Yunus', '0300-7777665', 'Male', '38401-7777777-5'),
(66, 'Farhan Saeed', '0300-7777666', 'Male', '38401-7777777-6'),
(67, 'Urwa Khan', '0300-7777667', 'Female', '38401-7777777-7'),
(68, 'Asim Azhar', '0300-7777668', 'Male', '38401-7777777-8'),
(69, 'Bilal Saeed', '0300-7777669', 'Male', '38401-7777777-9'),
(70, 'Ushna Shah', '0300-7777670', 'Female', '38401-7777777-0'),
(71, 'Saqlain Mushtaq', '0315-8888771', 'Male', '31201-8888888-1'),
(72, 'Hadiqa Kiani', '0315-8888772', 'Female', '31201-8888888-2'),
(73, 'Misbah ul Haq', '0315-8888773', 'Male', '31201-8888888-3'),
(74, 'Zeba Bakhtiar', '0315-8888774', 'Female', '31201-8888888-4'),
(75, 'Younis Khan', '0315-8888775', 'Male', '31201-8888888-5'),
(76, 'Reema Khan', '0315-8888776', 'Female', '31201-8888888-6'),
(77, 'Inzamam ul Haq', '0315-8888777', 'Male', '31201-8888888-7'),
(78, 'Resham', '0315-8888778', 'Female', '31201-8888888-8'),
(79, 'Saeed Anwar', '0315-8888779', 'Male', '31201-8888888-9'),
(80, 'Meera', '0315-8888780', 'Female', '31201-8888888-0'),
(81, 'Abdur Rehman', '0341-9999881', 'Male', '36301-9999999-1'),
(82, 'Noor Bukhari', '0341-9999882', 'Female', '36301-9999999-2'),
(83, 'Saeed Ajmal', '0341-9999883', 'Male', '36301-9999999-3'),
(84, 'Veena Malik', '0341-9999884', 'Female', '36301-9999999-4'),
(85, 'Abdul Razzaq', '0341-9999885', 'Male', '36301-9999999-5'),
(86, 'Irtiza Rubab', '0341-9999886', 'Female', '36301-9999999-6'),
(87, 'Shoaib Akhtar', '0341-9999887', 'Male', '36301-9999999-7'),
(88, 'Shaista Lodhi', '0341-9999888', 'Female', '36301-9999999-8'),
(89, 'Wasim Akram', '0341-9999889', 'Male', '36301-9999999-9'),
(90, 'Juggan Kazim', '0341-9999890', 'Female', '36301-9999999-0'),
(91, 'Junaid Jamshed', '0300-1010191', 'Male', '35202-1010101-1'),
(92, 'Nazia Hassan', '0300-1010192', 'Female', '35202-1010101-2'),
(93, 'Nusrat Fateh', '0300-1010193', 'Male', '35202-1010101-3'),
(94, 'Abida Parveen', '0300-1010194', 'Female', '35202-1010101-4'),
(95, 'Mehdi Hassan', '0300-1010195', 'Male', '35202-1010101-5'),
(96, 'Noor Jehan', '0300-1010196', 'Female', '35202-1010101-6'),
(97, 'Ghulam Ali', '0300-1010197', 'Male', '35202-1010101-7'),
(98, 'Iqbal Bano', '0300-1010198', 'Female', '35202-1010101-8'),
1
6
(99, 'Farida Khanum', '0300-1010199', 'Female', '35202-1010101-9'),
(100, 'Allan Faqir', '0300-1010200', 'Male', '35202-1010101-0');

 Staff Table:
INSERT INTO Staff_Table (Staff_ID, Name, Role, Email, Train_ID) VALUES
(1, 'Sajid Khan', 'Driver', 'sajid.k@[Link]', 1),
(2, 'Asif Mahmood', 'Conductor', 'asif.m@[Link]', 2),
(3, 'Zafar Iqbal', 'Guard', 'zafar.i@[Link]', 3),
(4, 'Nasir Abbas', 'Driver', 'nasir.a@[Link]', 4),
(5, 'Tariq Mehmood', 'Conductor', 'tariq.m@[Link]', 5),
(6, 'Bashir Ahmed', 'Sweeper', 'bashir.a@[Link]', 6),
(7, 'Irfan Ali', 'Driver', 'irfan.a@[Link]', 7),
(8, 'Kamran Shah', 'Conductor', 'kamran.s@[Link]', 8),
(9, 'Arshad Khan', 'Guard', 'arshad.k@[Link]', 9),
(10, 'Faisal Qureshi', 'Driver', 'faisal.q@[Link]', 10),
(11, 'Imtiaz Ahmed', 'Conductor', 'imtiaz.a@[Link]', 11),
(12, 'Zahid Hussain', 'Sweeper', 'zahid.h@[Link]', 12),
(13, 'Mazhar Ali', 'Driver', 'mazhar.a@[Link]', 13),
(14, 'Wajid Khan', 'Guard', 'wajid.k@[Link]', 14),
(15, 'Sohail Tanveer', 'Conductor', 'sohail.t@[Link]', 15),
(16, 'Adnan Sami', 'Driver', 'adnan.s@[Link]', 16),
(17, 'Jawad Ahmed', 'Sweeper', 'jawad.a@[Link]', 17),
(18, 'Nadeem Abbas', 'Guard', 'nadeem.a@[Link]', 18),
(19, 'Rashid Minhas', 'Driver', 'rashid.m@[Link]', 19),
(20, 'Shabbir Jan', 'Conductor', 'shabbir.j@[Link]', 20),
(21, 'Waqar Younis', 'Driver', 'waqar.y@[Link]', 21),
(22, 'Inam ul Haq', 'Conductor', 'inam.h@[Link]', 22),
(23, 'Mushtaq Ahmed', 'Guard', 'mushtaq.a@[Link]', 23),
(24, 'Saqlain Shah', 'Driver', 'saqlain.s@[Link]', 24),
(25, 'Azhar Ali', 'Conductor', 'azhar.a@[Link]', 25),
(26, 'Yousaf Khan', 'Sweeper', 'yousaf.k@[Link]', 26),
(27, 'Misbah Malik', 'Driver', 'misbah.m@[Link]', 27),
(28, 'Asad Shafiq', 'Conductor', 'asad.s@[Link]', 28),
(29, 'Umar Akmal', 'Guard', 'umar.a@[Link]', 29),
(30, 'Sarfaraz Ahmed', 'Driver', 'sarfaraz.a@[Link]', 30),
(31, 'Babar Zaman', 'Driver', 'babar.z@[Link]', 31),
(32, 'Shaheen Afridi', 'Conductor', 'shaheen.a@[Link]', 32),
(33, 'Haris Sohail', 'Guard', 'haris.s@[Link]', 33),
(34, 'Shadab Khan', 'Driver', 'shadab.k@[Link]', 34),
(35, 'Imad Wasim', 'Conductor', 'imad.w@[Link]', 35),
(36, 'Hassan Ali', 'Sweeper', 'hassan.a@[Link]', 36),
(37, 'Fakhar Zaman', 'Driver', 'fakhar.z@[Link]', 37),
(38, 'Mohammad Hafeez', 'Conductor', '[Link]@[Link]', 38),
(39, 'Shoaib Malik', 'Guard', 'shoaib.m@[Link]', 39),
(40, 'Wahab Riaz', 'Driver', 'wahab.r@[Link]', 40),
(41, 'Naseem Shah', 'Conductor', 'naseem.s@[Link]', 41),
1
7
(42, 'Abid Ali', 'Sweeper', 'abid.a@[Link]', 42),
(43, 'Shan Masood', 'Driver', 'shan.m@[Link]', 43),
(44, 'Iftikhar Ahmed', 'Guard', 'iftikhar.a@[Link]', 44),
(45, 'Khushdil Shah', 'Conductor', 'khushdil.s@[Link]', 45),
(46, 'Mohammad Nawaz', 'Driver', '[Link]@[Link]', 46),
(47, 'Usman Qadir', 'Sweeper', 'usman.q@[Link]', 47),
(48, 'Haris Rauf', 'Guard', 'haris.r@[Link]', 48),
(49, 'Mohammad Hasnain', 'Driver', '[Link]@[Link]', 49),
(50, 'Musa Khan', 'Conductor', 'musa.k@[Link]', 50),
(51, 'Asif Ali', 'Driver', '[Link]@[Link]', 51),
(52, 'Haider Ali', 'Conductor', 'haider.a@[Link]', 52),
(53, 'Azam Khan', 'Guard', 'azam.k@[Link]', 53),
(54, 'Saim Ayub', 'Driver', 'saim.a@[Link]', 54),
(55, 'Tayyab Tahir', 'Conductor', 'tayyab.t@[Link]', 55),
(56, 'Ihsaanullah Khan', 'Sweeper', 'ihsaan.k@[Link]', 56),
(57, 'Zaman Khan', 'Driver', 'zaman.k@[Link]', 57),
(58, 'Abdullah Shafique', 'Guard', 'abdullah.s@[Link]', 58),
(59, 'Abrar Ahmed', 'Conductor', 'abrar.a@[Link]', 59),
(60, 'Kamran Ghulam', 'Driver', 'kamran.g@[Link]', 60),
(61, 'Qasim Akram', 'Conductor', 'qasim.a@[Link]', 61),
(62, 'Haseebullah Khan', 'Sweeper', 'haseeb.k@[Link]', 62),
(63, 'Mohammad Haris', 'Driver', '[Link]@[Link]', 63),
(64, 'Arshad Iqbal', 'Guard', 'arshad.i@[Link]', 64),
(65, 'Danish Aziz', 'Conductor', 'danish.a@[Link]', 65),
(66, 'Zahid Mahmood', 'Driver', 'zahid.m@[Link]', 66),
(67, 'Sajid Khan', 'Sweeper', 'sajid.k2@[Link]', 67),
(68, 'Nauman Ali', 'Guard', 'nauman.a@[Link]', 68),
(69, 'Faheem Ashraf', 'Driver', 'faheem.a@[Link]', 69),
(70, 'Usama Mir', 'Conductor', 'usama.m@[Link]', 70),
(71, 'Salman Ali Agha', 'Driver', 'salman.a@[Link]', 71),
(72, 'Saud Shakeel', 'Conductor', 'saud.s@[Link]', 72),
(73, 'Mir Hamza', 'Guard', 'mir.h@[Link]', 73),
(74, 'Mohammad Abbas', 'Driver', '[Link]@[Link]', 74),
(75, 'Bilal Asif', 'Conductor', 'bilal.a@[Link]', 75),
(76, 'Sadaf Hussain', 'Sweeper', 'sadaf.h@[Link]', 76),
(77, 'Tabish Khan', 'Driver', 'tabish.k@[Link]', 77),
(78, 'Zulfiqar Babar', 'Guard', 'zulfiqar.b@[Link]', 78),
(79, 'Sohaib Maqsood', 'Conductor', 'sohaib.m@[Link]', 79),
(80, 'Sharjeel Khan', 'Driver', 'sharjeel.k@[Link]', 80),
(81, 'Khalid Latif', 'Conductor', 'khalid.l@[Link]', 81),
(82, 'Sami Aslam', 'Sweeper', 'sami.a@[Link]', 82),
(83, 'Imran Khan Sr', 'Driver', 'imran.k@[Link]', 83),
(84, 'Sohail Khan', 'Guard', 'sohail.k@[Link]', 84),
(85, 'Rahat Ali', 'Conductor', 'rahat.a@[Link]', 85),
(86, 'Ehsan Adil', 'Driver', 'ehsan.a@[Link]', 86),
(87, 'Aizaz Cheema', 'Sweeper', 'aizaz.c@[Link]', 87),
(88, 'Mohammad Irfan', 'Guard', '[Link]@[Link]', 88),
(89, 'Anwar Ali', 'Driver', 'anwar.a@[Link]', 89),
1
8
(90, 'Bilawal Bhatti', 'Conductor', 'bilawal.b@[Link]', 90),
(91, 'Umar Amin', 'Driver', 'umar.a2@[Link]', 91),
(92, 'Zohaib Khan', 'Conductor', 'zohaib.k@[Link]', 92),
(93, 'Khurram Manzoor', 'Guard', 'khurram.m@[Link]', 93),
(94, 'Fawad Alam', 'Driver', 'fawad.a@[Link]', 94),
(95, 'Abdur Rehman', 'Conductor', 'abdur.r@[Link]', 95),
(96, 'Saeed Ajmal', 'Sweeper', 'saeed.a@[Link]', 96),
(97, 'Tanvir Ahmed', 'Driver', 'tanvir.a@[Link]', 97),
(98, 'Mohammad Talha', 'Guard', '[Link]@[Link]', 98),
(99, 'Raza Hasan', 'Conductor', 'raza.h@[Link]', 99),
(100, 'Hammid Hassan', 'Driver', 'hammid.h@[Link]', 100);

 Seat Table:
INSERT INTO Seat_Table (Seat_ID, Coach_ID, Seat_No, Class, Window_side) VALUES
(1, 1, 1, 'AC Sleeper', 'Yes'), (2, 1, 2, 'AC Sleeper', 'No'), (3, 1, 3, 'AC Sleeper', 'Yes'),
(4, 2, 1, 'AC Parlor', 'Yes'), (5, 2, 2, 'AC Parlor', 'No'), (6, 2, 3, 'AC Parlor', 'No'),
(7, 3, 1, 'AC Business', 'Yes'), (8, 3, 2, 'AC Business', 'No'), (9, 3, 3, 'AC Business', 'Yes'),
(10, 4, 1, 'AC Standard', 'No'), (11, 4, 2, 'AC Standard', 'Yes'), (12, 4, 3, 'AC Standard', 'No'),
(13, 5, 1, 'Economy', 'Yes'), (14, 5, 2, 'Economy', 'No'), (15, 5, 3, 'Economy', 'Yes'),
(16, 6, 1, 'First Class', 'Yes'), (17, 6, 2, 'First Class', 'No'), (18, 6, 3, 'First Class', 'No'),
(19, 7, 1, 'Executive', 'Yes'), (20, 7, 2, 'Executive', 'Yes'), (21, 8, 1, 'Economy', 'No'),
(22, 9, 1, 'AC Business', 'Yes'), (23, 10, 1, 'Economy', 'No'), (24, 11, 1, 'AC Sleeper', 'Yes'),
(25, 12, 1, 'Economy', 'No'), (26, 13, 1, 'AC Standard', 'Yes'), (27, 14, 1, 'Economy', 'Yes'),
(28, 15, 1, 'Economy', 'No'), (29, 16, 1, 'First Class', 'Yes'), (30, 17, 1, 'Executive', 'No'),
(31, 18, 1, 'Economy', 'Yes'), (32, 19, 1, 'AC Business', 'No'), (33, 20, 1, 'Economy', 'Yes'),
(34, 21, 1, 'AC Sleeper', 'No'), (35, 22, 1, 'Economy', 'Yes'), (36, 23, 1, 'AC Standard', 'No'),
(37, 24, 1, 'Economy', 'Yes'), (38, 25, 1, 'Economy', 'No'), (39, 26, 1, 'First Class', 'Yes'),
(40, 27, 1, 'Executive', 'No'), (41, 28, 1, 'Economy', 'Yes'), (42, 29, 1, 'AC Business', 'No'),
(43, 30, 1, 'Economy', 'Yes'), (44, 31, 1, 'AC Sleeper', 'No'), (45, 32, 1, 'Economy', 'Yes'),
(46, 33, 1, 'AC Standard', 'No'), (47, 34, 1, 'Economy', 'Yes'), (48, 35, 1, 'Economy', 'No'),
(49, 36, 1, 'First Class', 'Yes'), (50, 37, 1, 'Executive', 'No'), (51, 38, 1, 'Economy', 'Yes'),
(52, 39, 1, 'AC Business', 'No'), (53, 40, 1, 'Economy', 'Yes'), (54, 41, 1, 'AC Sleeper', 'No'),
(55, 42, 1, 'Economy', 'Yes'), (56, 43, 1, 'AC Standard', 'No'), (57, 44, 1, 'Economy', 'Yes'),
(58, 45, 1, 'Economy', 'No'), (59, 46, 1, 'First Class', 'Yes'), (60, 47, 1, 'Executive', 'No'),
(61, 48, 1, 'Economy', 'Yes'), (62, 49, 1, 'AC Business', 'No'), (63, 50, 1, 'Economy', 'Yes'),
(64, 51, 1, 'AC Sleeper', 'No'), (65, 52, 1, 'Economy', 'Yes'), (66, 53, 1, 'AC Standard', 'No'),
(67, 54, 1, 'Economy', 'Yes'), (68, 55, 1, 'Economy', 'No'), (69, 56, 1, 'First Class', 'Yes'),
(70, 57, 1, 'Executive', 'No'), (71, 58, 1, 'Economy', 'Yes'), (72, 59, 1, 'AC Business', 'No'),
(73, 60, 1, 'Economy', 'Yes'), (74, 61, 1, 'AC Sleeper', 'No'), (75, 62, 1, 'Economy', 'Yes'),
(76, 63, 1, 'AC Standard', 'No'), (77, 64, 1, 'Economy', 'Yes'), (78, 65, 1, 'Economy', 'No'),
(79, 66, 1, 'First Class', 'Yes'), (80, 67, 1, 'Executive', 'No'), (81, 68, 1, 'Economy', 'Yes'),
(82, 69, 1, 'AC Business', 'No'), (83, 70, 1, 'Economy', 'Yes'), (84, 71, 1, 'AC Sleeper', 'No'),
(85, 72, 1, 'Economy', 'Yes'), (86, 73, 1, 'AC Standard', 'No'), (87, 74, 1, 'Economy', 'Yes'),
(88, 75, 1, 'Economy', 'No'), (89, 76, 1, 'First Class', 'Yes'), (90, 77, 1, 'Executive', 'No'),
(91, 78, 1, 'Economy', 'Yes'), (92, 79, 1, 'AC Business', 'No'), (93, 80, 1, 'Economy', 'Yes'),
1
9
(94, 81, 1, 'AC Sleeper', 'No'), (95, 82, 1, 'Economy', 'Yes'), (96, 83, 1, 'AC Standard', 'No'),
(97, 84, 1, 'Economy', 'Yes'), (98, 85, 1, 'Economy', 'No'), (99, 86, 1, 'First Class', 'Yes'),
(100, 87, 1, 'Executive', 'No');

 Ticket Table:
INSERT INTO Ticket_Table (Ticket_ID, Pass_ID, Schedule_ID, Seat_ID, Booking_date) VALUES
(1, 1, 1, 1, ‘2026-01-01’), (2, 2, 2, 2, ‘2026-01-01’), (3, 3, 3, 3, ‘2026-01-01’),
(4, 4, 4, 4, ‘2026-01-02’), (5, 5, 5, 5, ‘2026-01-02’), (6, 6, 6, 6, ‘2026-01-02’),
(7, 7, 7, 7, ‘2026-01-03’), (8, 8, 8, 8, ‘2026-01-03’), (9, 9, 9, 9, ‘2026-01-03’),
(10, 10, 10, 10, ‘2026-01-04’), (11, 11, 11, 11, ‘2026-01-04’), (12, 12, 12, 12, ‘2026-01-04’),
(13, 13, 13, 13, ‘2026-01-05’), (14, 14, 14, 14, ‘2026-01-05’), (15, 15, 15, 15, ‘2026-01-05’),
(16, 16, 16, 16, ‘2026-01-06’), (17, 17, 17, 17, ‘2026-01-06’), (18, 18, 18, 18, ‘2026-01-06’),
(19, 19, 19, 19, ‘2026-01-07’), (20, 20, 20, 20, ‘2026-01-07’), (21, 21, 21, 21, ‘2026-01-07’),
(22, 22, 22, 22, ‘2026-01-08’), (23, 23, 23, 23, ‘2026-01-08’), (24, 24, 24, 24, ‘2026-01-08’),
(25, 25, 25, 25, ‘2026-01-09’), (26, 26, 26, 26, ‘2026-01-09’), (27, 27, 27, 27, ‘2026-01-09’),
(28, 28, 28, 28, ‘2026-01-10’), (29, 29, 29, 29, ‘2026-01-10’), (30, 30, 30, 30, ‘2026-01-10’),
(31, 31, 31, 31, ‘2026-01-11’), (32, 32, 32, 32, ‘2026-01-11’), (33, 33, 33, 33, ‘2026-01-11’),
(34, 34, 34, 34, ‘2026-01-12’), (35, 35, 35, 35, ‘2026-01-12’), (36, 36, 36, 36, ‘2026-01-12’),
(37, 37, 37, 37, ‘2026-01-13’), (38, 38, 38, 38, ‘2026-01-13’), (39, 39, 39, 39, ‘2026-01-13’),
(40, 40, 40, 40, ‘2026-01-14’), (41, 41, 41, 41, ‘2026-01-14’), (42, 42, 42, 42, ‘2026-01-14’),
(43, 43, 43, 43, ‘2026-01-15’), (44, 44, 44, 44, ‘2026-01-15’), (45, 45, 45, 45, ‘2026-01-15’),
(46, 46, 46, 46, ‘2026-01-16’), (47, 47, 47, 47, ‘2026-01-16’), (48, 48, 48, 48, ‘2026-01-16’),
(49, 49, 49, 49, ‘2026-01-17’), (50, 50, 50, 50, ‘2026-01-17’), (51, 51, 51, 51, ‘2026-01-17’),
(52, 52, 52, 52, ‘2026-01-18’), (53, 53, 53, 53, ‘2026-01-18’), (54, 54, 54, 54, ‘2026-01-18’),
(55, 55, 55, 55, ‘2026-01-19’), (56, 56, 56, 56, ‘2026-01-19’), (57, 57, 57, 57, ‘2026-01-19’),
(58, 58, 58, 58, ‘2026-01-20’), (59, 59, 59, 59, ‘2026-01-20’), (60, 60, 60, 60, ‘2026-01-20’),
(61, 61, 61, 61, ‘2026-01-21’), (62, 62, 62, 62, ‘2026-01-21’), (63, 63, 63, 63, ‘2026-01-21’),
(64, 64, 64, 64, ‘2026-01-22’), (65, 65, 65, 65, ‘2026-01-22’), (66, 66, 66, 66, ‘2026-01-22’),
(67, 67, 67, 67, ‘2026-01-23’), (68, 68, 68, 68, ‘2026-01-23’), (69, 69, 69, 69, ‘2026-01-23’),
(70, 70, 70, 70, ‘2026-01-24’), (71, 71, 71, 71, ‘2026-01-24’), (72, 72, 72, 72, ‘2026-01-24’),
(73, 73, 73, 73, ‘2026-01-25’), (74, 74, 74, 74, ‘2026-01-25’), (75, 75, 75, 75, ‘2026-01-25’),
(76, 76, 76, 76, ‘2026-01-26’), (77, 77, 77, 77, ‘2026-01-26’), (78, 78, 78, 78, ‘2026-01-26’),
(79, 79, 79, 79, ‘2026-01-27’), (80, 80, 80, 80, ‘2026-01-27’), (81, 81, 81, 81, ‘2026-01-27’),
(82, 82, 82, 82, ‘2026-01-28’), (83, 83, 83, 83, ‘2026-01-28’), (84, 84, 84, 84, ‘2026-01-28’),
(85, 85, 85, 85, ‘2026-01-29’), (86, 86, 86, 86, ‘2026-01-29’), (87, 87, 87, 87, ‘2026-01-29’),
(88, 88, 88, 88, ‘2026-01-30’), (89, 89, 89, 89, ‘2026-01-30’), (90, 90, 90, 90, ‘2026-01-30’),
(91, 91, 91, 91, ‘2026-01-31’), (92, 92, 92, 92, ‘2026-01-31’), (93, 93, 93, 93, ‘2026-01-31’),
(94, 94, 94, 94, ‘2026-01-01’), (95, 95, 95, 95, ‘2026-01-02’), (96, 96, 96, 96, ‘2026-01-03’),
(97, 97, 97, 97, ‘2026-01-04’), (98, 98, 98, 98, ‘2026-01-05’), (99, 99, 99, 99, ‘2026-01-06’),
(100, 100, 100, 100, ‘2026-01-07’);

2
0