Posted By:
Liza_Mazza
Posted On:
Wednesday, August 25, 2004 10:06 AM
I created the following tables: Club : ClubCode, ClubName Player : PlayerID, PlayerName, Address MatchResults : Date, HomeClubCode, AwayClubCode, HomeGoals, AwayGoals Register : PlayerID, ClubCode Transfer : PlayerID, PlayerName, OriginalClub, NewClub, TransferDate PlayerStats : PlayerID, GoalsScored, PositionPlayed Can someone please let me know if i create this tables if they will be correct, without any gaps or anything. and if something is missing please let me know. Any help really appreciated. Thanks 1) MatchResults has no PK? 2) Register table can have only these 2 fore
More>>
I created the following tables:
Club
: ClubCode, ClubName
Player
: PlayerID, PlayerName, Address
MatchResults
: Date, HomeClubCode, AwayClubCode, HomeGoals, AwayGoals
Register
: PlayerID, ClubCode
Transfer
: PlayerID, PlayerName, OriginalClub, NewClub, TransferDate
PlayerStats
: PlayerID, GoalsScored, PositionPlayed
Can someone please let me know if i create this tables if they will be correct,
without any gaps or anything. and if something is missing please let me know.
Any help really appreciated. Thanks
1)
MatchResults has no PK?
2)
Register table can have only these 2 foreign keys(composite key?).
3)
Transfer table has as PK PlayerID and TransferDate???
4)
PlayerStats has FK PlayerID??
<<Less
