Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011

    Unanswered: Basic modeling / normalization question

    Hi everyone!

    Generically, I have this mysql relationship:


    Now, I need to link table_A to table_F.
    Is it right to link A to F (making a cycle) or I'll have to access table F throughout all the other tables?


  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Without more information there is no way of knowing how to get the relationships to work. If table A contains information that allows you to select the record from table F directly then you may not need to go through all the other tables. However, if the relationship must be through all the other tables then this is the only way of doing it.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

  3. #3
    Join Date
    Aug 2011


    table_E is 'car_stock'

    table_F contains all possible car classes: sedan, sport, SUV, ...

    table_A is rentals. which also needs to references to a car class (table_F).

    the thing is, here I made A-B-C-D-E-F, but actually it would be A to H

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts