Changes between Version 114 and Version 115 of Version1

Timestamp:

08/30/24 15:16:23 (4 weeks ago)

Author:

184006

Comment:

--

Version1

@@ +1 @@
+== Направени промени 
+Направена е промена во релацијата service_for_pets. Релацијата е променета од 1:N Pet_Cares:Pets во 1:N Pets:Pet_Cares. Промената ја направив бидејќи не е логично за едно животно да може да се побара само една услуга. За едно милениче ќе може да бидат побарувани повеќе услуги но секоја услуга истовремено ќе може да биде побарана од само едно милениче. Уште подобро би било ако се промеви во many-to-many но засега останува вака. 
 == A) Oпределување на важечките функциски зависности
 
@@ -741 +743 @@
 Резултат
 R,,1,, {jobs_id, jobs_description, predistedSalery} - Jobs
-R,,21,, {pet_cares_id , title, description, start_date, dateEnding, pets_id} - Pet_Cares
-
+\\R,,21,, {pet_cares_id , title, description, start_date, dateEnding, pets_id} - Pet_Cares
+\\R,,221,, {vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude} - Vet_Centers
+\\R,,2221,, {roles_id, type} - Roles
+\\R,,22221,, {users_id, first_name, last_name, phoneNumber, email, password, roles_id} - Users
+\\R,,222221,, {blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, users_id} - Blog_Post_For_Consultation
+\\R,,2222221,, {blog_post_answers_id, parent_id, reply, date_answers, blog_post_for_consultation_id, users_id} - Blog_Post_Answers
+\\R,,22222221,, {cities_id, cities_name} - Cities
+\\R,,222222221,, {reports_id, reports_description, pets_id, users_id} - Reports
+\\R,,2222222221,, {pet_status_id, node, pet_status_type} - Pet_Status
+\\R,,22222222221,, {therapy_id, appoitmentDate, therapy_description} - Therapy
+\\R,,222222222221,, {diagnostics_id, diagnostics_description} - Diagnostics
+\\R,,2222222222221,, {medecines_id, medecines_name, medecines_description, manufacturers_id} - Medecines
+\\R,,22222222222221,, { manufacturers_id, city, state, manufacturers_name, manufacturers_descriptio} - Manufacturers
+\\R,,222222222222221,, {pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id} - Pets
+\\R,,2222222222222221,, {pet_galery_id, image, pets_id} - Pet_Galery
+\\R,,22222222222222221,, {orders_id, userid} - Orders
+\\R,,222222222222222221,, {products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity} Products
+\\R,,2222222222222222221,, {products_id, orders_id , quantity} 
+\\R,,22222222222222222221,, {breeds_id, breeds_name, type_of_pets_id} Breeds
+\\R,,222222222222222222221,, { type_of_pets_id, kind_of_pet, type_of_pets_description} Type_Of_Pets
 }}}