- #1
- 6,910
- 10,291
Hi again, say we are given the relational table:
TEAM(TeamID, TeamName, TeamColor, Game, DatePlayed).
Question is: how many games can we play, meaning, while preserving the properties of relational tables?
This is what I have.We know
We know TeamID, TeamName andTeamColor are fixed in any row , while Game and DatePlayed are variable. All tables will be of this type 1 N1 C1 G_11 D_11
2 N2 C2 G_21 D_21
........
1 N1 C1 G_{1j} D_ {1j}
......
Now, while this is not stated, I would assume either of TeamID, TeamName are candidate keys; two teams
may have the same color. Obviously, we have at least two teams.
TEAM(TeamID, TeamName, TeamColor, Game, DatePlayed).
Question is: how many games can we play, meaning, while preserving the properties of relational tables?
This is what I have.We know
We know TeamID, TeamName andTeamColor are fixed in any row , while Game and DatePlayed are variable. All tables will be of this type 1 N1 C1 G_11 D_11
2 N2 C2 G_21 D_21
........
1 N1 C1 G_{1j} D_ {1j}
......
Now, while this is not stated, I would assume either of TeamID, TeamName are candidate keys; two teams
may have the same color. Obviously, we have at least two teams.