Changes between Version 52 and Version 53 of Version1

Timestamp:

08/10/24 13:33:15 (7 weeks ago)

Author:

184006

Comment:

--

Version1

@@ -199 +199 @@
 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description}
 }}}
+
+{{{
+jobs_id -> jobs_description, predistedSalery 
+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, 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 
+
+
+Во вака дефинираната релација нема повеќекратни зависности и атрибути и нема вгнездени релации, па оттука следува дека задоволува 1NF.
+}}}
+