I have the following:
League has one or many Conferences
Conference has one or many Divisions
Division has one or many Teams
From a proper database design perspective, is it ok to store the LeagueID in the Teams table?Yes. It is a matter of inheritance...just like you have genes from your grandfather|||Thanks...it makes it easier to get the league for a team that way instead of having to have joins to the conference and division tables in the query
Showing posts with label teamsfrom. Show all posts
Showing posts with label teamsfrom. Show all posts
Saturday, February 25, 2012
Subscribe to:
Posts (Atom)