CREATE TABLE flights (code Char, pointOfDeparture Char, pointOfArrival Char, dateOfDeparture Date, dateOfArrival Date, timeOfDeparture Date, timeOnWay – Number, typePlane - Char)
CREATE TABLE passengers (numberTiket Number, numberPassport Char, numberPlace Char, baggageWeight Number, typePlane Char)
CREATE TABLE tikets
(id Number AUTO_INCREMENT,
numberTiket Number,
pointOfDeparture Char,
pointOfArrival Char,
dateOfDeparture Date)
CREATE TABLE flights
(id Number AUTO_INCREMENT,
code Char,
pointOfDeparture Char FOREIGN KEY REFERENCES tikets(pointOfDeparture),
pointOfArrival Char FOREIGN KEY REFERENCES tikets(pointOfArrival),
dateOfDeparture Date FOREIGN KEY REFERENCES tikets(dateOfDeparture),
dateOfArrival Date,
timeOfDeparture Date,
timeOnWay – Number,
typePlane - Char)
CREATE TABLE passengers
(id Number AUTO_INCREMENT,
numberTiket Number FOREIGN KEY REFERENCES tikets(numberTiket),
numberPassport Char,
numberPlace Char,
baggageWeight Number,
typePlane Char)
Если Вы уже зарегистрированы на Портале - войдите в систему, если Вы еще не регистрировались - пройдите простую процедуру регистрации.