At 04:23 PM 9/9/2010, Tompkins Neil wrote:
Hi all,
Needing some advice on my tables design.
Basically I am designing a soccer application, and have a table which
contains player_bids (the values of which a player costs to be transferred
between clubs). Can someone please offer some input on th
Casey,
I would consider, on the most basic level, a method like this:
Contacts (all the company contact info, etc) using primary key contact_id ->
IndustrialRelationships table
<- industry_id primary key on Industries table (all the different type of
industries)
So, in the IndustrialRelationship
you are going to want a 'buster' table... also known as a many-to-many table
so you have:
contacts
Contact_Key
Industries
-
Industry_Key
Contact_Industry_assoc
--
Contact_Key
Industry_Key
> -Original Message-
> From: DeBerry, Casey [mailto:[EMAI
