Terps Tour Inc. Terps Tours, Inc., is a local travel agency. A database is required to keep track of all tour guides, trips and customers. Every guide has a unique identifier assigned by the agency and is required to store name (consists of first and last names), address, one-to-three phone numbers and the hire date. An address is recorded as street, city, state abbreviation and zip code. The agency operates approximate 50 different trips. Each trip is assigned with a unique identifier together with a name, start location, state abbreviation, distance, maximum group size, trip type and season. One or more guides tour each trip. Each guide may tour any number of trips. A customer provides first and last names, address, one phone number and an email address. Similarly, an address is recorded as street, city, state abbreviation and zip code. Every customer is assigned a unique customer identifier. When a customer books a trip, a reservation record is created. Each trip may be booked by any number of customers. Each customer can book one or more trips by specifying trip date, number of persons, total trip price and other fees on each reservation.

Note: ER diagram should not include any FK. Your final drawing should not include any entity or relationship other than what were described in the above business requirements. State any assumption that you believe you would need to make on the structure constraints in order to develop a complete model.