Don't really understand Basketball and I have to do an ERD .
Can someone tell me how to link the 'manager', 'coaches' and 'club' tables.
e.g. would it be one manager has MANY coaches to manage.
e.g. One club has MANY Coaches.
Don't get it.
Also I have these following tables 'Players', 'Team', 'Season' and 'Match'
What I don't understand is the 'Match' table.... because the specification says we have to keep information of the performance of each player and include the number of: 2 points attempts, 2 points made, 3 points attempts, 3 points made, free throws attempts, free throws made, minutes played, fouls made, rebounds.
I dont understand these scorings, as in what is '2 points made' and 'attempts' etc. would they be fields in the table of 'Matches' AND the 'Player'. I have researched on BASKETBALL ERDs and they MADE a 'Home' and 'Away' tables.
What is Home and AWAY tables, what fields would you add.
And what about the season table. How many seasons is there?. What fields would I put. Season name, season start date, season end date, Match ID, Location.
I don't know.
Can please someone help with my Basketball ERD database.