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?
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
Related questions
Question
Answer the following questions according to the ERD of the Airport 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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Knowledge Booster
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
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

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)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education