系统分析与设计第六次作业

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

  • Make Reservation 用例

系统分析与设计第六次作业

Customer(ID/key, FullName, EmailAdress)
City(ID/key, CityName)
Hotel(ID/key, Name, Adress, CityID/Fkey)
Room(RoomID/key, HotelID/Fkey, Type, Availability)
ReservationItem(ID/key, RoomID/Fkey, BasketID/Fkey, checkInDate, checkOutDate, NumberOfAdults, NumberOfChildren, Price)
ReservationBasket(ID/key, CustomerID/Key)
  • Payment 用例

系统分析与设计第六次作业

Payment(ID/key, totalPrice, reservationID/Fkey, cardID/Fkey)
ReservationItem(ID/key, RoomID/Fkey, BasketID/Fkey, checkInDate, checkOutDate, NumberOfAdults, NumberOfChildren, Price)
CreditCard(ID/key, Type, CardSecurityCode, ExpiryDate, CardHolderID/Fkey)
CardHolder(ID/key, Title, FirstName, LastName, Address1, Address2, City, CountyOrState, Country, Postcode, DaytimeTelephone, EveningTelephone)

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

系统分析与设计第六次作业