You are to assume the role of a database analyst that has been assigned to develop an entity$-$relationship diagram $($ERD$)$ for a neighborhood swim team league. Each swim team is made up of a large number of swimmers. For each swimmer they want to know the swimmers name, address, phone number, email, and date of birth. Each swimmer can be a member of only one team. Each team also has one captain.

The team competes in meets many times during the season. Meet information includes date, location and type of meet. Many teams can compete at each meet. For instance on Saturday June $17$th Hunters Green, Arbor Green, Meadow Pointe and Brookfield competed at the Hunters Green Fathers Day Swim meet.

A meet consists of a variety of events $($e$.$g$.,800$ freestyle, $400$ freestyle, $800$ fly, $800$ medley, etc.$).$ A swimmer can compete in all or some of these events, though the team is limited to $5$ participants in each event $($not all rules can be represented in ERD, this is one of them$).$ However, swimmers can only compete in events for which they are prepared $($you want to track who is prepared for what events$).$

The key part of this database is to track individual times, individual places, individual points, and team points. See the attached score sheet from a meet to understand the type of data you need to collect. For each event a swimmer competes in they receive a time, and a point amount $($e$.$g$.$ first place $=5$ points, second place $=4$ points, etc.$).$ To determine which team wins the meet individual points are summed. The team with the most points wins the match.

Scores for : Hunter$$s Green Match: Fathers Day Invitational Swim Meet

Match Date: June $17$th$,2021$ Match Location: Hunter$$s Green

Swimmer

Event

Time

Place

Points

Wendy Margolos

$800$ Freestyle

$5$ min $24$ sec

$2$

$4$

Jane Fedor

$400$ Freestyle

$2$ min $5$ sec

$1$

$5$

Judy Rolls

$400$ Freestyle

$3$ min $15$ sec

$14$

$0$

Wendy Margolos

$400$ Freestyle

$2$ min $30$ sec

$5$

$1$

Jane Fedor

$800$ Back

$6$ min $28$ sec

$3$

$3$

Karin Lacopo

$800$ Back

$6$ min $20$ sec

$2$

$4$

Total points : $16$

Scores for : Arbor Green Match: Fathers Day Invitational Swim Meet

Match Date: June $17$th$,2021$ Match Location: Hunter$$s Green

Swimmer

Event

Time

Place

Points

Wendy Smith

$800$ Medley

$4$ min $44$ sec

$3$

$3$

John Hunter

$400$ Back

$2$ min $35$ sec

$2$

$4$

Joe Ortiz

$400$ Backstroke

$3$ min $55$ sec

$14$

$0$

Wendy Smith

$400$ Freestyle

$2$ min $10$ sec

$3$

$3$

John Smith

$400$ Fly

$1$ min $55$ sec

$1$

$5$

Hunter Cole

$400$ Fly

$2$ min $40$ sec

$8$

$0$

Total points : $15$

The attributes given are meant to help you understand the scenario. Don$$t include them on your ERD. If a relationship is many to many $($M:N$),$ introduce a bridge entity to break it into two $1$:M relationships. Your database design must consists of $8$ entities and $12$ relationships.