Due in 8 hours

COACH PLAYER CITY TEAM GAME TEAM_MATCH COACH_NUM int FK PK COACH_FNAME int FK PK COACH_LNAME int FK PK PLAYER_NUM int FK PK PLAYER_FNAME int FK PK PLAYER_LNAME int FK PK CITY_NUM int FK PK CITY_NAME int FK PK CITY_STATE int FK PK TEAM_NUM int FK PK TEAM_NAME int FK PK GAME_NUM int FK PK GAME_DESCRIPTION int FK PK PLAYER_ADDRESS int FK PK PLAYER_PHONE int FK PK COACH_ADDRESS int FK PK COACH_PHONE int FK PK TEAM_NUM int FK PK TEAM_NUM int FK PK CITY_NUM int FK PK TEAM_NUM int FK PK MATCH_HOME_TEAM int FK PK MATCH_AWAY_TEAM int FK PK GAME_NUM int FK PK MATCH_DATE int FK PK has M1 M2 M3 M4 has M1 M2 M3 M4 has M1 M2 M3 M4 has M1 M2 M3 M4 M1 M2 M3 M4 MATCH_HOME_SCORE int FK PK MATCH_AWAY_SCORE int FK PK