Changes between Version 100 and Version 101 of Version1

Timestamp:

08/15/24 00:09:59 (3 months ago)

Author:

184006

Comment:

--

Version1

@@ -616 +616 @@
 )
 \\ **R,,2222222222222,, n R,,2222222222221,,** = medecines_id, клуч за R,,2222222222221,, => нема губење на податоци.
+
+\\ **R,,2222222222222,,** не е во 3NF поради manufacturers_id->city, state, manufacturers_name, manufacturers_description  
+\\  manufacturers_id+={ manufacturers_id, city, state, manufacturers_name, manufacturers_description}
+\\ **R,,22222222222221,,** ( manufacturers_id, city, state, manufacturers_name, manufacturers_description) клуч manufacturers_id BCNF
+\\ **F,,22222222222221,,** {manufacturers_id->city, state, manufacturers_name, manufacturers_description }
+\\ **R,,22222222222222,,** ( manufacturers_id, pets_name,color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, 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,,22222222222222,,** = (pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id 
+\\ pet_galery_id->image, pets_id 
+\\ orders_id → userid
+\\ 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,,22222222222222,, n R,,22222222222221,,** = manufacturers_id, клуч за R,,22222222222221,, => нема губење на податоци.
+
+
+\\ **R,,22222222222222,,** не е во 3NF поради pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id  
+\\  pets_id+={ pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id}
+\\ **R,,222222222222221,,** ( pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id) клуч pets_id BCNF
+\\ **F,,222222222222221,,** {pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id}
+\\ **R,,222222222222222,,** ( pets_id, pet_galery_id, image, 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,,222222222222222,,** = (pet_galery_id->image, pets_id 
+\\ orders_id → userid
+\\ 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,,222222222222222,, n R,,222222222222221,,** = pets_id, клуч за R,,222222222222221,, => нема губење на податоци.