1 . ER Diagram

DDL to implement the following scenario:
CREATE TABLE Member (
    MemberID INT PRIMARY KEY,
    FirstName VARCHAR(255),
    LastName VARCHAR(255),
    Email VARCHAR(255),
    ContactNumber VARCHAR(20),
    SmokingPreference VARCHAR(255),
    MusicalTaste VARCHAR(255),
    ChitchatPreference VARCHAR(255)
);

CREATE TABLE Helicopter (
    HelicopterID INT PRIMARY KEY,
    PilotLicenseNumber VARCHAR(20),
    LicenseExpiryDate DATE,
    Maker VARCHAR(255),
    Model VARCHAR(255),
    Color VARCHAR(255),
    YearBuilt INT,
    OwnerID INT,
    FOREIGN KEY (OwnerID) REFERENCES Member(MemberID)
);

CREATE TABLE City (
    CityID INT PRIMARY KEY,
    Name VARCHAR(255),
    State VARCHAR(255),
    Country VARCHAR(255)
);


CREATE TABLE FlightRequest (
    RequestID INT PRIMARY KEY,
    HelicopterID INT,
    StartCityID INT,
    DestinationCityID INT,
    DateTime DATETIME,
    AvailableSeats INT,
    MaxLuggageWeight DECIMAL(10, 2),
    ContributionPerHead DECIMAL(10, 2),
    RequestStatus VARCHAR(20),
    PromoCodeID INT,
    PromoCodeUsed BOOLEAN,
    FOREIGN KEY (HelicopterID) REFERENCES Helicopter(HelicopterID),
    FOREIGN KEY (StartCityID) REFERENCES City(CityID),
    FOREIGN KEY (DestinationCityID) REFERENCES City(CityID),
    FOREIGN KEY (PromoCodeID) REFERENCES PromoCode(PromoCodeID)
);

CREATE TABLE PromoCode (
    PromoCodeID INT PRIMARY KEY,
    DiscountAmount DECIMAL(10, 2),
    MaxDiscountAmount DECIMAL(10, 2),
    ExpiryDate DATE,
    MemberID INT,
    FOREIGN KEY (MemberID) REFERENCES Member(MemberID)
);
CREATE TABLE EnRouteCity (
    EnRouteID INT PRIMARY KEY,
    FlightRequestID INT,
    CityID INT,
    FOREIGN KEY (FlightRequestID) REFERENCES FlightRequest(RequestID),
    FOREIGN KEY (CityID) REFERENCES City(CityID)
);