Based on the diagram. 30.Display the name of the passengers whose tickets include only one flight.

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...
icon
Related questions
Question

Based on the diagram.

30.Display the name of the passengers whose tickets include only one flight.

Relationships X
RESERVATION
RES CONFIRM_NO
RES_DATE
RES_FNAME
RES_LNAME
RES_PHONE
RES_FLIGHT_NO
RES_FLIGHT DATE
AIRPORT TABLE
air_code
air_location
air_elevation
air_phone
air_hub_airline
EQUIP_TYPE
EQ EQUIP_NO
EQ_EQUIP_TYPE
EQ SEAT CAPACITY
EQ FUEL CAPACITY
EQ_miles_per_gal
FLIGHT TABLE
fl_flight_no
fl_orig
fl_dest
fl_orig_time
fl_dest_time
fl_meal
fl_fare
fl_distance.
fl_time_zones
00
DEPARTURES
DEP FLIGHT_NO
DEP_DEP_DATE
DEP_PILOT_ID
DEP_EQUIP_NO
TICKET
TIC ITINERARY_NO
TIC FLIGHT NO
TIC FLIGHT DATE
TIC_SEAT
18
PILOT TABLE
pil pilot_id
pil pilot Fname
pil_pilot_Lname
pil_ssn
pil_street
pil_city
pil_state
pil_zip
pil_flight_pay
pil_brthdate
pil_hiredate
PASSENGER
PAS FNAME
PAS LNAME
PAS ITINERARY_NO
PAS FARE
PAS_CONFIRM_NO
Transcribed Image Text:Relationships X RESERVATION RES CONFIRM_NO RES_DATE RES_FNAME RES_LNAME RES_PHONE RES_FLIGHT_NO RES_FLIGHT DATE AIRPORT TABLE air_code air_location air_elevation air_phone air_hub_airline EQUIP_TYPE EQ EQUIP_NO EQ_EQUIP_TYPE EQ SEAT CAPACITY EQ FUEL CAPACITY EQ_miles_per_gal FLIGHT TABLE fl_flight_no fl_orig fl_dest fl_orig_time fl_dest_time fl_meal fl_fare fl_distance. fl_time_zones 00 DEPARTURES DEP FLIGHT_NO DEP_DEP_DATE DEP_PILOT_ID DEP_EQUIP_NO TICKET TIC ITINERARY_NO TIC FLIGHT NO TIC FLIGHT DATE TIC_SEAT 18 PILOT TABLE pil pilot_id pil pilot Fname pil_pilot_Lname pil_ssn pil_street pil_city pil_state pil_zip pil_flight_pay pil_brthdate pil_hiredate PASSENGER PAS FNAME PAS LNAME PAS ITINERARY_NO PAS FARE PAS_CONFIRM_NO
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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…
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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY