Develop SQL Query Display schedule jd. source, destination and travel time which has minimum travel time. Sort the result based on schedule id BUSES PBUS NO number(11) BUS NAME varchar2 SOEDULE PSOEDULE D varchar TRAVEL DATE SOURCE DESTINATION varchar PBUS NO TYPE varchar2 datea varchar20t TOTAL SEATS nunbe( AVA SEATS nunber(an) nunber(11)e DURATION BANENTS DESCOUNTS PAIMENT D vardhar2 PTIOET D varchar23 PDISCOUNT D DESCOUNT AMOUNT nunber(11) nunber cescOUNT TIOETS PDESCOUNT_D varchar23) varcha2 euE TIOET D PSOEDULE D varchar2 FARE PUSER D NO SEATS nuber11)SERD number1)o- unber(1) USERS PUSER D unber1 varchar220) ACORESSvarchar2100) nunber(11) EMAILD vardhar20) primary hey-aot aull NAME p fomip key dta type - anber deta type- date PHNO k deta type- vacha CANCELLATION ICET D. CANCELLATIOND varchar BOOKINGDETALS varchar2 unber D 0 D nunber ACC NO nunber() NAME varchar210) PUSER Dnunber B0 D
Develop SQL Query Display schedule jd. source, destination and travel time which has minimum travel time. Sort the result based on schedule id BUSES PBUS NO number(11) BUS NAME varchar2 SOEDULE PSOEDULE D varchar TRAVEL DATE SOURCE DESTINATION varchar PBUS NO TYPE varchar2 datea varchar20t TOTAL SEATS nunbe( AVA SEATS nunber(an) nunber(11)e DURATION BANENTS DESCOUNTS PAIMENT D vardhar2 PTIOET D varchar23 PDISCOUNT D DESCOUNT AMOUNT nunber(11) nunber cescOUNT TIOETS PDESCOUNT_D varchar23) varcha2 euE TIOET D PSOEDULE D varchar2 FARE PUSER D NO SEATS nuber11)SERD number1)o- unber(1) USERS PUSER D unber1 varchar220) ACORESSvarchar2100) nunber(11) EMAILD vardhar20) primary hey-aot aull NAME p fomip key dta type - anber deta type- date PHNO k deta type- vacha CANCELLATION ICET D. CANCELLATIOND varchar BOOKINGDETALS varchar2 unber D 0 D nunber ACC NO nunber() NAME varchar210) PUSER Dnunber B0 D
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
![Develop SQL Query
Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id
BUSES
BUS NO
number(11)
SOEDULE
PSOEDULE ID varchara(3
TRAVEL DATE
SOURCE
DESTINATION varchar2(20) e
P BUS NO
BUS NAME varchara200
varchara(20)
TOTAL SEATS nunber(11)
AVA SEATS number(a1)
TYPE
dated
varchar2(20)t
nunber1) NO
number(11)
DURATION
BAYMENTS
DISCOUNTS
PAYMENT_ID varchar23)
varchar23
number(11)cescOUNT D
PDISCOUNT ID
varchar23
DISCOUNT AMOUNT nunber(11)
TIOET ID
ETIOKET ID
TICKETS
DISCOUNT ID varchar2(3)o
PTIOET ID
varcha23) DLE D
PSOEDULE ID varchar2(3)
number(11)
number(11)o
nunber(11)
FARE
USER ID
OUSER JD
NO SEATS
USERS
PUSER ID nunber(11)
varchar2(20)t
ADDRESS varchar2(100)t
number(11)
EMAILID varchar2(30)t
primary hey - not wall
NAME
p fomign key
duta type - wuvber
a data type date
PHNO
It data type - vachar?
CANCELLATION
CANCELLATION_ID varchar23)
TIOET ID
PBD ID
TICKET ID
BOOKINGDETAILS
varchar23)
nunber(11) ID
B0_ID nunber(11)
ACC_NO number(11
NAME varchar2(10) e
PUSER ID nunber(11)
ERID](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F94248a44-e3e9-49c3-96e9-f427a2e72529%2Fecec6b92-2968-4429-91a6-8aa8b5f9d520%2Fvmwwkmj_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Develop SQL Query
Display schedule_id, source, destination and travel_time which has minimum travel time. Sort the result based on schedule id
BUSES
BUS NO
number(11)
SOEDULE
PSOEDULE ID varchara(3
TRAVEL DATE
SOURCE
DESTINATION varchar2(20) e
P BUS NO
BUS NAME varchara200
varchara(20)
TOTAL SEATS nunber(11)
AVA SEATS number(a1)
TYPE
dated
varchar2(20)t
nunber1) NO
number(11)
DURATION
BAYMENTS
DISCOUNTS
PAYMENT_ID varchar23)
varchar23
number(11)cescOUNT D
PDISCOUNT ID
varchar23
DISCOUNT AMOUNT nunber(11)
TIOET ID
ETIOKET ID
TICKETS
DISCOUNT ID varchar2(3)o
PTIOET ID
varcha23) DLE D
PSOEDULE ID varchar2(3)
number(11)
number(11)o
nunber(11)
FARE
USER ID
OUSER JD
NO SEATS
USERS
PUSER ID nunber(11)
varchar2(20)t
ADDRESS varchar2(100)t
number(11)
EMAILID varchar2(30)t
primary hey - not wall
NAME
p fomign key
duta type - wuvber
a data type date
PHNO
It data type - vachar?
CANCELLATION
CANCELLATION_ID varchar23)
TIOET ID
PBD ID
TICKET ID
BOOKINGDETAILS
varchar23)
nunber(11) ID
B0_ID nunber(11)
ACC_NO number(11
NAME varchar2(10) e
PUSER ID nunber(11)
ERID
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY