Objective is to track schedules for airplane flights. The flights go between cities. The aircraft type that is scheduled for that flight implies the seating capacity. We need to know the seating capacity so that we know how many seats we can sell.What would the airplanes, flights, and travel agency class look like? (part a,b,c) NAMEDAYS OFAIRLINEFLIFHTWEEKCODEAttributeNUMBERFROMDEPARTURETIMEARRIVALTIMEAIRLINESFLIGHTSDESTINA TIONORIGINтоSTOPSDATEEntitySEATFLITE-NAMERESERVATIONCREWMEMBERSP_IDTARVELAGENCYPASSENGERtextADDRESSAGEPHONE NO.PHONENUMBERStextCODENAMECONTACTSEXPERSONNAMEADDRESS

Answered: Objective is to track schedules for…

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

See similar textbooks

Related questions

Concept explainers

Question

Objective is to track schedules for airplane flights. The flights go between cities. The aircraft type that is scheduled for that flight implies the seating capacity. We need to know the seating capacity so that we know how many seats we can sell.

What would the airplanes, flights, and travel agency class look like?

(part a,b,c)

NAME
DAYS OF
AIRLINE
FLIFHT
WEEK
CODE
Attribute
NUMBER
FROM
DEPARTURE
TIME
ARRIVAL
TIME
AIRLINES
FLIGHTS
DESTINA TIO
N
ORIGIN
то
STOPS
DATE
Entity
SEAT
FLITE-NAME
RESERVATION
CREW
MEMBERS
P_ID
TARVEL
AGENCY
PASSENGER
text
ADDRESS
AGE
PHONE NO.
PHONE
NUMBERS
text
CODE
NAME
CONTACT
SEX
PERSON
NAME
ADDRESS

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions