[thelist] Newbie - DB Design Help

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

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

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

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 "company" (for all of the company information; obviously not all
    - 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
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

More information about the thelist mailing list