MID manufacturer model capacity AID AID MID name count Вoeing Boeing Воeing Airbus 1 777 340 1 AA 1 3 15 787 260 2 UAL 1 2 10 3 737 140 3 DAL 14 4 320 230 4 SWA 3 1 8. 5 Airbus 380 560 5 ASA 3 24 Воeing 747 420 4 3 7 5 3 16

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Topic Video
Question

What is the      result of the natural join of the following two tables: Airlines and Fleet

Aircraft_Models
Airlines
Fleet
MID
manufacturer model
сараcity
AID
AID
MID
count
name
Вoeing
Вoeing
Воoeing
1
777
340
1
AA
1
3
15
787
260
2
UAL
1
2
10
3
737
140
3
DAL
2
2
14
4
Airbus
320
230
4
SWA
3
1
8.
5
Airbus
380
560
5
ASA
3
24
6
Вoeing
747
420
4
3
7
3
16
Transcribed Image Text:Aircraft_Models Airlines Fleet MID manufacturer model сараcity AID AID MID count name Вoeing Вoeing Воoeing 1 777 340 1 AA 1 3 15 787 260 2 UAL 1 2 10 3 737 140 3 DAL 2 2 14 4 Airbus 320 230 4 SWA 3 1 8. 5 Airbus 380 560 5 ASA 3 24 6 Вoeing 747 420 4 3 7 3 16
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Instruction Format
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
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education