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 number(11) BUS NO BUS_NAME varchar2(20) t TYPE SCHEDULE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20)t number(11) number(11) SCHEDULE ID varchar2(20) t TOTAL_SEATS number(11) # AVAIL_SEATS number(11) # TRAVEL DATE SOURCE BUS NO O BUS_NO DURATION PAYMENTS DISCOUNTS PAYMENT_ID varchar2(3) t DISCOUNT_ID varchar2(3) TICKET ID TICKET ID P BD_ID O DISCOUNT_ID varchar2(3), varchar2(3) number(11) DISCOUNT_AMOUNT number(11) DISCOUNT_ID TICKETS TICKET ID yarchar2(3) SCHEDULE_ID O SCHEDULE ID varchar2(3) number(11) # number(11) number(11) # FARE USER ID p USER_ID USERS NO SEATS 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 d| data type - date It| data type - varchar2 USER ID NAME PHNO CANCELLATION CANCELLATION_ID varchar2(3)t varchar2(3) number(11) O TICKET ID BOOKINGDETAILS OTICKET 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