A. 1 How many primary key in the Flight entity? B. 5 How many tables in the system can Customer table

Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter7: File Handling And Applications
Section: Chapter Questions
Problem 6PE
icon
Related questions
Question
estion Completion Status:
AIRPORT
FLIGHT
AIRPORTCODE
FLIGHTNUM
FK AIRPORT1
CUSTOMER
AIRPOR NAME
DTIME
CUSTOMERNUM
CITY
DDATE
FIRSTNAME
ATIME
ADATE
DESTINATIONAIRPORT
PRICE
AIRPLANENUM(FK)
AIRPORTCODE(FK)
STATE
MIDDLENAME
LASTNAME
3.
STREETNUMBER
STREETNAME
CITY
FK AIRPORT I
STATE
PHONE
1.
FK AIRPLANE
FK_FLIGHT
FK CUSTOMER
AIRPLANE
AIRPLANENUM
PAYMENT
FLIGHTNUM(FK
AIRPLANENAME
CUSTOMERNUM(FK)
CAPACITY
CREDITCARDTYPE
AIRPORTCODE(FK)
CREDITCARDNUM
BOOKDATE
HOLDDATE
EXPIREDHOLDDATE
A. 1
How many primary key in the Flight entity?
B.5
How many tables in the system can Customer table
retrieve data from?
C. 4
How many attributes in the Airport Table?
D.5
How many tables in the system?
E. 5
How many relationships shown in the system?
Click Save and Submit to save and submit. Click Save All Answers to save all ansuwers.
Transcribed Image Text:estion Completion Status: AIRPORT FLIGHT AIRPORTCODE FLIGHTNUM FK AIRPORT1 CUSTOMER AIRPOR NAME DTIME CUSTOMERNUM CITY DDATE FIRSTNAME ATIME ADATE DESTINATIONAIRPORT PRICE AIRPLANENUM(FK) AIRPORTCODE(FK) STATE MIDDLENAME LASTNAME 3. STREETNUMBER STREETNAME CITY FK AIRPORT I STATE PHONE 1. FK AIRPLANE FK_FLIGHT FK CUSTOMER AIRPLANE AIRPLANENUM PAYMENT FLIGHTNUM(FK AIRPLANENAME CUSTOMERNUM(FK) CAPACITY CREDITCARDTYPE AIRPORTCODE(FK) CREDITCARDNUM BOOKDATE HOLDDATE EXPIREDHOLDDATE A. 1 How many primary key in the Flight entity? B.5 How many tables in the system can Customer table retrieve data from? C. 4 How many attributes in the Airport Table? D.5 How many tables in the system? E. 5 How many relationships shown in the system? Click Save and Submit to save and submit. Click Save All Answers to save all ansuwers.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
SQL Query
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
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage