Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.

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

Find the names of the pilots who are not certified to fly the aircrafts in the flight table. Sort the name by ascending order.

New Database
Create Table
Tables (4)
Name
Aircraft
aid
mname
model
cruisingrange
Certificate
eid
aid
Employee
eid
fname
Iname
salary
Flight
flno
origin
destination
distance
departure
arrival
fare
aid
Indices (0)
Views (0)
Triggers (0)
Open Database
Create Index
Write Changes
Open Project
Save Project
X Close Database
Database Structure
Browse Data Edit Pragmas | Execute SQL
Print
Type
Schema
CREATE TABLE "Aircraft" (`aid` INTEGER, `mname` TEXT, `model` TEXT, `cruisingrange` INTEGER, PRIMARY KEY (aid))
INTEGER
"aid" INTEGER
TEXT
"mname" TEXT
TEXT
"model" TEXT
INTEGER
"cruisingrange" INTEGER
CREATE TABLE "Certificate" (`eid` INTEGER, `aid` INTEGER, PRIMARY KEY (eid,aid), FOREIGN KEY(`eid`) REFERENCES Employee, FOREIGN KEY(`aid`) REFERENCES Aircraft)
"eid" INTEGER
INTEGER
INTEGER
"aid" INTEGER
CREATE TABLE "Employee" (`eid` INTEGER, `fname` TEXT NOT NULL, `Iname` TEXT NOT NULL, `salary` INTEGER, PRIMARY KEY(eid))
INTEGER
"eid" INTEGER
TEXT
"fname" TEXT NOT NULL
TEXT
"Iname" TEXT NOT NULL
INTEGER
"salary" INTEGER
CREATE TABLE "Flight" ( `flno` INTEGER, `origin` TEXT, `destination` TEXT, `distance` INTEGER, `departure` NUMERIC, `arrival` NUMERIC, `fare` REAL, `aid` INTEGER, PRIMARY KEY (flno), FOREIGN KEY(`aid`) REF
"fino" INTEGER
INTEGER
TEXT
"origin" TEXT
TEXT
"destination" TEXT
INTEGER
"distance" INTEGER
NUMERIC
"departure" NUMERIC
"arrival" NUMERIC
NUMERIC
REAL
"fare" REAL
INTEGER
"aid" INTEGER
UTF-8
Revert Changes
Attach Database
Transcribed Image Text:New Database Create Table Tables (4) Name Aircraft aid mname model cruisingrange Certificate eid aid Employee eid fname Iname salary Flight flno origin destination distance departure arrival fare aid Indices (0) Views (0) Triggers (0) Open Database Create Index Write Changes Open Project Save Project X Close Database Database Structure Browse Data Edit Pragmas | Execute SQL Print Type Schema CREATE TABLE "Aircraft" (`aid` INTEGER, `mname` TEXT, `model` TEXT, `cruisingrange` INTEGER, PRIMARY KEY (aid)) INTEGER "aid" INTEGER TEXT "mname" TEXT TEXT "model" TEXT INTEGER "cruisingrange" INTEGER CREATE TABLE "Certificate" (`eid` INTEGER, `aid` INTEGER, PRIMARY KEY (eid,aid), FOREIGN KEY(`eid`) REFERENCES Employee, FOREIGN KEY(`aid`) REFERENCES Aircraft) "eid" INTEGER INTEGER INTEGER "aid" INTEGER CREATE TABLE "Employee" (`eid` INTEGER, `fname` TEXT NOT NULL, `Iname` TEXT NOT NULL, `salary` INTEGER, PRIMARY KEY(eid)) INTEGER "eid" INTEGER TEXT "fname" TEXT NOT NULL TEXT "Iname" TEXT NOT NULL INTEGER "salary" INTEGER CREATE TABLE "Flight" ( `flno` INTEGER, `origin` TEXT, `destination` TEXT, `distance` INTEGER, `departure` NUMERIC, `arrival` NUMERIC, `fare` REAL, `aid` INTEGER, PRIMARY KEY (flno), FOREIGN KEY(`aid`) REF "fino" INTEGER INTEGER TEXT "origin" TEXT TEXT "destination" TEXT INTEGER "distance" INTEGER NUMERIC "departure" NUMERIC "arrival" NUMERIC NUMERIC REAL "fare" REAL INTEGER "aid" INTEGER UTF-8 Revert Changes Attach Database
Expert 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