var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is this design correct so far?
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.
(pk)familyID, language, grossincome
(pk)childID, fname, lname
(pk)guardianID, fname, lname
(fk)childID, (fk)guardianID, (fk)familyID, relationship
Last edited by tonye72; 02-19-12 at
Reason: Asking question another way
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
Tags for this Thread