'How can I resolve this M:N relationship in my relational database model?
As a personal, pet-project, I am creating a database with the purpose of tracking my caloric and nutrient intake, as well as to track how close I am following my diet. This is my first time doing something like this, especially from scratch, and I had some problems and questions with a M:N relationship within the relational database model, which I've included here:
The problematic M:N relationship and the dimensions it involves, are highlighted/shaded in red. The DimNutritionFacts table records the nutrition facts for each food item in the DimFoodItem table, and the DimFoodUnit table records the unit measurements for the serving size & nutrient information in the DimNutritionFacts table. However, a nutrition facts label can consist of many food units, such as micrograms, milligrams, grams, ounces or milliliters, such as the nutrition facts label below:
I understand that, traditionally, M:N relationships can be resolved using a bridge relation, however, I am not sure how that would be implemented in this situation. I am pretty lost in how to solve this issue and would be appreciate any help or recommendations. In addition, since this is my first time creating a database model of my own, I'm open to any other tips, advice or suggestions, thank you!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|