From: ChoiSaehoon (saehoonyhotmail.com)
Date: Fri Mar 27 2009 - 08:56:04 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]