Answered step by step
Verified Expert Solution
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
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 tripStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started