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
Tips (Main)
Home
Templates
Restaurant Reservations
Property Management
DVD's
Jobs (or Work Orders)
Complaints
Training with Attendance
Products (Shoes of Clothing)
Tasks
Publications
Clubs (or Associations)
Purchase Order with Inventory
Hotel Bookings
Real Estate
Recipes
Grocery List Maker
Recipes with Grocery List Maker
Inspections
Parking Lot
Appointments (i.e. Salon)
Damage Investigations
Call Center
Incidents
Training (with Cirriculum)
Calibration
Access Basics
Data Modeling 101
Utter Access - Design Strategies
Naming Conventions
Modeling Human Relationships
Customers
Destinations (Hotels)
This site uses cookies to collect data on usage. By continuing to browse this site you consent to this policy. Find out more here.