Can I use an n:n relationship here?
Date: 17 Jul 2002 12:00:34 -0700
Message-ID: <3dd57adc.0207171100.242e840b_at_posting.google.com>
Hi,
Simply put the relationships to a record in tb_txn are varied or nonexistant, and the client wants to add sources as they go.
The current system holds the "file_id" which is a foreign key to tb_file. To improve on this I may suggest that they create an intersect table which holds this key and the txn_id. In the case where tb_txn is related to a section I would create another intersect table to relate tb_txn to tb_section. If there is no saved source, as with the HTTP port there would be no relationship stored. If in the future there needs to be a new source I can always add a new intersect table to relate tb_txn.
My question: Does this violate any rules of database design? Particularly the fact that there may be cases where there is no relationship stored at all?
Thanks,
Sean
PS. I call them "intersect tables" some call them "resolver tables", "gerund tables", "linking tables" etc.. they are usually used to fix many to many relationships. Received on Wed Jul 17 2002 - 21:00:34 CEST