Does This Schema Look Normalized To 3NF? Need Help With Class Project.

MATCH(MatchID, Season, MatchDate, MatchStartTime, Field#, Park, HomeTeamID, AwayTeamID, RefereeName, MatchScore)

FIELD(Field#, Park, FieldName)

PLAYER(PlayerID, JerseyNumber, PlayerFirstName, PlayerLastName, PlayerGender, PlayerAge, TeamID, Position, CaptainStatus)

PLAYERSTATS(MatchID, PlayerID, MatchDate, MatchStartTime, HomeTeamName, AwayTeamName, JerseyNumber, PlayerName, Goals, Assists, PossessionPercent, PassCount, PassingChain#)

TEAM(TeamID, TeamName, CoachID, AssistantCoachID, SponsorID)

COACH(CoachID, CoachFirstName, CoachLastName, TeamID, CoachAge, CoachGender, CoachRole)

SPONSOR(SponsorID, SponsorName, SponsorEmail, SponsorAddress)

submitted by /u/volkxx
[link] [comments]

Leave a Reply

Your email address will not be published. Required fields are marked *