Create a set of tables and erd
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

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
About | Sitemap | Contact