Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

**Need help making ERD*** During a recent trip out west, you came to meet a small business owner who takes people on river trips. Currently

**Need help making ERD***

During a recent trip out west, you came to meet a small business owner who takes people on river trips. Currently they are using an Excel spreadsheet to keep track of the various trips they take. Below is a copy of the spreadsheet:

Trip Date People Client Name Address City State Prov Postal Code Country Phone River Trip Distance Trip Days Fee/ Person
7/1/2008 7 Heffernan, Al 388 Central Street Salt Lake City UT 84101 USA 801-509-1248 Arkansas River (Brown's Canyon) 22 1.00 75.00
8/1/2008 8 Fritz, Emma 397 Warren Avenue Denver CO 80210 USA 720-765-3932 Arkansas River (Brown's Canyon) 15 0.50 45.00
6/29/2008 4 Strzepek, Wanda 207 Fox Run Road Grand Junction CO 81502 USA 970-997-3004 Arkansas River (Parkdale) 10 0.50 40.00
7/10/2008 8 Robinson, Chris 964 School Street Lincoln NE 68501 USA 402-453-8007 Arkansas River (Parkdale) 10 0.50 40.00
8/1/2008 6 Boisvert, Daniel 9 Heywood Road Casper WY 82601 USA 307-742-1008 Arkansas River (Parkdale) 10 0.50 40.00
8/30/2008 7 Fritz, Emma 397 Warren Avenue Denver CO 80210 USA 720-765-3932 Arkansas River (Royal Gorge) 20 1.00 85.00
6/15/2008 2 Barry, Paul 1043 Main Street Denver CO 80210 USA 720-766-0113 Arkansas River (The Narrows) 25 1.00 145.00
7/21/2008 4 Durkin, Ann 80 Russell Blvd. Provo UT 84601 USA 801-519-3327 Arkansas River (The Narrows) 25 1.00 145.00
8/5/2008 10 Jeffries, Thomas 52 Winter Drive Hastings NE 68901 USA 402-456-0739 Arkansas River (The Narrows) 9 0.50 85.00
8/11/2008 6 Strzepek, Wanda 207 Fox Run Road Grand Junction CO 81502 USA 970-997-3004 Arkansas River (The Narrows) 9 0.50 85.00
7/22/2008 2 Glidden, Kerry 75 Princeton Circle Lincoln NE 68401 USA 402-452-8855 Arkansas River (The Numbers) 18 1.00 70.00
7/1/2008 3 Shaikh, Naimuddin 20 Church Street Fort Collins CO 80521 USA 970-923-1183 Clear Creek River 20 1.00 95.00
8/11/2008 5 Vanderaa, Janice 17 Half Moon Hill Douglas WY 82631 USA 307-745-0045 Clear Creek River 9 0.50 45.00
8/21/2008 2 Barry, Paul 1043 Main Street Denver CO 80210 USA 720-766-0113 Clear Creek River 20 1.00 95.00
7/20/2008 3 Pedicini, Susan 26 Concord Drive Kearney NE 68845 USA 308-456-1212 Colorado River (Glenwood Canyon) 18 1.00 80.00
7/5/2008 5 Chiang, Chung-Lin 4 Courthouse Lane Fort Collins CO 80521 USA 970-923-7754 Colorado River (Little Gore Canyon) 23 2.00 225.00
8/22/2008 7 Myszewski, Kathy 19 Woodridge Lane Denver CO 80201 USA 303-764-2503 Colorado River (Little Gore Canyon) 25 3.00 360.00
7/12/2008 4 Lopez, Maria 92 Hunt Road Salt Lake City UT 84111 USA 801-509-2640 Colorado River (Westwater Canyon) 17 2.00 180.00
6/3/2008 7 Forsythe, Dianne 460 Griffin Blvd. Boulder CO 80301 USA 720-331-8176 South Platte River 18 1.00 75.00
7/30/2008 5 Student Name 975 Bonnet Circle Denver CO 80201 USA 303-764-9174 South Platte River 18 1.00 75.00

In putting together your draft diagram, you have assumed the following:

Many people can go on many trips

A Trip must have at least one customer on it.

Every trip must have at least one employee on it.

Every trip must include at least one boat and two oars.

Every trip can have multiple pieces of equipment on it.

Every trip can have many employees on it.

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

blur-text-image

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

Database And Expert Systems Applications 33rd International Conference Dexa 2022 Vienna Austria August 22 24 2022 Proceedings Part 1 Lncs 13426

Authors: Christine Strauss ,Alfredo Cuzzocrea ,Gabriele Kotsis ,A Min Tjoa ,Ismail Khalil

1st Edition

3031124227, 978-3031124228

More Books

Students also viewed these Databases questions