AnsweredAssumed Answered

Differences between relationships (1-1, 1-many, many-many)

Question asked by RosieUnderwood on Feb 25, 2014
Latest reply on Feb 25, 2014 by philmodjunk

Title

Differences between relationships (1-1, 1-many, many-many)

Post

     I am just starting to learn about relationships, and I am confused as the to the differences between the three types….

     I have a practice database already started by someone else which has six tables. The primary key/ unique ID is called individual and this is found in all six of the tables, so does this mean I don't have a foreign key? And what type of relationship is this? Is this a one to one- is that what the relationship links show below?

      

      

      

Screen_Shot_2014-02-25_at_13.22.52.png

Outcomes