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

Reply via email to