Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Outdoor Experiences books white water rafting trips for corporate clients. They have 5 trips that they offer. For each of the trips they record the

Outdoor Experiences books white water rafting trips for corporate clients. They have 5 trips that they offer. For each of the trips they record the name of the river that the trip will take place on, the distance of the trips in miles, and the number of days the trip will take, along with the per person fee for the trip. They keep track of their client names, address, and day and evening phone numbers. Their clients are corporations that book annual trips for their employees. Some of the corporations have a separate billing name and billing address, which they would like to capture and keep track of separately. Trips can include lots of different clients. Outdoor Experiences keeps track of all trips a client has taken, including the start date and end date, along with the number of people who participated in the trip and the registration fee. Clients pay a registration fee depending on what type of trip and how many people will participate in the trip. Make the ERD for the problem above.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Accounting

Authors: Peter Scott

2nd Edition

0198849966, 978-0198849964

More Books

Students also viewed these Accounting questions