Forum Discussion
Best practice for Data Model
As there is one to many relationship between the tables , follow the below steps and try and update the model:
1 Merge all the Tables 1:6 in Mtable (merge using category)and only bring the associated sub category (only consider sub category column) while merging.
2. the above step will help you bring Category and Sub Category in Mtable
3. create a key for Category and sub category
4. As we have merged all the six tables there might be a many to many relation with those tables.
5. To overcome the many to many relationship create a bridge table with distinct values of Key (Category and Sub Category)Please update the ticket if you need any further clarification.
As there is one to many relationship between the tables , follow the below steps and try and update the model:
1 Merge all the Tables 1:6 in Mtable (merge using category)and only bring the associated sub category (only consider sub category column) while merging.
2. the above step will help you bring Category and Sub Category in Mtable
3. create a key for Category and sub category
4. As we have merged all the six tables there might be a many to many relation with those tables.
5. To overcome the many to many relationship create a bridge table with distinct values of Key (Category and Sub Category)
Please update the ticket if you need any further clarification.
Yes! That's the right way to do it.
Thanks a lot.
It worked