Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    23

    Unanswered: Is this design correct so far?

    Hi,
    Attempting to create a database that stores info on families we serve at a non-profit. Can anyone tell me if the design I have so far is going to work? I'm trying to collect info of each child, guardian and general info about the family like primary language and gross income.

    Family Table
    (pk)familyID, language, grossincome

    Child Table
    (pk)childID, fname, lname

    Guardian Table
    (pk)guardianID, fname, lname

    ChildGuardianFamilyLINK Table
    (fk)childID, (fk)guardianID, (fk)familyID, relationship

    Thanks
    Last edited by tonye72; 02-19-12 at 16:08. Reason: Asking question another way

  2. #2
    Join Date
    Feb 2012
    Posts
    13

    Foreign key

    Hi,

    Since a child belongs to a family or guardian, you can add columns familyID and guardianID to the "child" table. So they become foreign keys.
    My point being, you don't need a link table.

    U could include guardianID in Family Table and maintain a one-to-one relationship. Similarly, childID in the Guardian Table with a Many-to-One relationship.

    Hope this helps
    Last edited by nikhilstephen; 03-04-12 at 03:51.

Tags for this Thread

Posting Permissions

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