Changes between Version 87 and Version 88 of Version1


Ignore:
Timestamp:
08/11/24 23:30:36 (3 months ago)
Author:
184006
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Version1

    v87 v88  
    232232\\ **R,,1,,** (jobs_id, jobs_description, predistedSalery) клуч jobs_id, BCNF.
    233233\\ Со наоѓање на сите затварачи
    234 \\ **F1** = { jobs_id → jobs_description, predistedSalery }
    235 \\ **R2** (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,
    236236dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours,
    237237latitude, longitude,roles_id, type, users_id, first_name, last_name,
     
    247247)
    248248\\ Со наоѓање на сите затварачи
    249 \\ **F2** = (pet_cares_id ->title, description, start_date, dateEnding
     249\\ **F,,2,,** = (pet_cares_id ->title, description, start_date, dateEnding
    250250\\ vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
    251251\\ roles_id->type
     
    271271\\ **Клуч** (pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id,
    272272pet_galery_id, orders_id, products_id, breeds_id)
    273 \\ **R1 n R2** = jobs_id, клуч за R1 што значи нема губење на податоци.
     273\\ **R,,1,, n R,,2,,** = jobs_id, клуч за R,,1,, што значи нема губење на податоци.
    274274
    275275\\ R2 не е во 2NF поради pet_cares_id ->title, description, start_date, dateEnding