3 Replies Latest reply on Jul 30, 2013 11:14 AM by deathrobot

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

    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