Hi there

Im currently doing a project trying to research a soccer database and at the moment I am working on drawing up an ERD.

I have only a little experience in database design and was wondering if anyone would be willing to look over the ERD and suggest improvements.

I am having particular trouble in trying to represent the fact that a player could belong to two teams (one proper and one on loan), and also how the fixtures and results would be represented in terms of tables.

I have attached the ERD for anyone who wishes to view it.

If any more details are needed feel free to ask.

thanks in advance

there are two approaches

1. add a "role" attribute to the Team_Player table

pro: only one relationship table
con: must allow multiple rows per player, tricky to limit this to 2

2. leave Team_Player as proper, add separate Team_Player_Onloan relationship table

pro: PKs can be enforced
con: queries get trickier

Wait a minute. Did you say Football, or did you say Soccer? Make up your mind.

hi

thanks for your replys. I am talking about soccer, sorry I put football in the thread title but then realised that may mean american football to some of you!