mgm_03 Posted June 10, 2003 Share Posted June 10, 2003 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 Quote Link to comment https://forums.phpfreaks.com/topic/568-normalizing-puzzle/ Share on other sites More sharing options...
karassik Posted June 10, 2003 Share Posted June 10, 2003 how about an intermediary table: tblCompSvc idCompany idService tblCatagory also contains idService Maybe I haven\'t thought it out well enough... Quote Link to comment https://forums.phpfreaks.com/topic/568-normalizing-puzzle/#findComment-1914 Share on other sites More sharing options...
mgm_03 Posted June 11, 2003 Author Share Posted June 11, 2003 thanks! I think the Company_Service mapping table is unavoidable. It introduces many to many relations but it will work. Quote Link to comment https://forums.phpfreaks.com/topic/568-normalizing-puzzle/#findComment-1920 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.