系分 | 第七周作业

最新推荐文章于 2025-03-27 00:01:48 发布

原创最新推荐文章于 2025-03-27 00:01:48 发布 · 225 阅读

0 ·

CC 4.0 BY-SA版权

系统分析与设计专栏收录该内容

43 篇文章

订阅专栏

博客主要围绕酒店预订场景展开，包含领域建模和数据建模两部分。领域建模涉及预订和支付环节；数据建模给出了多个数据表结构，如Location、Hotel、Room等，涵盖酒店、房间、旅客、预订、支付等相关信息。

在这里插入图片描述

领域建模

make reservation

在这里插入图片描述

payment

在这里插入图片描述

数据建模

Location(LocationID/Key,HotelID/FKey,name）
Hotel(HotelID/Key,LocationID/FKey,name,address,star,locCode,briefIntro,isFavourites,isLowestPrice,isRating,isMaxDiscountOff)
Room(RoomID/Key,HotelID/FKey,type,date,reserved,reservedNumber,totalNumber,isAvailable,price)
RoomDescription(RoomID/FKey,type,total,listPrice,totalNumber,description)
RoomCatalog(RoomID/FKey,type)
Traveller(TravellerID/Key,fullName,emailAdress)
Reservation(ReservationID/Key,TravellerID/FKey,HotelID/FKey,checkInDate,checkOutDate,totalCost)
ReservationItem(ReservationItemID/Key,ReservationID/FKey,RoomID/FKey,numberOfAdults,numberOfChildren,childAge,smoking,specialRequirements,price)
Payment(Payment/Key,ReservationID/FKey,total)
CreditCard(CreditCard/Key,Payment/FKey,ReservationItemID/FKey,Cardholder/FKey,type,cardNumber,cardSecurityCode)
Cardholder(Cardholder/Key,title,firstName,lastName,daytimeTelephone,eveningTelephone)
Addressdetail(Cardholder/FKey,address1,address2,city,countryOrState,postCode)

在这里插入图片描述