Data Model ~ Tour Agency...
A simple starter Data Model for a Tour Agency. To download the Data Model click here.
The difficult I do immediately, the impossible takes a little bit longer.
Business Rules...
Hotels will have more then one Rate based on Season
Hotels will have different Amenities
Customers go on Tours
Tours may be to one or more Destination (Countries)
Destinations may involve one or more Hotels
Main Entities...
Tours
Data Models
Customers
Destinations (Hotels)