CREATE ERD DIAGRAM$--$ Narrative$/$Requirements for a Swim Team Database Each swim team is made up of at least $10$ swimmers. For each swimmer, database should include a swimmer$$s social security number $($SSN$),$ name, address, phone number, email, and date of birth. Each swimmer can have a swimmertype, categorized into TrainerLevel or NormalLevel. But there are some swimmers who do not belong to any of the two level groups. All TrainerLevel swimmers must have a training license which has a unique training license id$,$ issue date, and expire date. NormalLevel swimmers don$$t have a training license and should have a guardian name. Each swimmer must be a member of only one team. Each team also has a unique name, address, phone number, and one captain $($out of its many swimmers$).$ Teams participate in swim meets many times during the season. A swim meet is a large gathering of athletes for a swimming competition. Meet information includes a unique id$,$ name, date, location and type of meet. Many teams can compete at each meet. For instance on Saturday June $17$th$,$ teams Hunters Green, Arbor Green, Meadow Pointe and Brookfield competed in the Fathers Day International Swim Meet at Hunter$$s Green $($see below two figures of meet results$).$ A meet consists of a variety of events $($e$.$g$.,800$ freestyle, $400$ freestyle, $800$ back$($stroke$),800($butter$)$fly$,800$ medley, etc.$).$ An event has a unique ID and its description. Any swimmer can compete in multiple events, although the team is limited to $5$ participants in each event. Also, swimmers can only compete in events for which they are qualified $($Database needs to track who is qualified for what events $$ qualified or not$).$ The key part of this database is to track each swimmer$$s performance which includes times, places, and points. See the below score sheets, one for each team from a meet that helps you understand the data you need to design into ERD. For each event in which multiple swimmers compete, each swimmer gets a time, a place and points $($e$.$g$.$ first place $=5$ points, second place $=4$ points, etc.$).$ To determine which team wins the meet individual swimmers points are summed for each team. The team with the highest points wins the match.$$