TravelAgency DB Schema

Traveller(name, ssn, dob)

Passport(number, country, expirationDate, holderName)

Trip(id, startLocation, endLocation, startDate, endDate)

Leg(location, startDate, endDate) Problem Description

Each traveler has a name, ssn, and date of birth.

Each passport has a number, the holders name, issuing country, and expiration date.

A passport is owned by at most one traveler.

One or more travelers go on one or more trips.

Trips include a unique id, starting location, ending location, start date, and end date.

Legs consist of a location, start date, and end date.

Trips are formed by one or more legs. Each leg must be a part of some trip. 1. Our TravelAgency DB will begin with the Schema and Problem Description given. Identify the relationships described in the Problem Description. Then, draw the ER Diagram that represents the entity sets and relationships.