Jump to content


Photo

Normalizing puzzle


  • Please log in to reply
2 replies to this topic

#1 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 10 June 2003 - 07:03 AM

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
Guru?...in my dreams!
Sorry Everybody

----------------------

#2 karassik

karassik
  • Members
  • PipPip
  • Member
  • 13 posts
  • LocationPortland, Oregon

Posted 10 June 2003 - 08:47 PM

how about an intermediary table:

tblCompSvc
idCompany
idService

tblCatagory also contains idService


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

#3 mgm_03

mgm_03
  • Members
  • PipPipPip
  • Advanced Member
  • 49 posts
  • LocationFort Worth, TX

Posted 11 June 2003 - 03:41 AM

thanks!

I think the Company_Service mapping table is unavoidable. It introduces many to many relations but it will work.
Guru?...in my dreams!
Sorry Everybody

----------------------




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users