Changes between Version 88 and Version 89 of Version1

Timestamp:

08/11/24 23:34:26 (7 weeks ago)

Author:

184006

Comment:

--

Version1

@@ -270 +270 @@
 \\ vet_centers_id, pets_id → pet_status_id) 
 \\ **Клуч** (pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id, 
-pet_galery_id, orders_id, products_id, breeds_id)
+pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id)
 \\ **R,,1,, n R,,2,,** = jobs_id, клуч за R,,1,, што значи нема губење на податоци.
 
-\\ R2 не е во 2NF поради pet_cares_id ->title, description, start_date, dateEnding
+\\ **R,,2,,** не е во 2NF поради pet_cares_id ->title, description, start_date, dateEnding
 \\ pet_cares_id +={ pet_cares_id , title, description, start_date, dateEnding}
-\\ **R21** (pet_cares_id , title, description, start_date, dateEnding) клуч pet_cares_id, BCNF
-\\ **F21** { pet_cares_id ->title, description, start_date, dateEnding}
-\\ **R22** (pet_cares_id, vet_centers_id, name, address, vet_centers_description, workingHours, 
-latitude, longitude,roles_id, type, users_id, first_name, last_name,
-phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
-blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
-cities_id, cities_name, 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
-)
-\\ **F22** = ( vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude 
+\\ **R,,21,,** (pet_cares_id , title, description, start_date, dateEnding) клуч pet_cares_id, BCNF
+\\ **F,,21,,** { pet_cares_id ->title, description, start_date, dateEnding}
+\\ **R,,22,,** (pet_cares_id, vet_centers_id, name, address, vet_centers_description, workingHours, 
+latitude, longitude,roles_id, type, users_id, first_name, last_name,
+phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
+blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
+cities_id, cities_name, 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,,22,,** = ( vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude 
 \\ roles_id->type
 \\ users_id -> first_name, last_name, phoneNumber, email, password, roles_id 
@@ -310 +310 @@
 \\ medecines_id → manufacturers_id 
 \\ vet_centers_id, pets_id → pet_status_id) 
-\\ **R22 n R21** = pet_cares_id, клуч за R21 => нема губење на податоци.
+\\ **R,,22,, n R,,21,,** = pet_cares_id, клуч за R,,21,, => нема губење на податоци.
 
 \\ R22 не е во 2NF поради vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude