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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment