系统分析与设计作业4

领域建模

a.阅读 Asg_RH 文档，按用例构建领域模型。

b.数据库建模(E-R 模型)

按 Task 3 要求，给出系统的 E-R 模型（数据逻辑模型）

导出 Mysql 物理数据库的脚本

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

CREATE SCHEMA IF NOT EXISTS `Asg` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `Asg` ;

-- -----------------------------------------------------
-- Table `Asg`.`Location`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Asg`.`Location` (
  `id` INT NOT NULL ,
  `name` VARCHAR(45) NULL ,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Asg`.`Hotel`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Asg`.`Hotel` (
  `id` INT NOT NULL ,
  `name` VARCHAR(45) NULL ,
  `Location_id` INT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_Hotel_Location_idx` (`Location_id` ASC) ,
  CONSTRAINT `fk_Hotel_Location`
    FOREIGN KEY (`Location_id` )
    REFERENCES `Asg`.`Location` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Asg`.`Reservation`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Asg`.`Reservation` (
  `id` INT NOT NULL ,
  `checkin_date` DATE NULL ,
  `checkout_date` DATE NULL ,
  `Hotel_id` INT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_Reservation_Hotel1_idx` (`Hotel_id` ASC) ,
  CONSTRAINT `fk_Reservation_Hotel1`
    FOREIGN KEY (`Hotel_id` )
    REFERENCES `Asg`.`Hotel` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Asg`.`Room`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Asg`.`Room` (
  `id` INT NOT NULL ,
  `type` VARCHAR(45) NULL ,
  `date` DATE NULL ,
  `price` DOUBLE NULL ,
  `Hotel_id` INT NOT NULL ,
  `Reservation_id` INT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_Room_Hotel1_idx` (`Hotel_id` ASC) ,
  INDEX `fk_Room_Reservation1_idx` (`Reservation_id` ASC) ,
  CONSTRAINT `fk_Room_Hotel1`
    FOREIGN KEY (`Hotel_id` )
    REFERENCES `Asg`.`Hotel` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Room_Reservation1`
    FOREIGN KEY (`Reservation_id` )
    REFERENCES `Asg`.`Reservation` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Asg`.`CustomerInfomation`
-- -----------------------------------------------------
CREATE  TABLE IF NOT EXISTS `Asg`.`CustomerInfomation` (
  `id` INT NOT NULL ,
  `name` VARCHAR(45) NULL ,
  `gender` VARCHAR(45) NULL ,
  `isSmoking` VARCHAR(45) NULL ,
  `E-mail` VARCHAR(45) NULL ,
  `Reservation_id` INT NOT NULL ,
  PRIMARY KEY (`id`) ,
  INDEX `fk_CustomerInfomation_Reservation1_idx` (`Reservation_id` ASC) ,
  CONSTRAINT `fk_CustomerInfomation_Reservation1`
    FOREIGN KEY (`Reservation_id` )
    REFERENCES `Asg`.`Reservation` (`id` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

USE `Asg` ;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

简单叙说数据库逻辑模型与领域模型的异同

• 数据库逻辑模型更明确具体，需要给出各个字段的类型，领域模型更注重对系统整体的描述。数据库逻辑模型需要排除没有明确要求记录其相关信息的类以及没有属性的概念类，而领域模型不会排除。
• 它们都将系统中的概念类抽象表示出来，并且表达了各个类的属性和彼此的关系。