Question: PlayerDetails { playerlD , name, [ phoneNumber ] , emailAddress } Teams { teamID , clubID, ageGroup, division, playingSeason, year } PlayerRegistration { playerID ,

PlayerDetails {playerlD, name, [phoneNumber], emailAddress}
Teams {teamID, clubID, ageGroup, division, playingSeason, year}
PlayerRegistration {playerID, team|D}
Games {gamelD, date, kickOffTime, homeTeamID, awayTeamID}
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
Use this rMap to select the most accurate datatype for the following attributes:
homeTeamID: Get the data type
PlayingSeason: get the data type
clubID: get data type
 PlayerDetails {playerlD, 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!