Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
GolfingTea
Starting Member
1 Post |
 Posted - 2005-03-17 : 10:38:34
|
| Hi everyone, I’m attempting to setup a database for my little snooker club and was wondering if anyone could help me determine which attributes are the keys for this relationship? I really want to make sure all the keys are right before I start normalisation...Note: coachId and coachName are membership no and last name of the coaching player whereas PlayerId, PlayerName, and playerRanking are the number, last name and ranking position of the person being coached.Table:Coaches(coachId, CoachName, PlayerID, PlayerName, PlayerRanking, StartDate, EndDate, TourID, TourName)Heres full dependences Ive come up with…{PlayerId, StartDate, EndDate} > coachedPlayerId > {PlayerName, PlayerRanking }{PlayerId, TourId } > coachId{PlayerId, TourId } > coachName{PlayerId, StartDate, EndDate} > coachNameTourID > TourNameCoachId > CoachName{ PlayerId, TournID } > StartDate{ PlayerId TourID }> EndDateAny help is much appretiated :) Cheers Guys,GolfingTea. |
|
|
|
|
|
|
|
Which are the keys within my table?