系统分析与设计第九周作业

1、使用类图，分别对 Asg_RH 文档中 Make Reservation 用例以及 Payment 用例开展领域建模。然后，根据上述模型，给出建议的数据表以及主要字段，特别是主键和外键

• Make reservation邻域建模
  
• Payment邻域建模
  
  数据表
  Make reservation
  Hotel(hotel_id/primary key,location_id/foreign key,name,address,hoteltype)
  Location(location_id/primary key,name,type)
  Room(room_id/primary key,hotel id/foreign key,type)
  Customer(customer_id/primary key,name, email)
  ReservationInformation(in_date,out_date,adult_num,child_num,child_age,reservation_id/primary key,customer_id/foreign key)
  Payment
  Customer(customer_id/primary key,creditcard_id/foreign key,name, email)
  CreditCard(creditcard_id/primary key,customer_id/foreign key,number,security_code,expiry_date,type)
  Payment(payment_id/primary key,creditcard_id/foreign key,date,time)
  Detail(payment_id/foreign key,creditcard_id/foreign key,first_name,last_name,address,city,country,postcode,telephone)
  ShoppingBasket(item,customer_id/foreign key)

2、使用 UML State Model，对每个订单对象生命周期建模