Answer the following questions according to the ERD of the Airport system: AIRPORT AIRPORTCODE AIRPOR NAME FLIGHT FLIGHTNUM DTIME DDATE ATIME ADATE DESTINATIONAIRPORT PRICE FK AIRPORT1 CUSTOMER CUSTOMERNUM FIRSTNAME MIDDLENAME LASTNAME STREETNUMBER STREETNAME CITY STATE PHONE CITY STATE AIRPLANENUM(FK) AIRPORTCODE(FK) FK AIRPORT I FK_ARPLANE FK_FLIGHT FK_CUSTOMER AIRPLANE AIRPLANENUM AIRPLANENAME PAYMENT FLIGHTNUM(FK) CUSTOMERNUM(FK) CREDITCARDTYPE САРАСТY AIRPORTCODE(FK) CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE How many primary key in the Flight entity? A. 4 В. 1 How many tables in the system can Customer table retrieve data from? C. 5 How many attributes in the Airport Table? D.5 How many tables in the system? E. 5 How many relationships shown in the system?

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
Question

Answer the following questions according to the ERD of the Airport system:

Answer the following questions according to the ERD of the Airport system:
AIRPORT
FLIGHT
FLIGHTNUM
AIRPORTCODE
FK AIRPORT1
CUSTOMER
AIRPOR NAME
CITY
DTIME
CUSTOMERNUM
DDATE
STATE
ATIME
FIRSTNAME
ADATE
MIDDLENAME
DESTINATIONAIRPORT
LASTNAME
PRICE
STREETNUMBER
AIRPLANENUM(FK)
AIRPORTCODE(FK)
STREETNAME
CITY
FK_AIRPORT
STATE
PHONE
FK AIRPLANE
FK_FLIGHT
FK_CUSTOMER
AIRPLANE
PAYMENT
AIRPLANENUM
FLIGHTNUM(FK)
AIRPLANENAME
CUSTOMERNUM(FK)
САРАСITY
CREDITCARDTYPE
AIRPORTCODE(FK)
CREDITCARDNUM
BOOKDATE
HOLDDATE
EXPIREDHOLDDATE
How many primary key in the Flight entity?
А. 4
How many tables in the system can Customer table retrieve
В. 1
data from?
C.5
How many attributes in the Airport Table?
D.5
How many tables in the system?
E. 5
How many relationships shown in the system?
Transcribed Image Text:Answer the following questions according to the ERD of the Airport system: AIRPORT FLIGHT FLIGHTNUM AIRPORTCODE FK AIRPORT1 CUSTOMER AIRPOR NAME CITY DTIME CUSTOMERNUM DDATE STATE ATIME FIRSTNAME ADATE MIDDLENAME DESTINATIONAIRPORT LASTNAME PRICE STREETNUMBER AIRPLANENUM(FK) AIRPORTCODE(FK) STREETNAME CITY FK_AIRPORT STATE PHONE FK AIRPLANE FK_FLIGHT FK_CUSTOMER AIRPLANE PAYMENT AIRPLANENUM FLIGHTNUM(FK) AIRPLANENAME CUSTOMERNUM(FK) САРАСITY CREDITCARDTYPE AIRPORTCODE(FK) CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE How many primary key in the Flight entity? А. 4 How many tables in the system can Customer table retrieve В. 1 data from? C.5 How many attributes in the Airport Table? D.5 How many tables in the system? E. 5 How many relationships shown in the system?
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Mobile Devices
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.
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