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


DBS-14.5:<br>BUSES<br>BUS NO<br>BUS NAME varchar2(20) t<br>TYPE<br>number(11)<br>SCHEDULE<br>varchar2(3)<br>date d<br>varchar2(20) t<br>DESTINATION varchar2(20) t<br>number(11)<br>number(11)<br>varchar2(20) t<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>O 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>DISCOUNT ID<br>TICKETS<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>USER_ID number(11)<br>varchar2(20) e<br>ADDRESS varchar2(100) t<br>number(11)<br>EMAILID varchar2(30)t<br>2 primary key - not null<br>e formign key<br>#| data type - zuriber<br>a| data type - date<br>NAME<br>PHVO<br>CANCELLATION<br>It| data type - varchar2<br>CANCELLATION_ID varchar2(3)<br>varchar2(3)<br>number(11)O<br>TICKET ID<br>BOOKINGDETAILS<br>TICKET ID<br>BD ID<br>BD ID number(11)<br>ACC_NO number(11)<br>NAME varchar2(10)t<br>PUSER ID number(11)<br>araed<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 BUS NO BUS NAME varchar2(20) t TYPE number(11) SCHEDULE varchar2(3) date d varchar2(20) t DESTINATION varchar2(20) t number(11) number(11) varchar2(20) t 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 O TICKET_ID varchar2(3) DISCOUNT_ID TICKET ID varchar2(3) number(11) O DISCOUNT_ID varchar2(3) DISCOUNT_AMOUNT number(11) O BD_ID DISCOUNT ID TICKETS 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 USER_ID number(11) varchar2(20) e ADDRESS varchar2(100) t number(11) EMAILID varchar2(30)t 2 primary key - not null e formign key #| data type - zuriber a| data type - date NAME PHVO CANCELLATION It| data type - varchar2 CANCELLATION_ID varchar2(3) varchar2(3) number(11)O TICKET ID BOOKINGDETAILS TICKET ID BD ID BD ID number(11) ACC_NO number(11) NAME varchar2(10)t PUSER ID number(11) araed 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 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here