Главная Коллекция "Revolution" Программирование, компьютеры и кибернетика Проектирование информационной системы для автоматизации процесса продажи туров для ООО "МИР"

Проектирование информационной системы для автоматизации процесса продажи туров для ООО "МИР"

Обзор средств разработки информационных систем и языков программирования. Объектно-ориентированное проектирование информационной системы продажи туров. Разработка реляционной базы данных, серверной и клиентской частей информационной системы для турфирмы.

Рубрика Программирование, компьютеры и кибернетика
Вид дипломная работа
Язык русский
Дата добавления 23.01.2018
Размер файла 1,9 M
рефераты на заказ со скидкой

Отправить свою хорошую работу в базу знаний просто. Используйте форму, расположенную ниже

Студенты, аспиранты, молодые ученые, использующие базу знаний в своей учебе и работе, будут вам очень благодарны.

Страница:

CONSTRAINT `fk_Contract_has_Customer_Contract1`

FOREIGN KEY (`id_Contract`)

REFERENCES `worldb`.`Contract` (`id_Contract`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Contract_has_Customer_Customer1`

FOREIGN KEY (`id_Customer`)

REFERENCES `worldb`.`Customer` (`id_Customer`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Airline`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Airline` (

`id_Airline` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`Country_id` INT UNSIGNED NOT NULL,

`Name` VARCHAR(20) NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Airline`),

INDEX `fk_Airline_Country1_idx` (`Country_id` ASC),

CONSTRAINT `fk_Airline_Country1`

FOREIGN KEY (`Country_id`)

REFERENCES `worldb`.`Country` (`id`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Airport`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Airport` (

`id_Airport` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`Name` VARCHAR(20) NOT NULL,

`id_City` INT UNSIGNED NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Airport`),

INDEX `fk_Airport_City1_idx` (`id_City` ASC),

CONSTRAINT `fk_Airport_City1`

FOREIGN KEY (`id_City`)

REFERENCES `worldb`.`City` (`id_City`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Flight`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Flight` (

`id_Flight` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`id_Airline` INT UNSIGNED NOT NULL,

`Number` INT UNSIGNED NOT NULL,

`id_Airport_depart` INT UNSIGNED NOT NULL,

`id_Airport_arrival` INT UNSIGNED NOT NULL,

`date_depart` DATETIME NOT NULL,

`date_arrival` DATETIME NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Flight`),

INDEX `fk_Flight_Airline1_idx` (`id_Airline` ASC),

INDEX `fk_Flight_Airport1_idx` (`id_Airport_depart` ASC),

INDEX `fk_Flight_Airport2_idx` (`id_Airport_arrival` ASC),

CONSTRAINT `fk_Flight_Airline1`

FOREIGN KEY (`id_Airline`)

REFERENCES `worldb`.`Airline` (`id_Airline`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Flight_Airport1`

FOREIGN KEY (`id_Airport_depart`)

REFERENCES `worldb`.`Airport` (`id_Airport`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Flight_Airport2`

FOREIGN KEY (`id_Airport_arrival`)

REFERENCES `worldb`.`Airport` (`id_Airport`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Flight_has_Tour`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Flight_has_Tour` (

`id_Flight` INT UNSIGNED NOT NULL,

`id_Tour` INT UNSIGNED NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Flight`, `id_Tour`),

INDEX `fk_Flight_has_Tour_Tour1_idx` (`id_Tour` ASC),

INDEX `fk_Flight_has_Tour_Flight1_idx` (`id_Flight` ASC),

CONSTRAINT `fk_Flight_has_Tour_Flight1`

FOREIGN KEY (`id_Flight`)

REFERENCES `worldb`.`Flight` (`id_Flight`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Flight_has_Tour_Tour1`

FOREIGN KEY (`id_Tour`)

REFERENCES `worldb`.`Tour` (`id_Tour`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`TypeApp_has_Hotel`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`TypeApp_has_Hotel` (

`id_TypeApp` INT UNSIGNED NOT NULL,

`id_Hotel` INT UNSIGNED NOT NULL,

`last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_TypeApp`, `id_Hotel`),

INDEX `fk_TypeApp_has_Hotel_Hotel1_idx` (`id_Hotel` ASC),

INDEX `fk_TypeApp_has_Hotel_TypeApp1_idx` (`id_TypeApp` ASC),

CONSTRAINT `fk_TypeApp_has_Hotel_TypeApp1`

FOREIGN KEY (`id_TypeApp`)

REFERENCES `worldb`.`TypeApp` (`id_TypeApp`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_TypeApp_has_Hotel_Hotel1`

FOREIGN KEY (`id_Hotel`)

REFERENCES `worldb`.`Hotel` (`id_Hotel`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Photo_Resort`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Photo_Resort` (

`id_Photo_Resort` INT UNSIGNED NOT NULL,

`id_Resort` INT UNSIGNED NOT NULL,

`Photo` BLOB NOT NULL,

`last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Photo_Resort`),

INDEX `fk_Photo_Resort_Resort1_idx` (`id_Resort` ASC),

CONSTRAINT `fk_Photo_Resort_Resort1`

FOREIGN KEY (`id_Resort`)

REFERENCES `worldb`.`Resort` (`id_Resort`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Photo_hotel`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Photo_hotel` (

`id_Photo_hotel` INT UNSIGNED NOT NULL AUTO_INCREMENT,

`id_Hotel` INT UNSIGNED NOT NULL,

`Photo` BLOB NOT NULL,

`last_update` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id_Photo_hotel`),

INDEX `fk_Photo_hotel_Hotel1_idx` (`id_Hotel` ASC),

CONSTRAINT `fk_Photo_hotel_Hotel1`

FOREIGN KEY (`id_Hotel`)

REFERENCES `worldb`.`Hotel` (`id_Hotel`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `worldb`.`Country_has_Currency`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `worldb`.`Country_has_Currency` (

`Country_id` INT UNSIGNED NOT NULL,

`Currency_id_Currency` INT UNSIGNED NOT NULL,

PRIMARY KEY (`Country_id`, `Currency_id_Currency`),

INDEX `fk_Country_has_Currency_Currency1_idx` (`Currency_id_Currency` ASC),

INDEX `fk_Country_has_Currency_Country1_idx` (`Country_id` ASC),

CONSTRAINT `fk_Country_has_Currency_Country1`

FOREIGN KEY (`Country_id`)

REFERENCES `worldb`.`Country` (`id`)

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `fk_Country_has_Currency_Currency1`

FOREIGN KEY (`Currency_id_Currency`)

REFERENCES `worldb`.`Currency` (`id_Currency`)

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Размещено на Allbest.ru

...

Страница:


Подобные документы

Работы в архивах красиво оформлены согласно требованиям ВУЗов и содержат рисунки, диаграммы, формулы и т.д.
PPT, PPTX и PDF-файлы представлены только в архивах.
Рекомендуем скачать работу.

© 2000 — 2023, ООО «Олбест» Все права защищены