-
使用类图,分别对 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 对象建模
系统分析与设计 作业六
最新推荐文章于 2022-04-01 10:40:30 发布