Travel Agency
| Customer | Booking | Hotel | Resort |
customerNo PK firstname surname address town postcode |
hotelRef PK FK customerNo PK FK startDate PK numberOfNights numberInParty |
hotelRef PK hotelName resortID FK starRating seasonStartDate mealPlan checkInTime pricePersonNight |
resortID PK resortName resortType |
GoGo Gadgets:
| Customer | CustOrder | OrderItem | Item |
| CustomerID PK Forename Surname Address1 Address2 Address3 Postcode CustomerEmail |
OrdernNo PK CustomerID FK OrderDae OrderDispatched |
OrderNo PK FK ItemID * PK Quantity |
ItemID PK Description Category Price |
