Choi
1. company (3 cols) - company id(pk), company name
2. industry (3 cols) - industry id(pk), industry, sub-industry
3. matching table (3 cols?) - match id(pk), company id(fk), industry id(fk)...?
Yes, you've got it. In the matching (usually called "bridging") table,
any company or industry can appear multiple times, but no combo can
appear more than once.
PB
http://www.artfulsoftware.com
-----
ChoiSaehoon wrote:
I'm a complete newbie, so please feel free to help me here!
I simplified my problem as below:
1. Thousands of companies (i.e. company names)
2. 200 industries. Each company has tree-type(?) industry info. (Industry,
Sub-industry. Say, each industry has 10 sub-industry information. (10X20))
The problem is one company can have 1,2,3... or 15 industries and/or
sub-industries... (as in a real-life case)
What would be a smart way create tables for this situation? (both company and
industry must be searchable)
(One rough thought (after having studying MySQL for 2 weeks now) is create 3 tables of
1. company (3 cols) - company id(pk), company name
2. industry (3 cols) - industry id(pk), industry, sub-industry
3. matching table (3 cols?) - match id(pk), company id(fk), industry id(fk)...? But,
one company can have more than 1 industry info! Ah... Then, if that's the case,
different match id & same company id & different industry id??)
I'm stuck here! :(
Any general advice would be appreciated... :)
_________________________________________________________________
???? ???, ???? ?? ???? ???? ??? Windows Live Hotmail! ?? ???? ???!
http://www.hotmail.com
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.11.30/2026 - Release Date: 03/27/09 07:13:00
