Changes between Version 93 and Version 94 of Version1

Timestamp:

08/12/24 00:02:00 (7 weeks ago)

Author:

184006

Comment:

--

Version1

@@ -481 +481 @@
 \\ **R,,2222222,, n R,,2222221,,** = blog_post_answers_id, клуч за R,,2222221,, => нема губење на податоци.
 
+\\ **R,,2222222,,** не е во 2NF поради cities_id-> cities_name
+\\  cities_id +={cities_id, cities_name}
+\\ **R,,22222221,,** (cities_id, cities_name) клуч cities_id BCNF
+\\ **F,,22222221,,** { cities_id-> cities_name}
+\\ **R,,22222222,,** ( cities_id, reports_id, reports_description, pets_id, pet_status_id, node, 
+pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, 
+diagnostics_description, medecines_id, manufacturers_name, medecines_description, 
+manufacturers_id, city, state, manufacturers_name, manufacturers_description, 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,,22222222,,** = (reports_id-> reports_description, pets_id
+\\ reports_id , pets_id→ users_id 
+\\ pet_status_id->node, pet_status_type 
+\\ therapy_id->appoitmentDate, therapy_description
+\\ diagnostics_id-> diagnostics_description 
+\\ medecines_id-> medecines_name, medecines_description 
+\\ pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_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 
+\\ medecines_id → manufacturers_id 
+\\ vet_centers_id, pets_id → pet_status_id) 
+\\ **R,,22222222,, n R,,22222221,,** = cities_id, клуч за R,,22222221,, => нема губење на податоци.
+
+