本文主要是介绍系统分析与设计第六次作业,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
使用类图,分别对 Asg_RH 文档中 Make Reservation 用例以及 Payment 用例开展领域建模。然后,根据上述模型,给出建议的数据表以及主要字段,特别是主键和外键
Make Reservation 用例
Make Reservation 用例数据建模
- Customer (CustomerID/Key, name, email)
- Reservation (ReservationID/Key, CustomerID/FKey, HotelID/FKey, checkInDate, roomOfNights)
- ReservationItem (ReservationItemID/Key, ReservationID/FKey, RoomID/Fkey, type, checkInDate, checkOutDate, numberOfNights, numberOfAdults, numberOfChildren, ageOfChildren)
- Hotel (HotelID/Key, LoctionID/Fkey, name, address, star, info, isFavourite, isNomalPrice, rating, cutoff)
- Location(LocationID/Key, HotelID/Fkey)
- Room (RoomID/Key, HotelID/FKey, type, date, isAvailiable, price, reservedNumber, aviailableNumber)
- RoomDescription(RoomID/FKey, type, list-price, info)
RoomType(RoomID/FKey, name)
Payment 用例
Payment用例数据建模
- paymentItem(paymentItemID/Key, paymentID/FKey, cost)
- payment(paymentID/Key, credictCardID/FKey, date, totalCost)
- credictCard(credictCardID/Key, CustomerID/FKey, id, bank)
- Customer (CustomerID/Key, name, address, postCode, telephone)
使用 UML State Model,对每个订单对象生命周期建模
这篇关于系统分析与设计第六次作业的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!