系统分析与设计第六次作业_agoda 信息系统分析-CSDN博客

本文链接：https://blog.csdn.net/QingJiuYou/article/details/89816616

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