Question: 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

 Draw the ERD for the Problem Outdoor Experiences Normalization Proble m

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!