Take the 2-minute tour ×  i'm a little bit stuck with deciding
what db structure is the best for performance for me..  i have
two tables:  Catalogue          Items ID | Descr        I_ID |
Descr  in both tables all rows are UNIQUE  in relations terms a
records from Catalogue can have several records from Items, but
there are records that won't have any Items  Items can have
several relations to Catalogue, but not necessarily every item
will have relation to a Catalogue.  Fact1 - there are 7 times
more records in Items than in Catalogue  Fact2 - so if there is
a relationship between Catalogue and Items - it will be equaly
from both tables  what's my best option to relate them?
share|improve this question add comment  2 Answers  up vote 1
down vote accepted  Make a third table, called catalogue_items.
In the table catalogue_items have to columns:    1. ID -->
Referencing Catalogue ID   2. I_ID --> Referencing item ID  Make
a new record for each time the two are related in some way.  I
believe this is what you