Access homework, due December 9th at 23:59

You need to design a database to manage a travel agency.

1. Create the following tables:

TourGuides:

Last name, First name, Birthdate

Travelers:

Last name, First name, Address, ... other personal information

ToursOffered:

DepartureLocation, ArrivalLocation, Duration, Description

Locations:

Name, Description, Weather

Vans:

Model, Color, Capacity

TripsScheduled:

A trip scheduled is a TourOffered scheduled for a specific time and assigned to a TourGuide and a van and offered at a specific price. So the fields should include:

TourOffered, TourGuide, Van, Price, TimeDeparture.

TravelersInTrips:

This table relates travelers and scheduled trips. It should also include how much the user has paid already, and in what format (credit card, cash, debit card, etc).

- Please remember that all tables should include primary keys (IDs), when it makes sense, you can use IDs that appear in the real world (license plates for the van). The rest of the time, let Access generate one for you.

2. Create the following relationships:

- ToursOffered with Location (twice, for Departure and Arrival).
- TripsScheduled with ToursOffered, Vans and TourGuide.
- TravelersInTrips with Travelers, TripsScheduled.

3. Create nice looking forms to enter data for each of the following:

- Tour guide.
- Travelers.
- Tour offered (sub form: departure and arrival location).
- Trips scheduled (sub forms: van, maybe: ToursOffered and TourGuide).
- Travelers in Trips (sub forms: travelers, maybe: trips scheduled)

(more to be posted on the weekend)