Changes between Version 111 and Version 112 of Version1
- Timestamp:
- 08/30/24 14:26:15 (4 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Version1
v111 v112 267 267 pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id) 268 268 \\ **R,,1,, n R,,2,,** = jobs_id, клуч за R,,1,, што значи нема губење на податоци. 269 \\ ----------------- 270 \\ Разгледуваме **R,,1,,** 271 \\ e во 2NF 272 \\ e во 3NF 273 \\ e во BCNF 274 275 \\------------------- 269 \\ ----------------------------------------------------------------------------------------------------------------------------- 270 271 276 272 \\ **R,,2,,** не е во 2NF поради pet_cares_id ->title, description, start_date, dateEnding 277 273 \\ pet_cares_id +={ pet_cares_id , title, description, start_date, dateEnding} 278 \\ **R,,21,,** ( pet_cares_id, title, description, start_date, dateEnding) клуч pet_cares_id, BCNF274 \\ **R,,21,,** ('''pet_cares_id''' , title, description, start_date, dateEnding) клуч pet_cares_id, BCNF 279 275 \\ **F,,21,,** { pet_cares_id ->title, description, start_date, dateEnding} 280 \\ **R,,22,,** ( pet_cares_id, vet_centers_id, name, address, vet_centers_description, workingHours,276 \\ **R,,22,,** ('''pet_cares_id''', '''vet_centers_id''', name, address, vet_centers_description, workingHours, 281 277 latitude, longitude,roles_id, type, users_id, first_name, last_name, 282 278 phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, 283 blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers,284 cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,285 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,286 diagnostics_description, medecines_id, medecines_description,287 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, 288 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,289 products_id, products_name, products_description, category, dateAdded,isActive, price,290 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description279 blog_post_description, dateAsked, '''blog_post_answers_id''', parent_id, reply, date_answers, 280 '''cities_id''', cities_name, '''reports_id''', reports_description, pets_id, pet_status_id, node, 281 pet_status_type, '''therapy_id''', appoitmentDate, therapy_description, '''diagnostics_id''', 282 diagnostics_description, '''medecines_id''', medecines_description, 283 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, 284 color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''', 285 '''products_id''', products_name, products_description, category, dateAdded,isActive, price, 286 available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description 291 287 ) 292 288 \\ **F,,22,,** = ( vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude … … 311 307 ) 312 308 \\ **R,,22,, n R,,21,,** = pet_cares_id, клуч за R,,21,, => нема губење на податоци. 309 \\ ----------------------------------------------------------------------------------------------------------------------------- 313 310 314 311 \\ **R,,22,,** не е во 2NF поради vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude … … 319 316 phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, 320 317 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,318 '''cities_id''', cities_name, '''reports_id''', reports_description, pets_id, pet_status_id, node, 322 319 pet_status_type, therapy_id, appoitmentDate, therapy_description, '''diagnostics_id''', 323 320 diagnostics_description, '''medecines_id''', manufacturers_name, medecines_description, … … 346 343 \\ medecines_id → manufacturers_id) 347 344 \\ **R,,222,, n R,,221,,** = vet_centers_id, клуч за R221 => нема губење на податоци. 345 \\ ----------------------------------------------------------------------------------------------------------------------------- 348 346 349 347 \\ R,,222,, не е во 3NF поради roles_id->type 350 348 \\ roles_id +={roles_id, type} 351 \\ **R,,2221,,** ( roles_id, type) клуч roles_id BCNF349 \\ **R,,2221,,** ('''roles_id''', type) клуч roles_id BCNF 352 350 \\ **F,,2221,,** { roles_id-> type} 353 \\ **R,,2222,,** ( roles_id, users_id, first_name, last_name,354 phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, 355 blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers,356 cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,357 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id,358 diagnostics_description, medecines_id, medecines_description,359 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, 360 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,361 products_id, products_name, products_description, category, dateAdded,isActive, price,362 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description351 \\ **R,,2222,,** ('''roles_id''', users_id, first_name, last_name, 352 phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, 353 blog_post_description, dateAsked, '''blog_post_answers_id''', parent_id, reply, date_answers, 354 '''cities_id''', cities_name, '''reports_id''', reports_description, pets_id, pet_status_id, node, 355 pet_status_type, '''therapy_id''', appoitmentDate, therapy_description, '''diagnostics_id''', 356 diagnostics_description, '''medecines_id''', medecines_description, 357 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, 358 color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''', 359 '''products_id''', products_name, products_description, category, dateAdded,isActive, price, 360 available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description 363 361 ) 364 362 \\ **F,,2222,,** = (users_id -> first_name, last_name, phoneNumber, email, password, roles_id … … 381 379 ) 382 380 \\ **R,,2222,, n R,,2221,,** = roles_id, клуч за R2221 => нема губење на податоци. 381 \\ ----------------------------------------------------------------------------------------------------------------------------- 383 382 384 383 \\ **R,,2222,,** не е во 3NF поради users_id -> first_name, last_name, phoneNumber, email, password, roles_id … … 414 413 ) 415 414 \\ **R,,22222,, n R,,22221,,** = users_id, клуч за R22221 => нема губење на податоци. 415 \\ ----------------------------------------------------------------------------------------------------------------------------- 416 416 417 417 \\ **R,,22222,,** не е во 3NF поради blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id 418 418 \\ blog_post_for_consultation_id +={blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, users_id} 419 \\ **R,,222221,,** ( blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, users_id) клуч blog_post_for_consultation_id BCNF419 \\ **R,,222221,,** ('''blog_post_for_consultation_id''', blog_post_title, blog_post_description, dateAsked, users_id) клуч blog_post_for_consultation_id BCNF 420 420 \\ **F,,222221,,** { blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id} 421 421 \\ **R,,222222,,** (blog_post_for_consultation_id,'''blog_post_answers_id''', parent_id, reply, date_answers, 422 cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node,423 pet_status_type, therapy_id, appoitmentDate, therapy_description, '''diagnostics_id''',422 cities_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 424 diagnostics_description, '''medecines_id''', medecines_description, 425 425 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, … … 445 445 ) 446 446 \\ **R,,222222,, n R,,222221,,** = blog_post_for_consultation_id, клуч за R,,222221,, => нема губење на податоци. 447 \\ ----------------------------------------------------------------------------------------------------------------------------- 447 448 448 449 \\ **R,,222222,,** не е во 2NF поради blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id … … 474 475 ) 475 476 \\ **R,,2222222,, n R,,2222221,,** = blog_post_answers_id, клуч за R,,2222221,, => нема губење на податоци. 477 \\ ----------------------------------------------------------------------------------------------------------------------------- 476 478 477 479 \\ **R,,2222222,,** не е во 2NF поради cities_id-> cities_name … … 502 504 ) 503 505 \\ **R,,22222222,, n R,,22222221,,** = cities_id, клуч за R,,22222221,, => нема губење на податоци. 506 \\ ----------------------------------------------------------------------------------------------------------------------------- 504 507 505 508 \\ **R,,22222222,,** не е во 2NF поради reports_id-> reports_description, pets_id, users_id … … 529 532 ) 530 533 \\ **R,,222222222,, n R,,222222221,,** = reports_id, клуч за R,,222222221,, => нема губење на податоци. 534 \\ ----------------------------------------------------------------------------------------------------------------------------- 531 535 532 536 \\ **R,,222222222,,** не е во 3NF поради pet_status_id->node, pet_status_type 533 537 \\ pet_status_id +={pet_status_id, node, pet_status_type} 534 \\ **R,,2222222221,,** ( pet_status_id, node, pet_status_type) клуч pet_status_id BCNF538 \\ **R,,2222222221,,** ('''pet_status_id''', node, pet_status_type) клуч pet_status_id BCNF 535 539 \\ **F,,2222222221,,** {pet_status_id->node, pet_status_type} 536 \\ **R,,2222222222,,** ( pet_status_id, therapy_id, appoitmentDate, therapy_description, diagnostics_id,537 diagnostics_description, medecines_id, medecines_description,538 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, 539 color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,540 products_id, products_name, products_description, category, dateAdded,isActive, price,541 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description540 \\ **R,,2222222222,,** ( '''pet_status_id''', '''therapy_id''', appoitmentDate, therapy_description, '''diagnostics_id''', 541 diagnostics_description, '''medecines_id''', medecines_description, 542 manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, 543 color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''', 544 '''products_id''', products_name, products_description, category, dateAdded,isActive, price, 545 available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description 542 546 ) 543 547 \\ **F,,2222222222,,** = (therapy_id->appoitmentDate, therapy_description … … 554 558 ) 555 559 \\ **R,,2222222222,, n R,,2222222221,,** = pet_status_id, клуч за R,,2222222221,, => нема губење на податоци. 560 \\ ----------------------------------------------------------------------------------------------------------------------------- 556 561 557 562 \\ **R,,2222222222,,** не е во 2NF поради therapy_id->appoitmentDate, therapy_description 558 563 \\ therapy_id +={ therapy_id, appoitmentDate, therapy_description} 559 \\ **R,,22222222221,,** ( therapy_id, appoitmentDate, therapy_description) клуч therapy_id BCNF564 \\ **R,,22222222221,,** ('''therapy_id''', appoitmentDate, therapy_description) клуч therapy_id BCNF 560 565 \\ **F,,22222222221,,** {therapy_id->appoitmentDate, therapy_description} 561 566 \\ **R,,22222222222,,** ( '''therapy_id''', '''diagnostics_id''', diagnostics_description, '''medecines_id''', medecines_description, … … 577 582 ) 578 583 \\ **R,,22222222222,, n R,,22222222221,,** = therapy_id, клуч за R,,22222222221,, => нема губење на податоци. 584 \\ ----------------------------------------------------------------------------------------------------------------------------- 579 585 580 586 \\ **R,,22222222222,,** не е во 2NF поради diagnostics_id-> diagnostics_description … … 600 606 ) 601 607 \\ **R,,222222222222,, n R,,222222222221,,** = diagnostics_id, клуч за R,,222222222221,, => нема губење на податоци. 608 \\ ----------------------------------------------------------------------------------------------------------------------------- 602 609 603 610 \\ **R,,222222222222,,** не е во 2NF поради medecines_id-> medecines_name, medecines_description, manufacturers_id … … 620 627 ) 621 628 \\ **R,,2222222222222,, n R,,2222222222221,,** = medecines_id, клуч за R,,2222222222221,, => нема губење на податоци. 629 \\ ----------------------------------------------------------------------------------------------------------------------------- 622 630 623 631 \\ **R,,2222222222222,,** не е во 3NF поради manufacturers_id->city, state, manufacturers_name, manufacturers_description 624 632 \\ manufacturers_id+={ manufacturers_id, city, state, manufacturers_name, manufacturers_description} 625 \\ **R,,22222222222221,,** ( manufacturers_id, city, state, manufacturers_name, manufacturers_description) клуч manufacturers_id BCNF633 \\ **R,,22222222222221,,** ( '''manufacturers_id''', city, state, manufacturers_name, manufacturers_description) клуч manufacturers_id BCNF 626 634 \\ **F,,22222222222221,,** {manufacturers_id->city, state, manufacturers_name, manufacturers_description } 627 \\ **R,,22222222222222,,** ( manufacturers_id, pets_name,color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,628 products_id, products_name, products_description, category, dateAdded,isActive, price,629 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description635 \\ **R,,22222222222222,,** ( '''manufacturers_id''', pets_name,color, dateOfBirthday, pets_description, type_of_pets_id, '''pet_galery_id''', image, '''orders_id''', 636 '''products_id''', products_name, products_description, category, dateAdded,isActive, price, 637 available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description 630 638 ) 631 639 \\ **F,,22222222222222,,** = (pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id … … 638 646 ) 639 647 \\ **R,,22222222222222,, n R,,22222222222221,,** = manufacturers_id, клуч за R,,22222222222221,, => нема губење на податоци. 648 \\ ----------------------------------------------------------------------------------------------------------------------------- 640 649 641 650 642 651 \\ **R,,22222222222222,,** не е во 3NF поради pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id 643 652 \\ pets_id+={ pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id} 644 \\ **R,,222222222222221,,** ( pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id) клуч pets_id BCNF653 \\ **R,,222222222222221,,** ( '''pets_id''', pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id) клуч pets_id BCNF 645 654 \\ **F,,222222222222221,,** {pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id} 646 \\ **R,,222222222222222,,** ( pets_id, pet_galery_id, image, orders_id,647 products_id, products_name, products_description, category, dateAdded,isActive, price,648 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description655 \\ **R,,222222222222222,,** ( '''pets_id''', '''pet_galery_id''', image, '''orders_id''', 656 '''products_id''', products_name, products_description, category, dateAdded,isActive, price, 657 available_quantity, quantity, '''breeds_id''', breeds_name, kind_of_pet, type_of_pets_description 649 658 ) 650 659 \\ **F,,222222222222222,,** = (pet_galery_id->image, pets_id … … 656 665 ) 657 666 \\ **R,,222222222222222,, n R,,222222222222221,,** = pets_id, клуч за R,,222222222222221,, => нема губење на податоци. 667 \\ ----------------------------------------------------------------------------------------------------------------------------- 658 668 659 669 \\ **R,,222222222222222,,** не е во 2NF поради pet_galery_id->image, pets_id … … 686 696 ) 687 697 \\ **R,,22222222222222222,, n R,,22222222222222221,,** = orders_id , клуч за R,,22222222222222221,, => нема губење на податоци. 698 \\ ----------------------------------------------------------------------------------------------------------------------------- 688 699 689 700 \\ **R,,22222222222222222,,** не е во 2NF поради products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity … … 698 709 ) 699 710 \\ **R,,222222222222222222,, n R,,222222222222222221,,** = products_id, клуч за R,,222222222222222221,, => нема губење на податоци. 711 712 \\ ----------------------------------------------------------------------------------------------------------------------------- 700 713 701 714 \\ **R,,222222222222222222,,** не е во 2NF поради products_id, orders_id → quantity … … 726 739 \\ **F,,222222222222222222222,,** = {} 727 740 \\ **R,,222222222222222222222,, n R,,222222222222222222221,,** = type_of_pets_id, клуч за R,,222222222222222222221,, => нема губење на податоци. 728 741 \\ ----------------------------------------------------------------------------------------------------------------------------- 729 742 {{{ 730 743 Резултат
