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 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... 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. Link to comment https://forums.phpfreaks.com/topic/568-normalizing-puzzle/#findComment-1920 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.