Changes between Version 110 and Version 111 of Version1


Ignore:
Timestamp:
08/30/24 13:30:46 (14 months ago)
Author:
184006
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Version1

    v110 v111  
    314314\\ **R,,22,,** не е во 2NF поради vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
    315315\\vet_centers_id +={ vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude}
    316 \\ **R,,221,,** (vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude) клуч vet_centers_id, BCNF
     316\\ **R,,221,,** ('''vet_centers_id''', name, address, vet_centers_description, workingHours, latitude, longitude) клуч vet_centers_id, BCNF
    317317\\ **F,,221,,** { vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude}
    318 \\ **R,,222,,** (vet_centers_id,roles_id, type, users_id, first_name, last_name,
    319 phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
    320 blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers,
    321 cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,
    322 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,
    323 diagnostics_description, medecines_id, manufacturers_name, medecines_description,
    324 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    325 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    326 products_id, products_name, products_description, category, dateAdded,isActive, price,
    327 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     318\\ **R,,222,,** ('''vet_centers_id''', roles_id, type, users_id, first_name, last_name,
     319phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
     320blog_post_description, dateAsked, '''blog_post_answers_id''', parent_id, reply, date_answers,
     321cities_id, cities_name, '''reports_id''', reports_description, pets_id, pet_status_id, node,
     322pet_status_type, therapy_id, appoitmentDate, therapy_description, '''diagnostics_id''',
     323diagnostics_description, '''medecines_id''', manufacturers_name, medecines_description,
     324manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     325color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     326'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     327available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    328328)
    329329\\ **F,,222,,** = (roles_id->type
    … …  
    388388\\ **R,,22222,,** (users_id, blog_post_for_consultation_id, blog_post_title,
    389389blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers,
    390 cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,
    391 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,
    392 diagnostics_description, medecines_id, medecines_description,
    393 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    394 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    395 products_id, products_name, products_description, category, dateAdded,isActive, price,
    396 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     390'''cities_id''', cities_name, '''reports_id''', reports_description, pets_id, pet_status_id, node,
     391pet_status_type, therapy_id, appoitmentDate, therapy_description, '''diagnostics_id''',
     392diagnostics_description, '''medecines_id''', medecines_description,
     393manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     394color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     395'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     396available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    397397)
    398398\\ **,,F22222,,** = (blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
    … …  
    419419\\ **R,,222221,,** (blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, users_id) клуч blog_post_for_consultation_id BCNF
    420420\\ **F,,222221,,** { blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id}
    421 \\ **R,,222222,,** (blog_post_for_consultation_id,blog_post_answers_id, parent_id, reply, date_answers,
     421\\ **R,,222222,,** (blog_post_for_consultation_id,'''blog_post_answers_id''', parent_id, reply, date_answers,
    422422cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,
    423 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,
    424 diagnostics_description, medecines_id, medecines_description,
    425 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    426 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    427 products_id, products_name, products_description, category, dateAdded,isActive, price,
    428 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     423pet_status_type, therapy_id, appoitmentDate, therapy_description, '''diagnostics_id''',
     424diagnostics_description, '''medecines_id''', medecines_description,
     425manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     426color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     427products_id, products_name, products_description, category, dateAdded,isActive, price,
     428available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    429429)
    430430\\ **F,,222222,,** = (blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
    … …  
    450450\\ **R,,2222221,,** (blog_post_answers_id, parent_id, reply, date_answers, blog_post_for_consultation_id, users_id) клуч blog_post_answers_id BCNF
    451451\\ **F,,2222221,,** { blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id}
    452 \\ **R,,2222222,,** (blog_post_answers_id, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,
     452\\ **R,,2222222,,** ('''blog_post_answers_id''', '''cities_id''', cities_name, '''reports_id''', reports_description, pets_id, pet_status_id, node,
     453pet_status_type, '''therapy_id''', appoitmentDate, therapy_description, diagnostics_id,
     454diagnostics_description, '''medecines_id''', medecines_description,
     455manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     456color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     457'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     458available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
     459)
     460\\ **F,,2222222,,** = (cities_id-> cities_name
     461\\ reports_id-> reports_description, pets_id, users_id
     462\\ pet_status_id->node, pet_status_type
     463\\ therapy_id->appoitmentDate, therapy_description
     464\\ diagnostics_id-> diagnostics_description
     465\\ medecines_id-> medecines_name, medecines_description, manufacturers_id
     466\\ manufacturers_id->city, state, manufacturers_name, manufacturers_description
     467\\ pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
     468\\ pet_galery_id->image, pets_id
     469\\ orders_id → userid
     470\\ products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
     471\\ products_id, orders_id → quantity
     472\\ breeds_id-> breeds_name, type_of_pets_id
     473\\ type_of_pets_id->kind_of_pet, type_of_pets_description
     474)
     475\\ **R,,2222222,, n R,,2222221,,** = blog_post_answers_id, клуч за R,,2222221,, => нема губење на податоци.
     476
     477\\ **R,,2222222,,** не е во 2NF поради cities_id-> cities_name
     478\\  cities_id +={cities_id, cities_name}
     479\\ **R,,22222221,,** ('''cities_id''', cities_name) клуч cities_id BCNF
     480\\ **F,,22222221,,** { cities_id-> cities_name}
     481\\ **R,,22222222,,** ( '''cities_id''', '''reports_id''', reports_description, pets_id, pet_status_id, node,
    453482pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,
    454483diagnostics_description, medecines_id, medecines_description,
    455484manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    456 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    457 products_id, products_name, products_description, category, dateAdded,isActive, price,
    458 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
    459 )
    460 \\ **F,,2222222,,** = (cities_id-> cities_name
    461 \\ reports_id-> reports_description, pets_id, users_id
    462 \\ pet_status_id->node, pet_status_type
    463 \\ therapy_id->appoitmentDate, therapy_description
    464 \\ diagnostics_id-> diagnostics_description
    465 \\ medecines_id-> medecines_name, medecines_description, manufacturers_id
    466 \\ manufacturers_id->city, state, manufacturers_name, manufacturers_description
    467 \\ pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
    468 \\ pet_galery_id->image, pets_id
    469 \\ orders_id → userid
    470 \\ products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
    471 \\ products_id, orders_id → quantity
    472 \\ breeds_id-> breeds_name, type_of_pets_id
    473 \\ type_of_pets_id->kind_of_pet, type_of_pets_description
    474 )
    475 \\ **R,,2222222,, n R,,2222221,,** = blog_post_answers_id, клуч за R,,2222221,, => нема губење на податоци.
    476 
    477 \\ **R,,2222222,,** не е во 2NF поради cities_id-> cities_name
    478 \\  cities_id +={cities_id, cities_name}
    479 \\ **R,,22222221,,** (cities_id, cities_name) клуч cities_id BCNF
    480 \\ **F,,22222221,,** { cities_id-> cities_name}
    481 \\ **R,,22222222,,** ( cities_id, reports_id, reports_description, pets_id, pet_status_id, node,
    482 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,
    483 diagnostics_description, medecines_id, medecines_description,
    484 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    485 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    486 products_id, products_name, products_description, category, dateAdded,isActive, price,
    487 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     485color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     486'''products_id''', products_name, products_description, category, dateAdded, isActive, price,
     487available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    488488)
    489489\\ **F,,22222222,,** = (reports_id-> reports_description, pets_id, users_id
    … …  
    505505\\ **R,,22222222,,** не е во 2NF поради reports_id-> reports_description, pets_id, users_id
    506506\\  reports_id +={ reports_id, reports_description, pets_id, users_id}
    507 \\ **R,,222222221,,** (reports_id, reports_description, pets_id, users_id) клуч reports_id BCNF
     507\\ **R,,222222221,,** ('''reports_id''', reports_description, pets_id, users_id) клуч reports_id BCNF
    508508\\ **F,,222222221,,** {  reports_id-> reports_description, pets_id, users_id}
    509 \\ **R,,222222222,,** ( reports_id, pet_status_id, node,
    510 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,
    511 diagnostics_description, medecines_id, medecines_description,
    512 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    513 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    514 products_id, products_name, products_description, category, dateAdded,isActive, price,
    515 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     509\\ **R,,222222222,,** ( '''reports_id''', pet_status_id, node,
     510pet_status_type, therapy_id, appoitmentDate, therapy_description, '''diagnostics_id''',
     511diagnostics_description, '''medecines_id''', medecines_description,
     512manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     513color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     514'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     515available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    516516)
    517517\\ **F,,222222222,,** = (pet_status_id->node, pet_status_type
    … …  
    559559\\ **R,,22222222221,,** (therapy_id, appoitmentDate, therapy_description) клуч therapy_id BCNF
    560560\\ **F,,22222222221,,** {therapy_id->appoitmentDate, therapy_description}
    561 \\ **R,,22222222222,,** ( therapy_id, diagnostics_id,
    562 diagnostics_description, medecines_id, medecines_description,
    563 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    564 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    565 products_id, products_name, products_description, category, dateAdded,isActive, price,
    566 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     561\\ **R,,22222222222,,** ( '''therapy_id''', '''diagnostics_id''', diagnostics_description, '''medecines_id''', medecines_description,
     562manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     563color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     564'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     565available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    567566)
    568567\\ **F,,22222222222,,** = (diagnostics_id-> diagnostics_description
    … …  
    581580\\ **R,,22222222222,,** не е во 2NF поради diagnostics_id-> diagnostics_description
    582581\\  diagnostics_id +={ diagnostics_id, diagnostics_description}
    583 \\ **R,,222222222221,,** (diagnostics_id, diagnostics_description) клуч diagnostics_id BCNF
     582\\ **R,,222222222221,,** ('''diagnostics_id''', diagnostics_description) клуч diagnostics_id BCNF
    584583\\ **F,,222222222221,,** {diagnostics_id-> diagnostics_description}
    585 \\ **R,,222222222222,,** ( diagnostics_id, medecines_id, medecines_description,
    586 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    587 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    588 products_id, products_name, products_description, category, dateAdded,isActive, price,
    589 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     584\\ **R,,222222222222,,** ( '''diagnostics_id''', '''medecines_id''', medecines_description,
     585manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     586color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     587'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     588available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    590589)
    591590\\ **F,,222222222222,,** = (medecines_id-> medecines_name, medecines_description, manufacturers_id
    … …  
    604603\\ **R,,222222222222,,** не е во 2NF поради medecines_id-> medecines_name, medecines_description, manufacturers_id 
    605604\\  medecines_id +={ medecines_id, medecines_name, medecines_description, manufacturers_id }
    606 \\ **R,,2222222222221,,** ( medecines_id, medecines_name, medecines_description, manufacturers_id) клуч medecines_id BCNF
     605\\ **R,,2222222222221,,** ( '''medecines_id''', medecines_name, medecines_description, manufacturers_id) клуч medecines_id BCNF
    607606\\ **F,,2222222222221,,** {medecines_id-> medecines_name, medecines_description, manufacturers_id }
    608 \\ **R,,2222222222222,,** ( medecines_id,
    609 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
    610 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
    611 products_id, products_name, products_description, category, dateAdded,isActive, price,
    612 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     607\\ **R,,2222222222222,,** ( '''medecines_id''', manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
     608color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''',
     609'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     610available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    613611)
    614612\\ **F,,2222222222222,,** = (manufacturers_id->city, state, manufacturers_name, manufacturers_description
    … …  
    661659\\ **R,,222222222222222,,** не е во 2NF поради pet_galery_id->image, pets_id
    662660\\  pet_galery_id+={ pet_galery_id, image, pets_id}
    663 \\ **R,,2222222222222221,,** (pet_galery_id, image, pets_id) клуч pet_galery_id BCNF
     661\\ **R,,2222222222222221,,** ('''pet_galery_id''', image, pets_id) клуч pet_galery_id BCNF
    664662\\ **F,,2222222222222221,,** {pet_galery_id->image, pets_id}
    665 \\ **R,,2222222222222222,,** ( pet_galery_id, orders_id,
    666 products_id, products_name, products_description, category, dateAdded,isActive, price,
    667 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     663\\ **R,,2222222222222222,,** ( '''pet_galery_id''', '''orders_id''',
     664'''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     665available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    668666)
    669667\\ **F,,2222222222222222,,** = (orders_id → userid
    … …  
    677675\\ **R,,2222222222222222,,** не е во 2NF поради orders_id → userid
    678676\\  orders_id +={ orders_id, userid}
    679 \\ **R,,22222222222222221,,** (orders_id, userid) клуч orders_id, BCNF
     677\\ **R,,22222222222222221,,** ('''orders_id''', userid) клуч orders_id, BCNF
    680678\\ **F,,22222222222222221,,** {orders_id → userid}
    681 \\ **R,,22222222222222222,,** ( orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price,
    682 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     679\\ **R,,22222222222222222,,** ( '''orders_id''', '''products_id''', products_name, products_description, category, dateAdded,isActive, price,
     680available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    683681)
    684682\\ **F,,22222222222222222,,** = (products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
    … …  
    691689\\ **R,,22222222222222222,,** не е во 2NF поради products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
    692690\\  products_id+={ products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity}
    693 \\ **R,,222222222222222221,,** (products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity) клуч products_id, BCNF
     691\\ **R,,222222222222222221,,** ('''products_id''', products_name, products_description, category, dateAdded, isActive, price, available_quantity) клуч products_id, BCNF
    694692\\ **F,,222222222222222221,,** {products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity}
    695 \\ **R,,222222222222222222,,** (products_id, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     693\\ **R,,222222222222222222,,** ('''products_id''', quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    696694)
    697695\\ **F,,222222222222222222,,** = (products_id, orders_id → quantity
    … …  
    703701\\ **R,,222222222222222222,,** не е во 2NF поради products_id, orders_id → quantity
    704702\\  products_id, orders_id +={ products_id, orders_id , quantity}
    705 \\ **R,,2222222222222222221,,** (products_id, orders_id , quantity) клуч products_id, orders_id, BCNF
     703\\ **R,,2222222222222222221,,** ('''products_id''', '''orders_id''' , quantity) клуч products_id, orders_id, BCNF
    706704\\ **F,,2222222222222222221,,** {products_id, orders_id → quantity}
    707 \\ **R,,2222222222222222222,,** (products_id, orders_id, breeds_id, breeds_name, kind_of_pet, type_of_pets_description
     705\\ **R,,2222222222222222222,,** ('''products_id''', '''orders_id''', '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description
    708706)
    709707\\ **F,,2222222222222222222,,** = (breeds_id-> breeds_name, type_of_pets_id
    … …  
    714712\\ **R,,2222222222222222222,,** не е во 2NF поради breeds_id-> breeds_name, type_of_pets_id
    715713\\  breeds_id+={ breeds_name, type_of_pets_id}
    716 \\ **R,,22222222222222222221,,** ( breeds_id, breeds_name, type_of_pets_id) клуч breeds_id, BCNF
     714\\ **R,,22222222222222222221,,** ( '''breeds_id''', breeds_name, type_of_pets_id) клуч breeds_id, BCNF
    717715\\ **F,,22222222222222222221,,** {breeds_id-> breeds_name, type_of_pets_id }
    718716\\ **R,,22222222222222222222,,** (breeds_id, kind_of_pet, type_of_pets_description