Entities Structures in SQL Format
-- Flight TableCREATE TABLE Flight ( FlightID INT PRIMARY KEY, FlightNumber VARCHAR(20) UNIQUE, DepartureDateTime DATETIME, ArrivalDateTime DATETIME, OriginAirportCode VARCHAR(3), DestinationAirportCode VARCHAR(3), AvailableSeats INT, FOREIGN KEY (OriginAirportCode) REFERENCES Airport(AirportCode), FOREIGN KEY (DestinationAirportCode) REFERENCES Airport(AirportCode));-- Passenger TableCREATE TABLE Passenger ( PassengerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Email VARCHAR(100), PassportNumber VARCHAR(20));-- Airport TableCREATE TABLE Airport ( AirportCode VARCHAR(3) PRIMARY KEY, AirportName VARCHAR(100), Location VARCHAR(255), Facilities VARCHAR(255));-- Airline TableCREATE TABLE Airline ( AirlineID INT PRIMARY KEY, AirlineName VARCHAR(100), ContactNumber VARCHAR(20), OperatingRegion VARCHAR(100));-- Booking TableCREATE TABLE Booking ( BookingID INT PRIMARY KEY, FlightID INT, PassengerID INT, PaymentStatus VARCHAR(20), FOREIGN KEY (FlightID) REFERENCES Flight(FlightID), FOREIGN KEY (PassengerID) REFERENCES Passenger(PassengerID));-- Payment TableCREATE TABLE Payment ( PaymentID INT PRIMARY KEY, BookingID INT UNIQUE, PaymentMethod VARCHAR(50), Amount DECIMAL(10, 2), TransactionDateTime DATETIME, FOREIGN KEY (BookingID) REFERENCES Booking(BookingID));...