Changes between Version 103 and Version 104 of Version1

Timestamp:

08/15/24 00:19:33 (6 weeks ago)

Author:

184006

Comment:

--

Version1

@@ -656 +656 @@
 \\  pet_galery_id+={ pet_galery_id, image, pets_id}
 \\ **R,,2222222222222221,,** (pet_galery_id, image, pets_id) клуч pet_galery_id BCNF
-\\ **F,,2222222222222221,,** {pet_galery_id->image, pets_id }
+\\ **F,,2222222222222221,,** {pet_galery_id->image, pets_id}
 \\ **R,,2222222222222222,,** ( pet_galery_id, orders_id,
 products_id, products_name, products_description, category, dateAdded,isActive, price, 
@@ -668 +668 @@
 )
 \\ **R,,2222222222222222,, n R,,2222222222222221,,** = pet_galery_id, клуч за R,,2222222222222221,, => нема губење на податоци.
+
+\\ **R,,2222222222222222,,** не е во 2NF поради orders_id → userid
+\\  orders_id +={ orders_id, userid}
+\\ **R,,22222222222222221,,** (orders_id, userid) клуч orders_id, BCNF
+\\ **F,,22222222222222221,,** {orders_id → userid}
+\\ **R,,22222222222222222,,** ( orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, 
+available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
+)
+\\ **F,,22222222222222222,,** = (products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity 
+\\ 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,,22222222222222222,, n R,,22222222222222221,,** = orders_id , клуч за R,,22222222222222221,, => нема губење на податоци.