Homework 6

Homework 6

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

• 注意事项：
  • 对象必须是名词、特别是技术名词、报表、描述类的处理；
  • 关联必须有多重性、部分有名称与导航方向
  • 属性要注意计算字段
• 数据建模，为了简化描述仅需要给出表清单，例如：
  • Hotel（ID/Key，Name，LoctionID/Fkey，Address……）

① Make reservation

• Hotel (ID/Pkey, Name, LoctionID/Fkey, Address)
• Location (ID/Pkey, Name)
• Customer (ID/Pkey, Full name, Email address)
• Reservation (ID/Pkey, HotelID/Fkey, CustomerID/Fkey, Check in date, Number of nights, Required rooms, Number of adults, Number of children)
• Shopping basket (ID/Pkey)
• Room (ID/Pkey, Type, Date, Number of adults, Number of children, Age from …)
• Room Description (ID/Pkey, RoomID/Fkey, Type, List-price, Info)
• Room Type (ID/Pkey, Name)

② Payment

• Shopping basket (ID/Pkey)
• Reservation (ID/Pkey, HotelID/Fkey, CustomerID/Fkey, Check in date, Number of nights, Required rooms, Number of adults, Number of children)
• Credit card (ID/Pkey, Card Number, Card security code, Expiry date, Type)
• Cardholder’s detail (ID/Pkey, Credit card ID/Fkey, First name, Last name, Address1, Address2, City, Country/state, Country, Postcode, Daytime telephone, Evening telephone)

2、使用 UML State Model，对每个订单对象生命周期建模

• 建模对象： 参考 Asg_RH 文档， 对 Reservation/Order 对象建模。

• 建模要求： 参考练习不能提供足够信息帮助你对订单对象建模，请参考现在 定旅馆 的旅游网站，尽可能分析围绕订单发生的各种情况，直到订单通过销售事件（柜台销售）结束订单。