Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2014

    statistics database design

    Hello all. I've been looking through this forum for a few days and finally decided to post. The design that I am working with is more of a hobby than a project, but find that the more I work with it, the more questions arise. Here's what I have:

    Sports Database

    Many Sports
    Sports can have many Leagues/Conferences
    Leagues/Conferences have many Divisions
    Divisons have many Teams
    Teams have many Players
    Players have Statistics
    Players can play many Sports (Bo Jackson with baseball & football)

    I suppose my question really centers around Identifying vs Non-Identifying Relationships.

    For example, let's take Major League Baseball.
    Houston was in the National League and then changed to the American League a few years ago.

    With Identifying Relationships my primary key for Houston would be:

    I'm just confused on how changing Houston's League would cause an issue in say...searching for total home runs the National League hit in the last ten years...would that include the home runs Houston hit while they were in the National League, since they switched to the American League two years ago?

    Thanks in advance for your input.


  2. #2
    Join Date
    Nov 2015
    United States Of America New York

    Red face

    Try with database configuration and most probably search at the world wide web.
    Last edited by Messilionel; 11-12-15 at 01:10.

Posting Permissions

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