Changes between Version 75 and Version 76 of Version1

Timestamp:

08/11/24 21:44:24 (5 months ago)

Author:

184006

Comment:

--

Version1

@@ -177 +177 @@
 За кандидат клуч добивме:
 {jobs_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}.
 
 Ниту еден од атрибутите го нема од десна страна во ф.з па ова ни е единствен кандидат клуч,
@@ -184 +184 @@
 
 {jobs_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} += 
 {jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
 dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
@@ -289 +289 @@
 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
 )
-\\ **R22** = ( vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude 
+\\ **F22** = ( 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 
@@ -312 +312 @@
 \\ **R22 n R21** = pet_cares_id, клуч за R21 => нема губење на податоци.
 
+\\ R22 не е во 2NF поради vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
+\\vet_centers_id +={ vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude}
+\\ **R221** (vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude) клуч vet_centers_id, BCNF
+\\ **F221** { vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude}
+\\ **R222** (vet_centers_id,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
+)
+\\ **F222** = (roles_id->type
+\\ users_id -> first_name, last_name, phoneNumber, email, password, roles_id 
+\\ blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id 
+\\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 
+\\ cities_id-> cities_name
+\\ 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) 
+\\ **R222 n R221** = vet_centers_id, клуч за R221 => нема губење на податоци.