Level 80
@pathardepavan What are dependents?
Aug 26, 2015
2
Level 1
Designing variant for database entity
I have database design at http://i.stack.imgur.com/Q7t71.png. Item has one to many relationship with Variant table. Variant table has one to many with dependent1 and dependent2 tables. I think this design is not optimized for search. e.g when a requests to get all the Items based on the user filtering mechanism like dependent1 title or dependent2 it has to search all the variants and gives response back with matching variant.
Can some one help me in redesigning keeping in mind the search performance. I have gone through some of the variant type questions but could not come to a conclusion ?
Level 1
@martinbean dependents are tables whose information is required in variant which have one variant can have multiple dependents. e.g. screenresolutions . Each Item can have multiple variants.
Please or to participate in this conversation.