create an ER diagram in Dia to keep track of sports teams, athletes, and coaches at a local high school (you do not actually have to create the database). As I described in the video, ER diagrams generally do not include field names, but it can be very helpful to have an idea of what kind of data will be stored in the database before you create your ER Diagram. The field names in the following list are provided for your reference.

For students, we will keep track of student ID, name, phone, email, and mailing address.

For each team, we will keep track of the name of the sport, the year the team was established, and whether the team is varsity, JV, or intramural.

For each coach, we will keep track of SSN, name, phone, email, mailing address, and whether they are head coach, co-coach, or assistant coach.

We will (of course) keep track of which students are on which team, and which coach (or coaches) are assigned to each team. Use the techniques I described in the video to break up any many-to-many relationships.

Base your diagram on the following business rules:

A student can be on as few as zero teams, up to any number of teams.

A coach may coach many sports, but would not be included in this database unless he/she coaches at least one team.

A team may have no students on it, up to any number of students (this allows us to include teams in the database prior to tryouts).

A team may have no coach assigned to it, up to any number of coaches.

A coach cannot be a team member, and a team member cannot be a coach.