Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Posts
    10

    Unanswered: Database Design Question

    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?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Yes. It is a matter of inheritance...just like you have genes from your grandfather
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    May 2007
    Posts
    10
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •