系分 平时作业九
1. Make Reservation
- 领域建模
- 数据建模
Location(name, locCode/Key )
Hotel( ID/Key , name, stars, address, locCode/FKey , briefIntr)
Reservation(ID/key, date, time, checkInDate, numberOfNights)
ReservationItem(ID/key, type, date, time, checkInDate, numberOfNights, numberOfAdults, numberOfChildren, AgeOfChild)
Traveler(IDNum/Key, name ,phoneNumber)
Room(roomID/key, type, date, isReserver)
RoomDiscription(disID/key,roomID/Fkey,type,totals,listPrice,description)
2. Payment
- 领域建模
- 数据建模
Traveler(IDNum/Key, name ,phoneNumber)
CreditCard (number/Key,IDNum/FKey,securityCode,expiryDate)
Payment(paymentID/Key,IDNum/FKey,date,time…)
PaymentItem(itemId/Key,information…)