Use E-R Diagram You are hired by an Adventure Travel company to create a databas

Question

Use E-R Diagram

You are hired by an Adventure Travel company to create a database. The database should store the following information

For all customers, we keep track of their name, email, home phone, work phone, cell phone, date of birth, and address.

For all guides, we keep track of their name, email, home phone, cell phone, date of birth, social security number, hire date, and address.

We also keep track of all languages that a guide knows, and the proficiency that guide has in that language. Assume that guides know at least one language.

We also keep track of how well our guides get along with each other. Each guide has a compatibility score for every other guide.

We have a number of trips that we sponsor. For each trip, we keep track of the name, the cost, the length of days, and the country.

For each trip, we keep track of the instances of that trip. For each instance, we keep track of the start date and the end date.

We keep track of which customers have signed up for which trip instance. A customer can sign up for many trip instances. We keep track of whether the customer has paid for that trip yet.

We keep track of which guides have been hired for each trip instance. A guide can be hired for many trip instances and a trip instance can have many guides. We keep track of how much a guide has been paid for each trip instance that they do.

Explanation / Answer

Database will have following entities with attributes enlisted below eacah entity:

1 Entity: Customer

Attributes:

Entity 2: Guides

Entity 3: Trip

Entity 4: Instance of trip

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.