系统分析与设计 作业六

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

  • 领域建模：

    • Make Reservation 用例
      

    • Payment 用例
      

  • 数据建模：

    • Hotel (ID/Key, LocationID/FKey, Name, Address, isFavourites, isLowestPrice, isHigestStarRating, isAlphabetical)
    • Location (ID/Key, Name, Type)
    • Traveler (ID/Key, Name, Email)
    • Reservation (ID/Key, TravelerID/FKey, Date, Time)
    • ReservationItem (ID/Key, ReservationID/FKey, HotelID/FKey, CheckInDate, CheckOutDate, NightsNum, AdultsNum, ChildrenNum, ChildrenAge)
    • Room (ID/Key, HotelID/FKey, Number, Type, Status, Price)
    • Payment (ID/Key, ReservationID/FKey, TotalCost)
    • PaymentItem (ID/Key, PaymentID/FKey, TotalCost, BookingDetails)
    • CreditCard (ID/Key, CardholderID/FKey, Type, CardNumber, SecurityCode, ExpiryDate)
    • Cardholder (ID/Key, FirstName, LastName, State, Counrty, City, Address, Postcode, DaytimeTelephone, EveningTelephone)

• 使用 UML State Model，参考 Asg_RH 文档， 对 Reservation/Order 对象建模