Airport DB

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

)

CREATE TABLE Pilots(
Id INT PRIMARY KEY IDENTITY(1,1),
FirstName VARCHAR(30) NOT NULL UNIQUE,
LastName VARCHAR(30)  NOT NULL UNIQUE,
Age TINYINT  NOT NULL CHECK(Age >=21 AND Age <=62),
Rating DECIMAL(9,2) NOT NULL CHECK(Rating >=0.0 AND Rating<=10.0),
)


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

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

)

CREATE TABLE PilotsAircraft(
AircraftId INT NOT NULL,
PilotId INT NOT NULL,
CONSTRAINT PK_Aircraft PRIMARY KEY (AircraftId,PilotId),
CONSTRAINT FK_Aircraft_Aircraft FOREIGN KEY(AircraftId)
REFERENCES Aircraft(Id),
CONSTRAINT FK_Aircraft_Pilots FOREIGN KEY(PilotId)
REFERENCES Pilots(Id)
)
-------------
CREATE TABLE Airports(
Id INT PRIMARY KEY IDENTITY(1,1),
AirportName VARCHAR(70) NOT NULL UNIQUE,
Country VARCHAR(100) NOT NULL UNIQUE
)

CREATE TABLE FlightDestinations(
Id INT PRIMARY KEY IDENTITY(1,1),
AirportId  INT NOT NULL,
START  DATETIME  NOT NULL,
AircraftId   INT NOT NULL,
PassengerId  INT NOT NULL,
TicketPrice DECIMAL(18,2) NOT NULL DEFAULT(15),
CONSTRAINT FK_FlightDestinations_Airports
FOREIGN KEY(AirportId) REFERENCES  Airports  (Id),

CONSTRAINT FK_FlightDestinations_Aircraft
FOREIGN KEY(AircraftId) REFERENCES  Aircraft  (Id),
CONSTRAINT FK_FlightDestinations_Passengers
FOREIGN KEY(PassengerId) REFERENCES  Passengers  (Id),
)