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

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，对每个订单对象生命周期建模