Changes between Version 95 and Version 96 of Version1
- Timestamp:
- 08/12/24 00:31:49 (7 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Version1
v95 v96 67 67 * blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id (Секој одговор е даден врз основа на поставено прашање, има содржина и датум кога е одговорено. Секој одговор е поврзан со едно прашање за консултација и е даден од еден корисник). 68 68 * cities_id-> cities_name (Секој град си има име). 69 * reports_id-> reports_description, pets_id, (Секој извештај има опис. Секој извештај припаѓа на едно милениче) 70 * reports_id , pets_id→ users_id (Секој извештај за одредено милениче е напишан од еден корисник-доктор). 69 * reports_id-> reports_description, pets_id, users_id (Секој извештај има опис. Секој извештај припаѓа на едно милениче.Секој извештај за одредено милениче е напишан од еден корисник-доктор). 71 70 * pet_status_id->node, pet_status_type (Секој статус има забелешка и тип). 72 71 * therapy_id->appoitmentDate, therapy_description (Секоја терапија има датум на започнување и опис). … … 209 208 \\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 210 209 \\ cities_id-> cities_name 211 \\ reports_id-> reports_description, pets_id 212 \\ reports_id , pets_id→ users_id 210 \\ reports_id-> reports_description, pets_id, users_id 213 211 \\ pet_status_id->node, pet_status_type 214 212 \\ therapy_id->appoitmentDate, therapy_description … … 254 252 \\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 255 253 \\ cities_id-> cities_name 256 \\ reports_id-> reports_description, pets_id 257 \\ reports_id , pets_id→ users_id 254 \\ reports_id-> reports_description, pets_id, users_id 258 255 \\ pet_status_id->node, pet_status_type 259 256 \\ therapy_id->appoitmentDate, therapy_description … … 295 292 \\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 296 293 \\ cities_id-> cities_name 297 \\ reports_id-> reports_description, pets_id 298 \\ reports_id , pets_id→ users_id 294 \\ reports_id-> reports_description, pets_id, users_id 299 295 \\ pet_status_id->node, pet_status_type 300 296 \\ therapy_id->appoitmentDate, therapy_description … … 332 328 \\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 333 329 \\ cities_id-> cities_name 334 \\ reports_id-> reports_description, pets_id 335 \\ reports_id , pets_id→ users_id 330 \\ reports_id-> reports_description, pets_id, users_id 336 331 \\ pet_status_id->node, pet_status_type 337 332 \\ therapy_id->appoitmentDate, therapy_description … … 368 363 \\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 369 364 \\ cities_id-> cities_name 370 \\ reports_id-> reports_description, pets_id 371 \\ reports_id , pets_id→ users_id 365 \\ reports_id-> reports_description, pets_id, users_id 372 366 \\ pet_status_id->node, pet_status_type 373 367 \\ therapy_id->appoitmentDate, therapy_description … … 402 396 \\ blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 403 397 \\ cities_id-> cities_name 404 \\ reports_id-> reports_description, pets_id 405 \\ reports_id , pets_id→ users_id 398 \\ reports_id-> reports_description, pets_id, users_id 406 399 \\ pet_status_id->node, pet_status_type 407 400 \\ therapy_id->appoitmentDate, therapy_description … … 434 427 \\ **F,,222222,,** = (blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id 435 428 \\ cities_id-> cities_name 436 \\ reports_id-> reports_description, pets_id 437 \\ reports_id , pets_id→ users_id 429 \\ reports_id-> reports_description, pets_id, users_id 438 430 \\ pet_status_id->node, pet_status_type 439 431 \\ therapy_id->appoitmentDate, therapy_description … … 464 456 ) 465 457 \\ **F,,2222222,,** = (cities_id-> cities_name 466 \\ reports_id-> reports_description, pets_id 467 \\ reports_id , pets_id→ users_id 458 \\ reports_id-> reports_description, pets_id, users_id 468 459 \\ pet_status_id->node, pet_status_type 469 460 \\ therapy_id->appoitmentDate, therapy_description … … 493 484 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description 494 485 ) 495 \\ **F,,22222222,,** = (reports_id-> reports_description, pets_id 496 \\ reports_id , pets_id→ users_id 486 \\ **F,,22222222,,** = (reports_id-> reports_description, pets_id, users_id 497 487 \\ pet_status_id->node, pet_status_type 498 488 \\ therapy_id->appoitmentDate, therapy_description … … 510 500 \\ **R,,22222222,, n R,,22222221,,** = cities_id, клуч за R,,22222221,, => нема губење на податоци. 511 501 512 \\ **R,,22222222,,** не е во 2NF поради reports_id-> reports_description, pets_id 513 \\ reports_id +={ reports_id, reports_description, pets_id }514 \\ **R,,222222221,,** (reports_id, reports_description, pets_id ) клуч reports_id BCNF515 \\ **F,,222222221,,** { reports_id-> reports_description, pets_id }502 \\ **R,,22222222,,** не е во 2NF поради reports_id-> reports_description, pets_id, users_id 503 \\ reports_id +={ reports_id, reports_description, pets_id, users_id} 504 \\ **R,,222222221,,** (reports_id, reports_description, pets_id, users_id) клуч reports_id BCNF 505 \\ **F,,222222221,,** { reports_id-> reports_description, pets_id, users_id} 516 506 \\ **R,,222222222,,** ( reports_id, pet_status_id, node, 517 507 pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, … … 522 512 available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description 523 513 ) 524 \\ **F,,222222222,,** = (reports_id , pets_id→ users_id 525 \\ pet_status_id->node, pet_status_type 514 \\ **F,,222222222,,** = (pet_status_id->node, pet_status_type 526 515 \\ therapy_id->appoitmentDate, therapy_description 527 516 \\ diagnostics_id-> diagnostics_description
