1,105,340 Community Members

Database ERD design

Member Avatar
abzy1991
Newbie Poster
9 posts since Feb 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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.

Thank you

LastMitch
Deleted Member
 
0
 

@abzy1991

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?

I'm not a basketball fan either.

Member Avatar
pritaeas
mod_pritaeas
11,290 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

Can you post the query for your database

He has to make an ERD, so there is no database/query yet, just a diagram. But he must be able to show that...

LastMitch
Deleted Member
 
0
 

He has to make an ERD, so there is no database/query yet, just a diagram. But he must be able to show that.

So it's kinda like blueprint of how the structure of the database.

Member Avatar
urtrivedi
Posting Virtuoso
1,897 posts since Dec 2008
Reputation Points: 249 [?]
Q&As Helped to Solve: 408 [?]
Skill Endorsements: 27 [?]
 
0
 

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.

Member Avatar
pritaeas
mod_pritaeas
11,290 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

So it's kinda like blueprint of how the structure of the database.

Correct, it's what you should create before actually building a database, like the blueprint of a house (you don't just start building).

Member Avatar
abzy1991
Newbie Poster
9 posts since Feb 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Thank you for the advice, need to learn the basics of Basketball before going ahead with the ERD

Question Answered as of 1 Year Ago by pritaeas, LastMitch and urtrivedi
aaa001
Newbie Poster
1 post since Feb 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
Unverified Member
 
0
 

Do your coursework by ueslef..lol

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article