系分 | 第七周作业

领域建模

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)

---