Changes between Version 109 and Version 110 of Version1

Timestamp:

08/30/24 13:03:33 (4 weeks ago)

Author:

184006

Comment:

--

Version1

@@ -226 +226 @@
 \\ jobs_id → jobs_description, predistedSalery - Нарушува 2NF бидејќи има парцијална зависност. jobs_id е подмножество на к.к а десно имаме непримарни атрибути.
 \\ jobs_id +={ jobs_id, jobs_description, predistedSalery }
-\\ **R,,1,,** (jobs_id, jobs_description, predistedSalery) клуч jobs_id, BCNF.
+\\ **R,,1,,** ('''jobs_id''', jobs_description, predistedSalery) клуч jobs_id, BCNF.
 \\ Со наоѓање на сите затварачи 
 \\ **F,,1,,** = { jobs_id → jobs_description, predistedSalery }
-\\ **R,,2,,** ('''jobs_id''', pet_cares_id, title, description, start_date, 
-dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
+\\ **R,,2,,** ('''jobs_id''', '''pet_cares_id''', title, description, start_date, 
+dateEnding,'''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, 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
+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''', 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
 )
 \\ Со наоѓање на сите затварачи