I'm working on a project for a database that contains, in the best way, the nutritional values of foods. They are divided according to type of food, eg Breakfast, Lunch, Dinner. For portions of the food, for example ml, g, etc. oz. That have the name of each food and all of its nutritional values.
Food ========== ID NAME NUTRITIONAL_FACTS ========== ID NUTRITIONAL_FACTS_FOOD_ID KCAL FAT SUGAR PROTEINS PORTIONS ========== ID PORTION FOOD_ID TYPE_FOOD ========= ID TYPE_FOOD FOOD_ID
Could someone tell me which solution would be most appropriate for the design of this database?