CREATE TABLE Passengers (
  Id INT PRIMARY KEY IDENTITY,
  FullName NVARCHAR(100)  UNIQUE  NOT NULL,
  Email VARCHAR(50) UNIQUE NOT NULL

)
CREATE TABLE Pilots (
  Id INT PRIMARY KEY IDENTITY,
  FirstName NVARCHAR(30) NOT NULL,
  LastName NVARCHAR(30) NOT NULL,
  Age TINYINT NOT NULL,
  CHECK (Age >= 21 AND Age <=62),
  Rating FLOAT(10) NOT NULL,
  CHECK (Rating >= 0 AND Rating <=10.0)

)
CREATE TABLE AircraftTypes (
  Id INT PRIMARY KEY IDENTITY,
  TypeName VARCHAR(30) UNIQUE NOT NULL

) CREATE TABLE Aircraft (
  Id INT PRIMARY KEY IDENTITY,
  Manufacturer NVARCHAR(25) NOT NULL,
  Model VARCHAR(30) NOT NULL,
  Year INT NOT NULL,
  FlightHours INT NOT NULL,
  Condition CHAR NOT NULL,
  TypeId INT FOREIGN KEY REFERENCES AircraftTypes(Id) NOT NULL

) CREATE TABLE PilotsAircraft (
  AircraftId INT FOREIGN KEY REFERENCES Aircraft(Id) NOT NULL,
  PilotId INT FOREIGN KEY REFERENCES Pilots(Id) NOT NULL,
  PRIMARY KEY (AircraftId, PilotId),
  )

  CREATE TABLE Airports (
  Id INT PRIMARY KEY IDENTITY,
  AirportName VARCHAR(70) NOT NULL,
  Country NVARCHAR(100) NOT NULL,
  )

   CREATE TABLE FlightDestinations (
  Id INT PRIMARY KEY IDENTITY,
  AirportId INT FOREIGN KEY REFERENCES Airports(Id) NOT NULL,
  Start DATETIME2 NOT NULL,
  AircraftId INT FOREIGN KEY REFERENCES Aircraft(Id) NOT NULL,
  PassengerId INT FOREIGN KEY REFERENCES Passengers(Id) NOT NULL,
  TicketPrice DECIMAL(18, 2) NOT NULL DEFAULT 15
)