1粹湃、 領(lǐng)域建模
? ? a. 閱讀 Asg_RH 文檔壹将，按用例構(gòu)建領(lǐng)域模型
???????按 Task2 要求府蛇，請(qǐng)使用工具 UMLet刹前，截圖格式務(wù)必是 png 并控制尺寸
? ? ?? 說(shuō)明：請(qǐng)不要受 PCMEF 層次結(jié)構(gòu)影響泳赋。你需要識(shí)別實(shí)體（E）和 中介實(shí)體（M，也稱(chēng)狀態(tài)實(shí)體）
????????????在 java web 應(yīng)用中喇喉，E 一般與數(shù)據(jù)庫(kù)構(gòu)建有關(guān)祖今， M 一般與 session 有關(guān)
????????????在 java web 應(yīng)用中，E 一般與數(shù)據(jù)庫(kù)構(gòu)建有關(guān)， M 一般與 session 有關(guān)
????b. 數(shù)據(jù)庫(kù)建模(E-R 模型)
? ? ·????按 Task 3 要求千诬，給出系統(tǒng)的 E-R 模型（數(shù)據(jù)邏輯模型）
? ? ? ?? 建模工具 PowerDesigner（簡(jiǎn)稱(chēng)PD） 或開(kāi)源工具 OpenSystemArchitect
????????導(dǎo)出 Mysql 物理數(shù)據(jù)庫(kù)的腳本
????????簡(jiǎn)單敘說(shuō) 數(shù)據(jù)庫(kù)邏輯模型 與 領(lǐng)域模型 的異同
? -- MySQL Script generated by MySQL Workbench
-- Sun Apr 29 21:30:30 2018
-- Model: New Model? ? Version: 1.0
-- MySQL Workbench Forward Engineering
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`Location`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Location` (
? `LocationId` INT NOT NULL,
? `Name` VARCHAR(45) NULL,
? `Hotle_HotelId` INT NOT NULL,
? PRIMARY KEY (`LocationId`),
? INDEX `fk_Location_hotle_idx` (`Hotle_HotelId` ASC),
? CONSTRAINT `fk_Location_hotle`
? ? FOREIGN KEY (`Hotle_HotelId`)
? ? REFERENCES `mydb`.`Hotle` (`HotelId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Hotle`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Hotle` (
? `HotelId` INT NOT NULL,
? `Name` VARCHAR(45) NOT NULL,
? `Address` VARCHAR(45) NOT NULL,
? `Location_LocationId` INT NOT NULL,
? PRIMARY KEY (`HotelId`, `Location_LocationId`),
? INDEX `fk_hotle_Location1_idx` (`Location_LocationId` ASC),
? CONSTRAINT `fk_hotle_Location1`
? ? FOREIGN KEY (`Location_LocationId`)
? ? REFERENCES `mydb`.`Location` (`LocationId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Room`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Room` (
? `RoomId` INT NOT NULL,
? `Type` VARCHAR(45) NULL,
? `Hotle_HotelId` INT NOT NULL,
? PRIMARY KEY (`RoomId`, `Hotle_HotelId`),
? INDEX `fk_room_hotle1_idx` (`Hotle_HotelId` ASC),
? CONSTRAINT `fk_room_hotle1`
? ? FOREIGN KEY (`Hotle_HotelId`)
? ? REFERENCES `mydb`.`Hotle` (`HotelId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Traveller`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Traveller` (
? `TravellerId` INT NOT NULL,
? `Name` VARCHAR(45) NULL,
? PRIMARY KEY (`TravellerId`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Reservation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Reservation` (
? `ReservationId` INT NOT NULL,
? `HotelId` INT NULL,
? `TravellerId` INT NULL,
? `CheckIn` DATE NULL,
? `CheckOut` DATE NULL,
? `Traveller_TravellerId` INT NOT NULL,
? `Hotle_HotelId` INT NOT NULL,
? `Hotle_Location_LocationId` INT NOT NULL,
? `Room_RoomId` INT NOT NULL,
? `Room_Hotle_HotelId` INT NOT NULL,
? PRIMARY KEY (`ReservationId`, `Hotle_HotelId`, `Hotle_Location_LocationId`, `Room_RoomId`, `Room_Hotle_HotelId`),
? INDEX `fk_Reservation_Traveller1_idx` (`Traveller_TravellerId` ASC),
? INDEX `fk_Reservation_Hotle1_idx` (`Hotle_HotelId` ASC, `Hotle_Location_LocationId` ASC),
? INDEX `fk_Reservation_Room1_idx` (`Room_RoomId` ASC, `Room_Hotle_HotelId` ASC),
? CONSTRAINT `fk_Reservation_Traveller1`
? ? FOREIGN KEY (`Traveller_TravellerId`)
? ? REFERENCES `mydb`.`Traveller` (`TravellerId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION,
? CONSTRAINT `fk_Reservation_Hotle1`
? ? FOREIGN KEY (`Hotle_HotelId` , `Hotle_Location_LocationId`)
? ? REFERENCES `mydb`.`Hotle` (`HotelId` , `Location_LocationId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION,
? CONSTRAINT `fk_Reservation_Room1`
? ? FOREIGN KEY (`Room_RoomId` , `Room_Hotle_HotelId`)
? ? REFERENCES `mydb`.`Room` (`RoomId` , `Hotle_HotelId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION)
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`Payment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Payment` (
? `Type` INT NULL,
? `Price` INT NULL,
? `Security code` VARCHAR(45) NULL,
? `Traveller_TravellerId` INT NOT NULL,
? `Reservation_ReservationId` INT NOT NULL,
? `Reservation_Hotle_HotelId` INT NOT NULL,
? `Reservation_Hotle_Location_LocationId` INT NOT NULL,
? INDEX `fk_Payment_Traveller1_idx` (`Traveller_TravellerId` ASC),
? INDEX `fk_Payment_Reservation1_idx` (`Reservation_ReservationId` ASC, `Reservation_Hotle_HotelId` ASC, `Reservation_Hotle_Location_LocationId` ASC),
? CONSTRAINT `fk_Payment_Traveller1`
? ? FOREIGN KEY (`Traveller_TravellerId`)
? ? REFERENCES `mydb`.`Traveller` (`TravellerId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION,
? CONSTRAINT `fk_Payment_Reservation1`
? ? FOREIGN KEY (`Reservation_ReservationId` , `Reservation_Hotle_HotelId` , `Reservation_Hotle_Location_LocationId`)
? ? REFERENCES `mydb`.`Reservation` (`ReservationId` , `Hotle_HotelId` , `Hotle_Location_LocationId`)
? ? ON DELETE NO ACTION
? ? ON UPDATE NO ACTION)
ENGINE = InnoDB;
相同點(diǎn)
都是對(duì)實(shí)際問(wèn)題的抽象撒踪，用于更直觀(guān)的顯示需求
兩者都注重在對(duì)問(wèn)題中的對(duì)象進(jìn)行建模。 E-R模型中大渤，問(wèn)題對(duì)象為實(shí)體制妄；領(lǐng)域模型中，問(wèn)題對(duì)象轉(zhuǎn)化為類(lèi)泵三。
兩者在構(gòu)建時(shí)有相似之處耕捞，領(lǐng)域模型需要分析所有的名詞，從中提取出業(yè)務(wù)實(shí)體烫幕，區(qū)分名詞中的屬性俺抽，角色，實(shí)體较曼，實(shí)例磷斧，形成操作實(shí)體集合；E-R模型的構(gòu)建方法與此類(lèi)似捷犹。不過(guò)稍有不同在于忽略中介實(shí)體
不同點(diǎn)
領(lǐng)域模型側(cè)重于顯示不同對(duì)象之間的關(guān)系弛饭，而不是對(duì)象內(nèi)的具體實(shí)現(xiàn)。領(lǐng)域模型需要標(biāo)注對(duì)象之間的對(duì)應(yīng)關(guān)系（one-one, one-many, many-one, many-many）. E-R模型則需要八每個(gè)實(shí)體內(nèi)部也進(jìn)行詳細(xì)的設(shè)計(jì)萍歉。這里體現(xiàn)兩者抽象程度的區(qū)分
E-R 模型中只涉及具體實(shí)際可視對(duì)象侣颂，即需要被記錄的對(duì)象。而領(lǐng)域模型中顯然既包括具體的實(shí)體集E枪孩， 也包含有中介實(shí)體M
