ion 11/17 I 100% Great Times Summer Camp Great Times needs a DBMS for their summer camp program to keep track of the trips, persons picking up the campers, contact information, trip information, and date. The table presented below shows sample data needed by Penny Creek. Identify attribute types with redundancies and develop an efficient DBMS with a query producing the following table using ACCESS. Camper Camper Name Camper Address Pickup Pickup Naine Pickup Phone Locations Location Contact Trip Date Kathy Kelly 10 Main St. 22 Mary Kelly 1111 1111 Zoo Mr. Keeper 3/10/2010 3 Sam Jones 60 State Rd. 33 Jeff Jonas 3333 222 Bowling Ms. Lane 3/20/2010 1 Kathy Kelly 10 Main St 11 Jim Kelly 1111 222 Bowling Ms. Lane 3/20/2010 2 Kathy Kelly 10 Main St. 11 Jim Kelly 1111 333 Dorney Park Mr. Wetguy 3/5/2010 2 Randy Kelly 10 Main St 22 Mary Kelly 1111 111 Zoo Mr. Keeper 3/10/2010 2 Randy Kelly 10 Main St. 11 Jim Kelly 1111 333 Dorney Park Mr. Slide 3/5/2010 5 Mira Davis 50 Row St. 33 Jeff Jones 3333 111 Zoo Mr. Keeper 3/15/2010 3 Sam Jones 60 State Rd. 33 Jeff Jones 3333 111 Zoo Mr. Keeper 3/15/2010 4 Jos Kane 30 Jungle Ave 44 Cindy Kane 4444 222 Bowling Mr. Pin 3/20/2010 5 Mira Davis 50 Row St. 33 Jeff Jones 3333 111 Zoo Mr. Keeper 3/25/2010 3/5