1- Retrieve the name and address of passengers

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 14MC: A unique identifier for a data row that consists of more than one field is commonly called...
icon
Related questions
Question
i need the answer quickly
Based on the following database containing two table: Passenger and
Reservation
Passenger
Id
Name
Age
24
Phone
01334455
07223344
Address
301
Rima
Mazen
Nathalie
Beirut
302
40
Saida
Tripoli
Beirut
305
21
30
06889977
04667755
07223344
307
Rabih
Siham
310
23
Nabatieh
Reservation
Id
FlightN
МЕ205
EM912
AF102
EM910
Date
Departure
Beirut
Dubai
Destination
SeatN
14B
20C
SA
Passengerld
302
310
301
1.
22-4-2022
7-5-2022
24-6-2022
11-7-2022
19-7-2022
Istanbul
2
Beirut
3
Spain
Beirut
Beirut
Beirut
Dubai
4
25B
1A
310
307
AF019
Bruxel
1- Retrieve the name and address of passengers
Choose
Transcribed Image Text:Based on the following database containing two table: Passenger and Reservation Passenger Id Name Age 24 Phone 01334455 07223344 Address 301 Rima Mazen Nathalie Beirut 302 40 Saida Tripoli Beirut 305 21 30 06889977 04667755 07223344 307 Rabih Siham 310 23 Nabatieh Reservation Id FlightN МЕ205 EM912 AF102 EM910 Date Departure Beirut Dubai Destination SeatN 14B 20C SA Passengerld 302 310 301 1. 22-4-2022 7-5-2022 24-6-2022 11-7-2022 19-7-2022 Istanbul 2 Beirut 3 Spain Beirut Beirut Beirut Dubai 4 25B 1A 310 307 AF019 Bruxel 1- Retrieve the name and address of passengers Choose
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Encryption and decryption
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning