Hello Guys, **These are my requirements:** 1. Each Category has Multiple Groups 2. Each group has multiple Attributes 3. Each attribute has multiple values So far i have come up with this DB Design **CategoryGroups Table** `GroupID` | `CatID[References Category(CatID)]` | `GroupName` **CategoryAttributes Table** `AttributeID` | `AttributeName` | `GroupID[References CategoryGroups(GroupID)]` | `AttributeValue` So do you guys think this is a neat design?? Any suggestions??
You've defined 3 relationships, so that to me would suggest 4 tables (at least) From a completely normalised design, I could then refine if neccessary: **Category** CategoryID CategoryDescription **Group** GroupID GroupDescription CategoryID --FK to Category **Attribute** AttributeID AttributeDescription GroupID --FK to Group **AttributeValue** AttributeValueID AttributeValueDescription AttributeID --FK to Attribute