领域建模
阅读Asg_RH文档,按用例构建领域模型。
- 按Task2要求,请使用工具UMLet,截图格式务必是png并控制尺寸。
- 说明:请不要受PCMEF层次结构影响。你需要识别实体(E)和中介实体(M,也称状态实体)
- 在单页面应用(如vue)中,E一般与数据库构建有关,M一般与store模式有关
- 在java web应用中,E一般与数据库构建有关,M一般与session有关
数据库建模(E-R模型)
CREATE TABLE `Hotel`
(
Hotel_Id INTEGER NOT NULL,
name VARCHAR(100) NOT NULL,
hot INTEGER,
star INTEGER,
address VARCHAR(200),
phone_number VARCHAR(20),
min_stay INTEGER,
PRIMARY KEY (Hotel_Id)
);
CREATE TABLE `Location`
(
Location_Id INTEGER NOT NULL,
Region VARCHAR(100),
City VARCHAR(100),
Town VARCHAR(100),
PRIMARY KEY (Location_Id)
);
CREATE TABLE `Room`
(
room_Id INTEGER NOT NULL,
isAvailable BIT,
description VARCHAR(500),
type_ INTEGER,
price INTEGER,
PRIMARY KEY (room_Id)
);
CREATE TABLE `Credit_card`
(
Creditcard_id INTEGER NOT NULL,
card_number VARCHAR(30),
card_security_code VARCHAR(50),
PRIMARY KEY (Creditcard_id)
);
CREATE TABLE `Reservation`
(
Reservation_id INTEGER NOT NULL,
city VARCHAR(100),
check_in_date DATE NOT NULL,
check_out_date LONGBLOB NOT NULL,
PRIMARY KEY (Reservation_id)
);
CREATE TABLE `Traveler`
(
Traveler_Id INTEGER NOT NULL,
full_name VARCHAR(50),
age INTEGER,
isSmoking BIT,
email_address VARCHAR(100),
PRIMARY KEY (Traveler_Id)
);