Changes between Version 98 and Version 99 of Version1

Timestamp:

08/12/24 15:21:39 (7 weeks ago)

Author:

184006

Comment:

--

Version1

@@ -175 +175 @@
 За кандидат клуч добивме:
 {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, vet_centers_id}.
+pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id, diagnostics_id}.
 
 Ниту еден од атрибутите го нема од десна страна во ф.з па ова ни е единствен кандидат клуч,
@@ -182 +182 @@
 
 {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, vet_centers_id} += 
+pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id, diagnostics_id} += 
 {jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
 dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
@@ -569 +569 @@
 )
 \\ **R,,22222222222,, n R,,22222222221,,** = therapy_id, клуч за R,,22222222221,, => нема губење на податоци.
+
+\\ **R,,22222222222,,** не е во 2NF поради diagnostics_id-> diagnostics_description 
+\\  diagnostics_id +={ diagnostics_id, diagnostics_description}
+\\ **R,,222222222221,,** (diagnostics_id, diagnostics_description) клуч diagnostics_id BCNF
+\\ **F,,222222222221,,** {diagnostics_id-> diagnostics_description}
+\\ **R,,222222222222,,** ( diagnostics_id, 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,,222222222222,,** = (medecines_id-> medecines_name, medecines_description 
+\\ 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 
+\\ medecines_id → manufacturers_id 
+)
+\\ **R,,222222222222,, n R,,222222222221,,** = diagnostics_id, клуч за R,,222222222221,, => нема губење на податоци.