Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw the ERD for the Problem Outdoor Experiences Normalization Proble m Outdoor Experiences books white water raftng trips for corporate clients. They have 5 trips

image text in transcribed

Draw the ERD for the Problem

Outdoor Experiences Normalization Proble m Outdoor Experiences books white water raftng 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. Outdoor Experiences Normalization Proble m Outdoor Experiences books white water raftng 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

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_step_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Accounting questions

Question

Did you provide headings that offer structure to the information?

Answered: 1 week ago