系统分析与设计lesson7个人作业

a.

b.

导出的脚本：

CREATE TABLE `Traveller`
(
  userid INTEGER(40) NOT NULL,
  E-mail VARCHAR(50),
  Name VARCHAR(40),
  PRIMARY KEY (userid)
);

CREATE TABLE `CreditCard`
(
  CardNumber VARCHAR(18) NOT NULL,
  userid INTEGER(40) NOT NULL,
  PRIMARY KEY (CardNumber,userid)
);

CREATE TABLE `Destination`
(
  cityName VARCHAR(20) NOT NULL,
  PRIMARY KEY (cityName)
);

CREATE TABLE `Hotel`
(
  Hotel_id INTEGER NOT NULL,
  HName VARCHAR(50),
  cityName VARCHAR(20) NOT NULL,
  PRIMARY KEY (Hotel_id)
);

CREATE INDEX idxHotel1 ON Hotel
(
  cityName
);

CREATE TABLE `Reservayion`
(
  resid INTEGER NOT NULL,
  CheckinDate DATE,
  CheckoutDate DATE,
  userid INTEGER(40) NOT NULL,
  PRIMARY KEY (resid)
);

CREATE INDEX idxReservayion1 ON Reservayion
(
  userid
);
CREATE TABLE `Room`
(
  roomid INTEGER NOT NULL,
  roomType VARCHAR(20),
  Hotel_id INTEGER NOT NULL,
  resid INTEGER NOT NULL,
  PRIMARY KEY (roomid,Hotel_id,resid)
);CREATE TABLE `Traveller`
(
  use