[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