Need Help with Assessment Task (1 Viewer)

[xNinjax]

My task is to "Develop a relational database information system on a sport of your choice". i choose Soccer

How can specific fields be related (and what are primary keys)?? Stuck on this..need help. Examples would be great >.<

 

[Lwaxana]

tbl_Player
Player_id text or auto number eg 20020001 primary key
Surname
First_Name
DOB
address
etc....

tbl_team
team_name eg 18A primary key
player_id foreign key (eg links to player_id in tbl_player)
coach_id
manager_id
training_day