The Database
A hockey league with rinks, teams, and players:
- Rink (name, phone, capacity)
- Team (tname, city, color, wins, losses, tie, rname FK references Rink(name))
- Player (id, name, num, pos, tname, tcity, FK (tname, tcity) references Team (tname, city))
All relations are in BCNF
The only FDs are PK?all other fields
Constraint: All players with uniform number 9 must be goalies.