Question: PlayerDetails { playerID , name, [ phoneNumber ] , emailAddress } Teams { teamID , clubID, ageGroup, division, playingSeason, vear } Clubs { club D

PlayerDetails {playerID, name, [phoneNumber], emailAddress}
Teams {teamID, clubID, ageGroup, division, playingSeason, vear}
Clubs {clubD, clubName, clubAddress, clubPhoneNumberm [clubPresidentName]}
PlayerRegistration {playerID, team 1D
Games {gamelD, date, kickOffTime, homeTeamID, awayTamID}
Goals {playerID, gamelD, timeOfGoal}
GamePlayers {plaverID, gamelD }
Playing season is either summer or winter
PlayerID is an autoincrementing number with 10 digits
ClubID is a mix of numbers of letters
TeamID is an autoincrementing number
 PlayerDetails {playerID, name, [phoneNumber], emailAddress} Teams {teamID, clubID, ageGroup, division, playingSeason,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!