系统分析与设计第九周作业

一、
1.make reservation领域建模

Customer(ID/Key,FullName,Email)

Reservation(ID/Key,CustomerID/Fkey,HotelID/Fkey,RoomType,RoomID/Fkey,CheckInDate,CheckOutDate)

Room(ID/Key,Availability,Price,Type,Info)

Hotel(ID/Key,Name,City,RoomID/Fkey,Info)

Property(Favourity,LowestPrice,HighestStarRating,AlphabeticallyListing/Key)

2.payment领域建模

Payment (ID/Key, Date, Time, amount)
PaymentItem (ID/Key, PaymentID/FKey, PaymentDetails)
CreditCard (ID/Key, CustomerID/FKey, Type,PaymentDetails)
CreditCardDetail (ID/Key, CreditCardID/FKey, Number, SecurityCode, ExpiryDate)
PaymentDetail (ID/Key, PaymentItemID/FKey, firstName,lastName, Address, City, State)
Custermer(ID/Key,name,email)

二、生命周期建模