Jump to content

Archived

This topic is now archived and is closed to further replies.

mgm_03

Normalizing puzzle

Recommended Posts

This is my puzzle.

 

There are Companies (A-Z)

Each company offers services in a few but not all Categories (1-10)

Within each Cateogry there are also a different services each Company could provide (Cat 1 has a,b,c; Cat 2 has: a,b,c,d; Cat 3 has a,b ...etc.)

 

Example scenario:

 

Company \"M\" offers services: 1c, 2d, 5a, 5b, from Categories 1,2,5 respectively

 

Even if I eliminate the services and consider only the companies and the categories in which they do business, I still have a table that has many-to-many relationships. Is it possible to define a set of tables which have only one-to-many relations

Share this post


Link to post
Share on other sites

how about an intermediary table:

 

tblCompSvc

idCompany

idService

 

tblCatagory also contains idService

 

 

Maybe I haven\'t thought it out well enough...

Share this post


Link to post
Share on other sites

thanks!

 

I think the Company_Service mapping table is unavoidable. It introduces many to many relations but it will work.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.