Changes between Version 104 and Version 105 of Version1

Timestamp:

08/15/24 00:37:51 (15 months ago)

Author:

184006

Comment:

--

Version1

@@ -682 +682 @@
 )
 \\ **R,,22222222222222222,, n R,,22222222222222221,,** = orders_id , клуч за R,,22222222222222221,, => нема губење на податоци.
+
+\\ **R,,22222222222222222,,** не е во 2NF поради products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
+\\  products_id+={ products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity}
+\\ **R,,222222222222222221,,** (products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity) клуч products_id, BCNF
+\\ **F,,222222222222222221,,** {products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity}
+\\ **R,,222222222222222222,,** (products_id, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
+)
+\\ **F,,222222222222222222,,** = (products_id, orders_id → quantity 
+\\ breeds_id-> breeds_name, type_of_pets_id 
+\\ type_of_pets_id->kind_of_pet, type_of_pets_description 
+)
+\\ **R,,222222222222222222,, n R,,222222222222222221,,** = products_id, клуч за R,,222222222222222221,, => нема губење на податоци.
+
+\\ **R,,222222222222222222,,** не е во 2NF поради products_id, orders_id → quantity
+\\  products_id, orders_id +={ products_id, orders_id , quantity}
+\\ **R,,2222222222222222221,,** (products_id, orders_id , quantity) клуч products_id, orders_id, BCNF
+\\ **F,,2222222222222222221,,** {products_id, orders_id → quantity}
+\\ **R,,2222222222222222222,,** (products_id, orders_id, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
+)
+\\ **F,,2222222222222222222,,** = (breeds_id-> breeds_name, type_of_pets_id 
+\\ type_of_pets_id->kind_of_pet, type_of_pets_description 
+)
+\\ **R,,2222222222222222222,, n R,,2222222222222222221,,** = products_id, orders_id, клуч за R,,2222222222222222221,, => нема губење на податоци.
+
+\\ **R,,2222222222222222222,,** не е во 2NF поради breeds_id-> breeds_name, type_of_pets_id 
+\\  breeds_id+={ breeds_name, type_of_pets_id}
+\\ **R,,22222222222222222221,,** ( breeds_id, breeds_name, type_of_pets_id) клуч breeds_id, BCNF
+\\ **F,,22222222222222222221,,** {breeds_id-> breeds_name, type_of_pets_id }
+\\ **R,,22222222222222222222,,** (breeds_id, kind_of_pet, type_of_pets_description
+)
+\\ **F,,22222222222222222222,,** = (type_of_pets_id->kind_of_pet, type_of_pets_description)
+\\ **R,,22222222222222222222,, n R,,22222222222222222221,,** = breeds_id, клуч за R,,22222222222222222221,, => нема губење на податоци.
+
+\\ **R,,22222222222222222222,,** не е во 3NF поради type_of_pets_id->kind_of_pet, type_of_pets_description
+\\  type_of_pets_id+={ type_of_pets_id, kind_of_pet, type_of_pets_description}
+\\ **R,,222222222222222222221,,** (type_of_pets_id, kind_of_pet, type_of_pets_description) клуч type_of_pets_id, BCNF
+\\ **F,,222222222222222222221,,** {type_of_pets_id->kind_of_pet, type_of_pets_description }
+\\ **R,,222222222222222222222,,** (type_of_pets_id)
+\\ **F,,222222222222222222222,,** = {}
+\\ **R,,222222222222222222222,, n R,,222222222222222222221,,** = type_of_pets_id, клуч за R,,222222222222222222221,, => нема губење на податоци.