Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2016
    Posts
    1

    Database Design Help... !

    Hello everyone,

    I am trying to build a database in filemaker, but i am stuck on the design.

    I have a sports team and I want to collect some data for the team.
    I have multiple tables but I can't seem to connevt them the right way. I hope somebody can help me out...

    Tables :

    PLAYERS
    PlayerID [PK]
    FirstName [text]
    LastName [text]
    Team [text]

    TEAMS
    TeamID[PK]
    Division[text]
    TeamName[text]

    SCORES
    ScoresID[PK]
    Score1[number]
    Score2[number]
    Score3[number]

    Each player can only be in one team. Each player has several weeks of scoring.


    Can anyone tell me how to relate the tables?

    I tried different possibilities, even with ForeignKeys, but I can't get them to work the way it suppost to be...

    Thanx up front...
    Last edited by BlindMate; 12-01-16 at 15:07.

  2. #2
    Join Date
    Oct 2016
    Location
    Minneapolis
    Posts
    4

    Cool DB design help

    Hello, some things to consider would be a team can have many players but players can not have more than one team. So change TeamID to [FK] and also add to the Players table. The players table will have PlayerID [PK] and TeamID [FK].

    The other issue is your scores table is currently irrelevant because there's no common attribute between them. I would insert the TeamID[FK] column to the scores table. I would also add a Division column in the scores table.

    I hope this helps, you could also look at ER Diagram design tutorials.

Posting Permissions

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