DBS-14.6: Cosider the below given relational database model of Ticket Booking Application to develop an SQL query to display list of bus number and names where source and destination of a bus is the...

Extracted text: DBS-14.6: Cosider the below given relational database model of Ticket Booking Application to develop an SQL query to display list of bus number and names where source and destination of a bus is the destination and source of another bus. Display unique records in ascending order by bus_no. BUSES BUS NO BUS_NAME varchar2(20) t TYPE TOTAL_SEATS number(11) number(11) SCHEDULE varchar2(20) t varchar2(3) date d varchar2(20) t DESTINATION Vvarchar2(20) t number(11) number(11) # SCHEDULE ID TRAVEL DATE SOURCE AVAIL_SEATS number(11) # BUS NO BUS NO DURATION PAYMENTS DISCOUNTS PAYMENT_ID varchar2(3) t DISCOUNT_ID varchar2(3) TICKET ID BD ID TICKET ID O BD_ID O DISCOUNT_ID varchar2(3), varchar2(3) number(11) DISCOUNT_AMOUNT number(11) DISCOUNT_ID TICKETS TICKET ID varchar2(3) SCHEDULE ID O SCHEDULE ID varchar2(3) FARE p USER_ID NO_SEATS number(11) # number(11) number(11) # USER ID USERS number(11) varchar2(20) t ADDRESS varchar2(100) t number(11) # EMAILID varchar2(30) t P primary key - not null e foreign key #1 data type - number a| data type - date t| data type - varchar2 USER ID NAME PHNO CANCELLATION CANCELLATION_ID varchar2(3)t varchar2(3) number(11) O TICKET ID BOOKINGDETAILS PTICKET ID O BD ID BD ID BD_ID number(11) ACC_NO number(11) NAME varchar2(10) t O USER ID number(11) USER ID