[thelist] Newbie - DB Design Help

Rob Smith rob.smith at lexjet.com
Wed Jul 26 07:32:52 CDT 2006


<snip>
In this site, a list of services each company provides will be labled by
level of expertise (let's call it rookie, modertate, expert).  
</snip>

One of the cool things about building databases is the fact that you can
design it through using plain English. Obviously you have a one-to-many
and possibly a many-to-many relationship. Meaning, Company A may have a
generic service that Company B, might use. It wouldn't makes sense to
create an entirely new Service for company B, but share the two, whereas
Company A ONLY does a particular service that makes them unique to the
industry.

Having bridging tables is good for a great deal amount of information.
For proper relational database management you're on the right track.
You could also get away with the following without using a bridging
table. 

Table "company" (for all of the company information; obviously not all
of
it)
    - company_ID
    - company_Name
    - ...
 
Table "services" (for the list of the various services)
    - services_ID
    - company_ID  (as a FK)
    - services_Name
    - services_Description
 
Table "level" (for the 3-4 levels of expertise)
    - service_level_ID
    - services_ID (as a FK)
    - service_level_Name
    - service_level_Value (1, 2, 3, etc)
 

Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236




More information about the thelist mailing list