create table bus_detail(B_NO int PRIMARY KEY NOT NULL,B_NAME varchar(15) NOT NULL,ORIGIN varchar(20),DEST varchar(20),DEPT_DATE date,DEPT_TIME varchar(10),ARR_TIME varchar(10),DUR varchar(10),FARE varchar(6));

create table pass_info(P_NO int PRIMARY KEY NOT NULL,P_NAME varchar(20) NOT NULL,GENDER char(1),DOB date,AGE int,PHONE_NO int NOT NULL,EMAIL_ID varchar(30),CITY varchar(20),STATE varchar(20));

create table res_details(BOOKING_ID int PRIMARY KEY NOT NULL,B_NO int references bus_details(B_NO),P_NO int references pass_info(P_NO),RES_DATE date,STATUS varchar(10));

insert into pass_info values(1,'Parneet Saini','F','10/05/1999',19,5412369874,'parneetsaini@gmail.com','Mohali','Punjab');
insert into pass_info values(2,'Praduman Sharma','M','11/03/1989',30,8547965412,'pradumansharma@gmail.com','Shimla','Himachal Pradesh');
insert into pass_info values(3,'Muskan Bansal','F','09/18/1990',29,9878546581,'bansalmuskan@gmail.com','Ambala','Haryana');
insert into pass_info values(4,'Nishant Siddhu','M','08/27/1997',21,7854123658,'nishantsiddhu@gmail.com','Panipat','Haryana');
insert into pass_info values(5,'Nitin Malik','M','01/09/1985',34,9854751216,'nitinmalik@gmail.com','Patiala','Punjab');
alter table bus_details modify B_NAME varchar(30);
insert into bus_details values(2456,'Haryana Roadways','Delhi','Panipat','02/05/2019','12:10hrs','16:30hrs','04:20hrs','Rs80');
insert into bus_details values(5465,'Haryana Roadways','Karnal','Delhi','02/15/2019','11:30hrs','16:30hrs','05:00rs','Rs120');
insert into bus_details values(5468,'Haryana Roadways','Kurukshetra','Chandigarh','02/08/2019','09:30hrs','13:50hrs','04:20hrs','Rs90');
select * from bus_details
select * from pass_info
select * from res_details
insert into res_details values(785422,2456,2,'01/28/2019','Confirmed');
insert into res_details values(872144,5468,4,'01/15/2019','Cancelled');