Hi! I'm doing my first database project! It's a database about a basketball championship. In this thread I'll tell you my thougths about how to build it, step by step, but I'll need your help, because I'm a beginner!
I'm back! I've been confused a little bit! What do you suggest? I did these 1-1 relationships because I was thinking that if I have to add a coach, then the <points>, <games> ... fields are going to be filled with NULL value. That's the way I was thinking! What do you say?
I like this approach. Blindman will prefer the nulls I suspect. I would say, however, that some of the attributes you have against players might well be derived from tables you use to model the games that are played.
Hi! The image I've uploaded shows what I've done so far. I want to add the points/rebounds/steals etc but I've stuck!!! I don't know where to add them? I was thinking to add a N:M relationship (players-game), so I'd add them in the table that will be created. So let's say that I want the total points for a team, I'd select the sum of the points that every player has scored. But if one player of the team move to another team, I'll have problem! Another thing that I was thinking is to add the points in the "Team_has_Game" table, but I will not know the individual stats for every player. What do you suggest?