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