Changes between Version 87 and Version 88 of Version1
- Timestamp:
- 08/11/24 23:30:36 (3 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Version1
v87 v88 232 232 \\ **R,,1,,** (jobs_id, jobs_description, predistedSalery) клуч jobs_id, BCNF. 233 233 \\ Со наоѓање на сите затварачи 234 \\ **F 1** = { jobs_id → jobs_description, predistedSalery }235 \\ **R 2** (jobs_id, pet_cares_id, title, description, start_date,234 \\ **F,,1,,** = { jobs_id → jobs_description, predistedSalery } 235 \\ **R,,2,,** (jobs_id, pet_cares_id, title, description, start_date, 236 236 dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 237 237 latitude, longitude,roles_id, type, users_id, first_name, last_name, … … 247 247 ) 248 248 \\ Со наоѓање на сите затварачи 249 \\ **F 2** = (pet_cares_id ->title, description, start_date, dateEnding249 \\ **F,,2,,** = (pet_cares_id ->title, description, start_date, dateEnding 250 250 \\ vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude 251 251 \\ roles_id->type … … 271 271 \\ **Клуч** (pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id, 272 272 pet_galery_id, orders_id, products_id, breeds_id) 273 \\ **R 1 n R2** = jobs_id, клуч за R1што значи нема губење на податоци.273 \\ **R,,1,, n R,,2,,** = jobs_id, клуч за R,,1,, што значи нема губење на податоци. 274 274 275 275 \\ R2 не е во 2NF поради pet_cares_id ->title, description, start_date, dateEnding