| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Lazy summer project: build a basketball app.
> Team <division, conference, college, a shorthand name, city, state>
> Game <Game_id (pk), Date>
> TourneyGame <Game_id (pk - fk on Game.Game_id), Tournament_name,
> round_number>
> NonTourneyGame <Game_id (pk - fk on Game.Game_id)>
> TourneyOpponent <Game_id (pk - fk on TourneyGame.game_id), Team_fk
> (pk), Points_Scored>
> NonTourneyOppenent <Game_id (pk - fk on NonTourneyGame.game_id),
> Team_fk (pk), Home_Away_Ind, Points_scored>
Team <division, conference, college, a shorthand name, city, state> Game <Game_id (pk), Date, Opponent1 (fk to team), Opponent2 (fk to team), isTurnament> Received on Thu Jun 29 2006 - 13:45:09 CDT
![]() |
![]() |