CREATE TABLE Reservation
PRIMARY KEY (passengerId, flightId),
FOREIGN KEY (passengerId) REFERENCES Passenger,
FOREIGN KEY (flightId) REFERENCES Flight );
Give an integrity constraint PlaneCapacity that enforces the restriction that the number of passengers on a plane cannot exceed the plane’s capacity
Dear customer, it's rather complex question in Programming, please, submit your assignment to our site and our experts will help you.