DBS-14.5: BUSES number(11) BUS NO BUS_NAME varchar2(20) t TYPE SCHEDULE varchar2(20)t varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) number(11) SCHEDULE_ID TRAVEL DATE SOURCE...


DBS-14.5:<br>BUSES<br>number(11)<br>BUS NO<br>BUS_NAME varchar2(20) t<br>TYPE<br>SCHEDULE<br>varchar2(20)t<br>varchar2(3)<br>date d<br>varchar2(20) t<br>DESTINATION varchar2(20) t<br>number(11)<br>number(11)<br>SCHEDULE_ID<br>TRAVEL DATE<br>SOURCE<br>TOTAL_SEATS number(11)<br>AVAIL_SEATS number(11)<br>BUS NO<br>O BUS_NO<br>DURATION<br>PAYMENTS<br>DISCOUNTS<br>PAYMENT_ID varchar2(3)t<br>P TICKET ID<br>varchar2(3)<br>DISCOUNT_ID<br>TICKET ID<br>varchar2(3)<br>number(11)<br>O DISCOUNT_ID varchar2(3)<br>DISCOUNT_AMOUNT number(11)<br>O BD_ID<br>TICKETS<br>DISCOUNT ID<br>varchar2(3)<br>OSCHEDULE ID varchar2(3)<br>number(11)<br>number(11)O<br>number(11)<br>TICKET ID<br>HEDULE ID<br>FARE<br>USER ID<br>OUSER ID<br>NO SEATS<br>USERS<br>PUSER ID number(11)<br>varchar2(20) e<br>ADDRESS varchar2(100) t<br>number(11)<br>EMAILID varchar2(30) e<br>P primary key - not null<br>e formign key<br>NAME<br>PHNO<br># data type - zurber<br>a| data type - date<br>It| data type - varchar2<br>CANCELLATION<br>CANCELLATION_ID varchar2(3)<br>varchar2(3)<br>number(11)o<br>TICKET ID<br>BOOKINGDETAILS<br>TICKET ID<br>O BD ID<br>ED ID<br>BD ID number(11)<br>ACC_NO number(11)<br>NAME varchar2(10)t<br>PUSER ID number(11)<br>USER_ID<br>Cosider the above given relational database model of Ticket Booking Application to develop<br>an SQL query to print schedule_id, source, destination and travel_time which having the<br>maximum travel time and sort it in the order of schedule id.<br>

Extracted text: DBS-14.5: BUSES number(11) BUS NO BUS_NAME varchar2(20) t TYPE SCHEDULE varchar2(20)t varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) number(11) SCHEDULE_ID TRAVEL DATE SOURCE TOTAL_SEATS number(11) AVAIL_SEATS number(11) BUS NO O BUS_NO DURATION PAYMENTS DISCOUNTS PAYMENT_ID varchar2(3)t P TICKET ID varchar2(3) DISCOUNT_ID TICKET ID varchar2(3) number(11) O DISCOUNT_ID varchar2(3) DISCOUNT_AMOUNT number(11) O BD_ID TICKETS DISCOUNT ID varchar2(3) OSCHEDULE ID varchar2(3) number(11) number(11)O number(11) TICKET ID HEDULE ID FARE USER ID OUSER ID NO SEATS USERS PUSER ID number(11) varchar2(20) e ADDRESS varchar2(100) t number(11) EMAILID varchar2(30) e P primary key - not null e formign key NAME PHNO # data type - zurber a| data type - date It| data type - varchar2 CANCELLATION CANCELLATION_ID varchar2(3) varchar2(3) number(11)o TICKET ID BOOKINGDETAILS TICKET ID O BD ID ED ID BD ID number(11) ACC_NO number(11) NAME varchar2(10)t PUSER ID number(11) USER_ID Cosider the above given relational database model of Ticket Booking Application to develop an SQL query to print schedule_id, source, destination and travel_time which having the maximum travel time and sort it in the order of schedule id.

Jun 04, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?