i working on "family dictionary" project. creating tables in sql server. planning give permission user create family, can't trust user. he/she can create multiple families.
what way maintain unique family in sql server several users ? example:
id fname lname sex 1 ashish jain m 2 neha jain f 3 sachin jain m how can relate these persons family? process should use create unique family in database?
you have table 'family' id.
and first table, there foreign key pointing family table.
id fname lname sex familyid 1 ashish jain m 1 2 neha jain f 1 3 sachin jain m 2 