Draw relational database schema both of customer and FCC Separate the CUSTOMER entity from the SEAT_RESERVATION and extend it with the following attributes; e-mail, adress, country, passport number.Create an entity for frequent flyer customer tracking called FFC to keep track of the customers flight information. If a customer has checked-in physically a flight create a transaction record with the mileage information assigned to that flight leg. AIRPORTAirport_codeNameCity StateFLIGHTFlight_number Airline WeekdaysFLIGHT LEGFlight_numberLeg_number Departure_airport_codeArrival_airport_codeScheduled_departure_timeScheduled arrival_timeLEG_INSTANCEFlight_numberLeg_numberDeparture_airport_code Departure_time Arrival_airport_codeDate Number_of_available_seatsAirplane_idArrival_timeFAREFlight_numberFare_codeAmount RestrictionsAIRPLANE_TYPEAirplane_type_name Max_seats CompanyCAN_LANDAirplane_type_name Airport_codeAIRPLANEAirplane_idTotal_number_of_seatsAirplane_typeSEAT_RESERVATIONFlight_numberLeg_numberSeat_numberCustomer_phoneDateCustomer_name

The ask is to draw the relational schema for Customer and FFC. It requires to separate and enhance…

Answered: Draw relational database schema both of…

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

Draw relational database schema both of customer and FCC

Separate the CUSTOMER entity from the SEAT_RESERVATION and extend it with the following attributes; e-mail, adress, country, passport number.

Create an entity for frequent flyer customer tracking called FFC to keep track of the customers flight information. If a customer has checked-in physically a flight create a transaction record with the mileage information assigned to that flight leg.

AIRPORT
Airport_code
Name
City State
FLIGHT
Flight_number Airline Weekdays
FLIGHT LEG
Flight_number
Leg_number Departure_airport_code
Arrival_airport_code
Scheduled_departure_time
Scheduled arrival_time
LEG_INSTANCE
Flight_number
Leg_number
Departure_airport_code Departure_time Arrival_airport_code
Date Number_of_available_seats
Airplane_id
Arrival_time
FARE
Flight_number
Fare_code
Amount Restrictions
AIRPLANE_TYPE
Airplane_type_name Max_seats Company
CAN_LAND
Airplane_type_name Airport_code
AIRPLANE
Airplane_id
Total_number_of_seats
Airplane_type
SEAT_RESERVATION
Flight_number
Leg_number
Seat_number
Customer_phone
Date
Customer_name

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