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

    Unanswered: Basic modeling / normalization question

    Hi everyone!

    Generically, I have this mysql relationship:

    table_A--table_B--table_C--table_D--table_E--table_F

    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?

    Thanks!

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    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)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Aug 2011
    Posts
    2
    ok.

    say

    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
  •