question

monodeep12 avatar image
monodeep12 asked

database design help

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??
databasedatabase-design
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

My main concern now is the how am i going to upload the data in batches?? What i am thinking is that the user has to select the category 1st then the group and then he uploads the attributes with values...am i right?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.