AnsweredAssumed Answered

I have one table called "People", which contains contact/name info, and one called "PeopleTypes",...

Question asked by deathrobot on Jul 30, 2013
Latest reply on Jul 30, 2013 by deathrobot

Post

     I have one table called "People", which contains contact/name info, and one called "PeopleTypes", which describes whether they are staff, vendor, customer, etc. These table are connected via join table like so:

     People ---< JoinTable >--- PeopleTypes

     One of the types is "musician". For musicians I have a table called "Instruments" and a table called "Styles". These are connected via join tables to…and here's my question; would they connect to PeopleTypes or to People:

     1)

      People ---< JoinTable >--- PeopleTypes ---< Join Table >--- Intstruments
                                                      |
                                                       ---< Join Table >--- Styles

      

     OR

     2)

          ---< Join Table >--- Instruments
          |
     People ---< JoinTable >--- PeopleTypes

          |
          ---< Join Table >--- Styles

     Thanks,

     Michael

Outcomes