Using MySQL Workbench – create a data model for on Adult Baseball league which s

Question

Using MySQL Workbench – create a data model for on Adult Baseball league which supports all of the following data requirements: Teams A team has a unique number associated with it Team Name Team City Each team has more than one player associated with it Players Each Player has a unique number A player may play or have played for more than one team The number of years and batting average is tracked for each team the player played for. Coaches In this league, all coaches are also players. A Team can have more than one coach. Bats A team can have multiple bats Each bat is identified by a unique serial number.

Explanation / Answer

Teams
    A team has a unique number associated with it
    Team Name
    Team City
    Each team has more than one player associated with it

Players
    Each Player has a unique number
    A player may play or have played for more than one team
    The number of years and batting average is tracked for each team the player played for.

Coaches
    In this league, all coaches are also players.
    A Team can have more than one coach.

Bats
    A team can have multiple bats
    Each bat is identified by a unique serial number

Create table like bleow

Team (Team_Num, Team_Name, Team_City, no_players)
Player( Player_num, Player_name, team_name1, Team_name2)
batTrack( Team_num, Player_num, player_name,no_years)
coaches (coach_num, coach_name, team_asso)
bat( bat_num, bat_name, used_team);

Team, Player, batTrack, coaches, bat are the tables and the these are the attributes.

in the team table Team_num is iedntified as a Primary key

in the player table Player _num is identified as a Primary key

in the coaches table Coach_num is is iedntified as a Primary key

in the bat table bat_num is is iedntified as a Primary key

we join these table by using relations and jooin based on the requirement.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.