Changes between Version 13 and Version 14 of Normalization


Ignore:
Timestamp:
09/21/26 21:23:35 (7 days ago)
Author:
201165
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Normalization

    v13 v14  
    287287== БОЈС-КОДОВА (BCNF)
    288288
     289||= Релација =||= PK =||= FK =||= Нормална форма =||
     290||USER||user_id||X|| ||
     291||INGREDIENT||ingredient_id||X||3NF / BCNF ||
     292||NUTRIENT||nutrient_id ||X||3NF / BCNF  ||
     293||RESTRICTION||restriction_id||X||3NF / BCNF ||
     294||RECIPE||recipe_id||user_id → USER ||3NF / BCNF ||
     295||POST||post_id||user_id → USER, recipe_id → RECIPE||3NF / BCNF ||
     296||COMMENT ||comment_id||post_id → POST, user_id → USER||3NF / BCNF ||
     297||GROCERY_LIST||list_id||user_id → USER||3NF / BCNF ||
     298||INTAKE_PLANNER||planner_id||user_id → USER||3NF / BCNF ||
     299||BIOMETRICS||bio_id||user_id → USER||3NF / BCNF ||
     300||RECIPE_CONTAINS_INGREDIENT||recipe_id, nutrient_id||recipe_id → RECIPE, ingredient_id → INGREDIENT||3NF / BCNF ||
     301||INGREDIENT_CONTAINS_NUTRIENT||ingredient_id, nutrient_id||ingredient_id → INGREDIENT, nutrient_id → NUTRIENT||3NF / BCNF ||
     302||RECIPE_CONTAINS_RESTRICTION||recipe_id, restriction_id ||recipe_id → RECIPE, restriction_id → RESTRICTION||3NF / BCNF ||
     303||GROCERY_LIST_BULK_ADD_INGREDIENT||list_id, recipe_id||list_id → GROCERY_LIST, recipe_id → RECIPE||3NF / BCNF ||
     304||GROCERY_LIST_SINGLE_ADD_INGREDIENT||list_id, ingredient_id||list_id → GROCERY_LIST, ingredient_id → INGREDIENT||3NF / BCNF ||
     305||INTAKE_PLANNER_SAVE_TO_LIST_POST||planner_id, post_id||planner_id → INTAKE_PLANNER, post_id → POST||3NF / BCNF ||
     306
     307
     308
    289309
    290310== Навигација низ проектот