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.
Don't really understand Basketball and I have to do an ERD .
Can you post the query for your database to see what you have done so far?
abzy, you saying so many times in your post that you dont understand basket ball, before designing ERD you need to learn all things (rules,scoring method,people involved) about basketball, otherwise your ERD will surely go wrong, if you build it on scattered tips received here.