A) Oпределување на важечките функциски зависности

Тргнуваме од список во кој сите атрибути имаат различни имиња. За таа цел атрибутите кои што имаат исти имиња ги преименувавме. Во продолжение е списокот на атрибути кои што се преименувани.

*id (Кај ентитетот Users) = users_id
*id (Кај ентитетот Pet_Cares) = pet_cares_id
*id (Kaj ентитетот Blog_Post_For_Consultation) = blog_post_for_consultation_id
*id (Kaj ентитетот Blog_Post_Answers) = blog_post_answers_id
*id (Kaj ентитетот Jobs) = jobs_id 
*id (Kaj ентитетот Vet_Centers)  = vet_centers_id
*id (Kaj ентитетот Cities) = cities_id
*id (Kaj ентитетот Roles)  = roles_id
*id (Kaj ентитетот Reports) = reports_id
*id (Kaj ентитетот Pet_Status) = pet_status_id
*id (Kaj ентитетот Therapy) = therapy_id
*id (Kaj ентитетот Diagnostics) = diagnostics_id
*id (Kaj ентитетот Medecines) = medecines_id
*id (Kaj ентитетот Manufacturers) = manufacturers_id
*id (Kaj ентитетот Pets) = pets_id
*id (Kaj ентитетот Pet_Galery) = pet_galery_id
*id (Kaj ентитетот Orders) = orders_id
*id (Kaj ентитетот Products) = products_id
*id (Kaj ентитетот Type_Of_Pets) = type_of_pets_id
*id (Kaj ентитетот Breeds) = breeds_id
*title (Kaj ентитетот Blog_Post_For_Consultations) = blog_post_title
*description (Kaj ентитетот Blog_Post_For_Consultations) = blog_post_description
*description (Kaj ентитетот Jobs) = jobs_description
*description (Kaj ентитетот Vet_Centers) = vet_centers_description 
*name (Kaj ентитетот Cities) = cities_name
*description (Kaj ентитетот Reports) = reports_description
*type (Kaj ентитетот Pet_Status) = pet_status_type
*description (Kaj ентитетот Therapy) = therapy_description
*description (Kaj ентитетот Diagnostics) = diagnostics_description
*name (Kaj ентитетот Medecines) = medecines_name
*description (Kaj ентитетот Medecines) = medecines_description
*name (Kaj ентитетот Manufacturers) = manufacturers_name
*description (Kaj ентитетот Manufacturers) = manufacturers_description
*name (Kaj ентитетот Pets) = pets_name
*description (Kaj ентитетот Pets) = pets_description
*name (Kaj ентитетот Products) = products_name
*description (Kaj ентитетот Products) = products_description
*description (Kaj ентитетот Type_Of_Pets) = type_of_pets_description
*name (Kaj ентитетот Breeds) = breeds_name

Функциски зависности

R(jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
latitude, longitude,roles_id, type, users_id, first_name, last_name,
phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, 
pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, 
diagnostics_description, medecines_id, manufacturers_name, medecines_description, 
manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
products_id, products_name, products_description, category, dateAdded,isActive, price, 
available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description)                 

• jobs_id -> jobs_description, predistedSalery (Секоја работна позиција си има опис и предвидена плата).
• pet_cares_id ->title, description, start_date, dateEnding (Секоја услуга си има име, опис, датум на започнување и датум на завршување).
• vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude (Секој вет. центар си има име, адреса, работни часови, координати ( гео. должина и ширина).
• roles_id->type (Секоја улога си има свој тип).
• users_id -> first_name, last_name, phoneNumber, email, password, roles_id (Секој корисник има име, презиме, тел.број, емаил и пасворд.Секој корисник може да има само една улога: стандарден корисник, менаџер, вработен или админ. Според улогата корисникот добива одредени привилегии).
• blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id (Секое поставено прашање/побарана консултција има наслов, опис, и датум на поставување. Секој побаран совет/прашање е напишен од одреден корисник).
• blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id (Секој одговор е даден врз основа на поставено прашање, има содржина и датум кога е одговорено. Секој одговор е поврзан со едно прашање за консултација и е даден од еден корисник).
• cities_id-> cities_name (Секој град си има име).
• reports_id-> reports_description, pets_id, users_id (Секој извештај има опис. Секој извештај припаѓа на едно милениче.Секој извештај за одредено милениче е напишан од еден корисник-доктор).
• pet_status_id->node, pet_status_type (Секој статус има забелешка и тип).
• therapy_id->appoitmentDate, therapy_description (Секоја терапија има датум на започнување и опис).
• diagnostics_id-> diagnostics_description (Секоја дијагноза има опис).
• medecines_id-> medecines_name, medecines_description, manufacturers_id (Секој лек има име, и упатство. Во нашиот проект претпоставуваме дека секој лек е произведен од само еден произведувач).
• manufacturers_id->city, state, manufacturers_name, manufacturers_description (Секој производител на лекот има град, држава, име и опис).
• pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id (Секое милениче има име, боја, датум на раѓање и опис. Секое милениче припаѓа на еден вид. Секое милениче има само еден сопственик, во нашата база не е возможно едно милениче да има повеќе сопственици. Кога се врши микрочипирање се запишуваат податоци само од еден сопственик. Секое милениче во еден ветеринарен центар има само еден активен статус во даден момент. Кога статусот се менува, се брише претходниот и се запишува нов).
• pet_galery_id->image, pets_id (Секоја слика во галеријата е поврзана само со едно милениче, во нашиот проект имаме замислено на една слика да има само едно милениче за поголема прегледност на идните вдомувачи).
• orders_id → userid (Секоја нарачка е направена од еден корисник).
• products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity (Секој продукт има име, опис, категорија, датум кога е додаден во системот, дали е достапен, цена и достапна количина).
• products_id, orders_id → quantity (Секој продукт кој што се наоѓа во нарачката има одредена нарачана количина).
• breeds_id-> breeds_name, type_of_pets_id (Секоја раса си има име. Секоја раса припаѓа на еден вид на милениче, Пр.расата Scottish Fold припага само на видот маче не припага и на видот куче итн).
• type_of_pets_id->kind_of_pet, type_of_pets_description (Секој вид на милениче има име и опис).

Определување на кандидат клучеви

Од лева страна се наоѓаат следниве атрибути:
jobs_id, pet_cares_id, vet_centers_id, blog_post_answers_id, cities_id, reports_id, therapy_id, 
diagnostics_id, medecines_id, manufacturers_id, pet_galery_id, products_id, breeds_id, orders_id .


Од десна страна се наоѓаат следниве атрибути:
jobs_description, predistedSalery, title, description, start_date, dateEnding, name, address, 
vet_centers_description, workingHours, latitude, longitude, type, first_name, last_name, 
phoneNumber, email, password, blog_post_title, blog_post_description, dateAsked, parent_id,
reply, date_answers, cities_name, reports_description, node, pet_status_type, appoitmentDate, 
therapy_description, diagnostics_description, medecines_name, medecines_description, city,
state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, 
pets_description, image, products_name, products_description, category, dateAdded, isActive,
price, available_quantity, quantity, breeds_name, kind_of_pet, type_of_pets_description.


Од десна и лева страна се наоѓаат следниве атрибути:
roles_id, users_id, blog_post_for_consultation_id, pets_id, type_of_pets_id, pet_status_id.


Започнуваме од тривијален суперклуч па постепено отстрануваме атрибути
{jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
latitude, longitude, roles_id, type, users_id, first_name, last_name,
phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, 
pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, 
diagnostics_description, medecines_id, medecines_description, 
manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
products_id, products_name, products_description, category, dateAdded,isActive, price, 
available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description} 
+=
{jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
latitude, longitude,roles_id, type, users_id, first_name, last_name,
phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, 
pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, 
diagnostics_description, medecines_id, medecines_description, 
manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
products_id, products_name, products_description, category, dateAdded,isActive, price, 
available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description}



Атрибутите кои што се наоѓаат само од десна страна може да ги отстраниме. 
Со тоа ги острануваме следниве атрибути:
jobs_description, predistedSalery, title, description, start_date, dateEnding, name, address, 
vet_centers_description, workingHours, latitude, longitude, type, first_name, last_name, 
phoneNumber, email, password, blog_post_title, blog_post_description, dateAsked, parent_id,
reply, date_answers, cities_name, reports_description, node, pet_status_type, appoitmentDate, 
therapy_description, diagnostics_description, medecines_name, medecines_description, city,
state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, 
pets_description, image, products_name, products_description, category, dateAdded, isActive,
price, available_quantity, quantity, breeds_name, kind_of_pet, type_of_pets_description.

{jobs_id, pet_cares_id, title, description, start_date,vet_centers_id, roles_id, users_id, 
blog_post_for_consultation_id, blog_post_answers_id, cities_id, reports_id, pets_id, 
pet_status_id, therapy_id, diagnostics_id, medecines_id, manufacturers_id, type_of_pets_id, 
pet_galery_id, orders_id, products_id, products_name, products_description, category, 
dateAdded,isActive, breeds_id, kind_of_pet} +=
{jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
latitude, longitude,roles_id, type, users_id, first_name, last_name,
phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, 
pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, 
diagnostics_description, medecines_id, medecines_description, 
manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
products_id, products_name, products_description, category, dateAdded,isActive, price, 
available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description}



Можеме да го отстраниме и pets_id бидејќи се добива преку pet_galery_id. 
Можеме да го отстраниме и pet_status_id бидејќи се добива преку pets_id.
Можеме да го отстраниме и type_of_pets_id бидејќи се добива преку breeds_id. 
Можеме да го отстраниме и blog_post_for_consultation_id бидејќи се добова преку 
blog_post_answers_id.
Можеме да го отстраниме и users_id бидејќи се добива преку orders_id.
Можеме да го отстраниме и roles_id бидејќи се добива преку users_id.



За кандидат клуч добивме:
{jobs_id, pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id, 
pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id, diagnostics_id}.

Ниту еден од атрибутите го нема од десна страна во ф.з па ова ни е единствен кандидат клуч,
го прогласуваме за примарен клуч.


{jobs_id, pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id, 
pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id, diagnostics_id} += 
{jobs_id, jobs_description, predistedSalery, pet_cares_id, title, description, start_date, 
dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, 
latitude, longitude,roles_id, type, users_id, first_name, last_name,
phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title,
blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, 
cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, 
pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, 
diagnostics_description, medecines_id, medecines_description, 
manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name,
color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id,
products_id, products_name, products_description, category, dateAdded,isActive, price, 
available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description}

Декомпозиција

jobs_id -> jobs_description, predistedSalery
pet_cares_id ->title, description, start_date, dateEnding
vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
roles_id->type
users_id -> first_name, last_name, phoneNumber, email, password, roles_id
blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description

Во вака дефинираната релација нема повеќекратни зависности и атрибути и нема вгнездени релации, па оттука следува дека задоволува 1NF.

jobs_id → jobs_description, predistedSalery - Нарушува 2NF бидејќи има парцијална зависност. jobs_id е подмножество на к.к а десно имаме непримарни атрибути.
jobs_id +={ jobs_id, jobs_description, predistedSalery }
R₁ (jobs_id, jobs_description, predistedSalery) клуч jobs_id, BCNF.
Со наоѓање на сите затварачи
F₁ = { jobs_id → jobs_description, predistedSalery }
R₂ (jobs_id, pet_cares_id, title, description, start_date, dateEnding,vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude,roles_id, type, users_id, first_name, last_name, phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
Со наоѓање на сите затварачи
F₂ = (pet_cares_id ->title, description, start_date, dateEnding
vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
roles_id->type
users_id -> first_name, last_name, phoneNumber, email, password, roles_id
blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
Клуч (pet_cares_id, blog_post_answers_id, cities_id, reports_id, therapy_id, medecines_id, pet_galery_id, orders_id, products_id, breeds_id, vet_centers_id)
R₁ n R₂ = jobs_id, клуч за R₁ што значи нема губење на податоци.
-----------------
Разгледуваме R₁ e vo 2NF e vo 3NF e vo BCNF

-------------------
R₂ не е во 2NF поради pet_cares_id ->title, description, start_date, dateEnding
pet_cares_id +={ pet_cares_id , title, description, start_date, dateEnding}
R₂₁ (pet_cares_id , title, description, start_date, dateEnding) клуч pet_cares_id, BCNF
F₂₁ { pet_cares_id ->title, description, start_date, dateEnding}
R₂₂ (pet_cares_id, vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude,roles_id, type, users_id, first_name, last_name, phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F₂₂ = ( vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
roles_id->type
users_id -> first_name, last_name, phoneNumber, email, password, roles_id
blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R₂₂ n R₂₁ = pet_cares_id, клуч за R₂₁ => нема губење на податоци.

R₂₂ не е во 2NF поради vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude
vet_centers_id +={ vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude}
R₂₂₁ (vet_centers_id, name, address, vet_centers_description, workingHours, latitude, longitude) клуч vet_centers_id, BCNF
F₂₂₁ { vet_centers_id-> name, address, vet_centers_description, workingHours, latitude, longitude}
R₂₂₂ (vet_centers_id,roles_id, type, users_id, first_name, last_name, phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, manufacturers_name, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F₂₂₂ = (roles_id->type
users_id -> first_name, last_name, phoneNumber, email, password, roles_id
blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description
medecines_id → manufacturers_id)
R₂₂₂ n R₂₂₁ = vet_centers_id, клуч за R221 => нема губење на податоци.

R₂₂₂ не е во 3NF поради roles_id->type
roles_id +={roles_id, type}
R₂₂₂₁ (roles_id, type) клуч roles_id BCNF
F₂₂₂₁ { roles_id-> type}
R₂₂₂₂ (roles_id, users_id, first_name, last_name, phoneNumber, email, password, blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F₂₂₂₂ = (users_id -> first_name, last_name, phoneNumber, email, password, roles_id
blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R₂₂₂₂ n R₂₂₂₁ = roles_id, клуч за R2221 => нема губење на податоци.

R₂₂₂₂ не е во 3NF поради users_id -> first_name, last_name, phoneNumber, email, password, roles_id
users_id +={users_id, first_name, last_name, phoneNumber, email, password, roles_id}
R₂₂₂₂₁ (users_id, first_name, last_name, phoneNumber, email, password, roles_id) клуч users_id BCNF
F₂₂₂₂₁ { users_id -> first_name, last_name, phoneNumber, email, password, roles_id }
R₂₂₂₂₂ (users_id, blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, blog_post_answers_id, parent_id, reply, date_answers, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
_F22222 = (blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R₂₂₂₂₂ n R₂₂₂₂₁ = users_id, клуч за R22221 => нема губење на податоци.

R₂₂₂₂₂ не е во 3NF поради blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id
blog_post_for_consultation_id +={blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, users_id}
R₂₂₂₂₂₁ (blog_post_for_consultation_id, blog_post_title, blog_post_description, dateAsked, users_id) клуч blog_post_for_consultation_id BCNF
F₂₂₂₂₂₁ { blog_post_for_consultation_id -> blog_post_title, blog_post_description, dateAsked, users_id}
R₂₂₂₂₂₂ (blog_post_for_consultation_id,blog_post_answers_id, parent_id, reply, date_answers, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F₂₂₂₂₂₂ = (blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R₂₂₂₂₂₂ n R₂₂₂₂₂₁ = blog_post_for_consultation_id, клуч за R₂₂₂₂₂₁ => нема губење на податоци.

R₂₂₂₂₂₂ не е во 2NF поради blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id
blog_post_answers_id +={blog_post_answers_id, parent_id, reply, date_answers, blog_post_for_consultation_id, users_id}
R_2222221 (blog_post_answers_id, parent_id, reply, date_answers, blog_post_for_consultation_id, users_id) клуч blog_post_answers_id BCNF
F_2222221 { blog_post_answers_id ->parent_id, reply, date_answers, blog_post_for_consultation_id, users_id}
R_2222222 (blog_post_answers_id, cities_id, cities_name, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_2222222 = (cities_id-> cities_name
reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_2222222 n R_2222221 = blog_post_answers_id, клуч за R_2222221 => нема губење на податоци.

R_2222222 не е во 2NF поради cities_id-> cities_name
cities_id +={cities_id, cities_name}
R_22222221 (cities_id, cities_name) клуч cities_id BCNF
F_22222221 { cities_id-> cities_name}
R_22222222 ( cities_id, reports_id, reports_description, pets_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_22222222 = (reports_id-> reports_description, pets_id, users_id
pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_22222222 n R_22222221 = cities_id, клуч за R_22222221 => нема губење на податоци.

R_22222222 не е во 2NF поради reports_id-> reports_description, pets_id, users_id
reports_id +={ reports_id, reports_description, pets_id, users_id}
R_222222221 (reports_id, reports_description, pets_id, users_id) клуч reports_id BCNF
F_222222221 { reports_id-> reports_description, pets_id, users_id}
R_222222222 ( reports_id, pet_status_id, node, pet_status_type, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_222222222 = (pet_status_id->node, pet_status_type
therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_222222222 n R_222222221 = reports_id, клуч за R_222222221 => нема губење на податоци.

R_222222222 не е во 3NF поради pet_status_id->node, pet_status_type
pet_status_id +={pet_status_id, node, pet_status_type}
R_2222222221 (pet_status_id, node, pet_status_type) клуч pet_status_id BCNF
F_2222222221 {pet_status_id->node, pet_status_type}
R_2222222222 ( pet_status_id, therapy_id, appoitmentDate, therapy_description, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_2222222222 = (therapy_id->appoitmentDate, therapy_description
diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_2222222222 n R_2222222221 = pet_status_id, клуч за R_2222222221 => нема губење на податоци.

R_2222222222 не е во 2NF поради therapy_id->appoitmentDate, therapy_description
therapy_id +={ therapy_id, appoitmentDate, therapy_description}
R_22222222221 (therapy_id, appoitmentDate, therapy_description) клуч therapy_id BCNF
F_22222222221 {therapy_id->appoitmentDate, therapy_description}
R_22222222222 ( therapy_id, diagnostics_id, diagnostics_description, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_22222222222 = (diagnostics_id-> diagnostics_description
medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_22222222222 n R_22222222221 = therapy_id, клуч за R_22222222221 => нема губење на податоци.

R_22222222222 не е во 2NF поради diagnostics_id-> diagnostics_description
diagnostics_id +={ diagnostics_id, diagnostics_description}
R_222222222221 (diagnostics_id, diagnostics_description) клуч diagnostics_id BCNF
F_222222222221 {diagnostics_id-> diagnostics_description}
R_222222222222 ( diagnostics_id, medecines_id, medecines_description, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_222222222222 = (medecines_id-> medecines_name, medecines_description, manufacturers_id
manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description

)
R_222222222222 n R_222222222221 = diagnostics_id, клуч за R_222222222221 => нема губење на податоци.

R_222222222222 не е во 2NF поради medecines_id-> medecines_name, medecines_description, manufacturers_id
medecines_id +={ medecines_id, medecines_name, medecines_description, manufacturers_id }
R_{2222222222221} ( medecines_id, medecines_name, medecines_description, manufacturers_id) клуч medecines_id BCNF
F_{2222222222221} {medecines_id-> medecines_name, medecines_description, manufacturers_id }
R_{2222222222222} ( medecines_id, manufacturers_id, city, state, manufacturers_name, manufacturers_description, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{2222222222222} = (manufacturers_id->city, state, manufacturers_name, manufacturers_description
pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{2222222222222} n R_{2222222222221} = medecines_id, клуч за R_{2222222222221} => нема губење на податоци.

R_{2222222222222} не е во 3NF поради manufacturers_id->city, state, manufacturers_name, manufacturers_description
manufacturers_id+={ manufacturers_id, city, state, manufacturers_name, manufacturers_description}
R_{22222222222221} ( manufacturers_id, city, state, manufacturers_name, manufacturers_description) клуч manufacturers_id BCNF
F_{22222222222221} {manufacturers_id->city, state, manufacturers_name, manufacturers_description }
R_{22222222222222} ( manufacturers_id, pets_name,color, dateOfBirthday, pets_description, type_of_pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{22222222222222} = (pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{22222222222222} n R_{22222222222221} = manufacturers_id, клуч за R_{22222222222221} => нема губење на податоци.

R_{22222222222222} не е во 3NF поради pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id
pets_id+={ pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id}
R_{222222222222221} ( pets_id, pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id) клуч pets_id BCNF
F_{222222222222221} {pets_id-> pets_name, color, dateOfBirthday, pets_description, type_of_pets_id, users_id, pet_status_id}
R_{222222222222222} ( pets_id, pet_galery_id, image, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{222222222222222} = (pet_galery_id->image, pets_id
orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{222222222222222} n R_{222222222222221} = pets_id, клуч за R_{222222222222221} => нема губење на податоци.

R_{222222222222222} не е во 2NF поради pet_galery_id->image, pets_id
pet_galery_id+={ pet_galery_id, image, pets_id}
R_{2222222222222221} (pet_galery_id, image, pets_id) клуч pet_galery_id BCNF
F_{2222222222222221} {pet_galery_id->image, pets_id}
R_{2222222222222222} ( pet_galery_id, orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{2222222222222222} = (orders_id → userid
products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{2222222222222222} n R_{2222222222222221} = pet_galery_id, клуч за R_{2222222222222221} => нема губење на податоци.

R_{2222222222222222} не е во 2NF поради orders_id → userid
orders_id +={ orders_id, userid}
R_{22222222222222221} (orders_id, userid) клуч orders_id, BCNF
F_{22222222222222221} {orders_id → userid}
R_{22222222222222222} ( orders_id, products_id, products_name, products_description, category, dateAdded,isActive, price, available_quantity, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{22222222222222222} = (products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{22222222222222222} n R_{22222222222222221} = orders_id , клуч за R_{22222222222222221} => нема губење на податоци.

R_{22222222222222222} не е во 2NF поради products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity
products_id+={ products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity}
R_{222222222222222221} (products_id, products_name, products_description, category, dateAdded, isActive, price, available_quantity) клуч products_id, BCNF
F_{222222222222222221} {products_id-> products_name, products_description, category, dateAdded, isActive, price, available_quantity}
R_{222222222222222222} (products_id, quantity, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{222222222222222222} = (products_id, orders_id → quantity
breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{222222222222222222} n R_{222222222222222221} = products_id, клуч за R_{222222222222222221} => нема губење на податоци.

R_{222222222222222222} не е во 2NF поради products_id, orders_id → quantity
products_id, orders_id +={ products_id, orders_id , quantity}
R_{2222222222222222221} (products_id, orders_id , quantity) клуч products_id, orders_id, BCNF
F_{2222222222222222221} {products_id, orders_id → quantity}
R_{2222222222222222222} (products_id, orders_id, breeds_id, breeds_name, kind_of_pet, type_of_pets_description )
F_{2222222222222222222} = (breeds_id-> breeds_name, type_of_pets_id
type_of_pets_id->kind_of_pet, type_of_pets_description )
R_{2222222222222222222} n R_{2222222222222222221} = products_id, orders_id, клуч за R_{2222222222222222221} => нема губење на податоци.

R_{2222222222222222222} не е во 2NF поради breeds_id-> breeds_name, type_of_pets_id
breeds_id+={ breeds_name, type_of_pets_id}
R_{22222222222222222221} ( breeds_id, breeds_name, type_of_pets_id) клуч breeds_id, BCNF
F_{22222222222222222221} {breeds_id-> breeds_name, type_of_pets_id }
R_{22222222222222222222} (breeds_id, kind_of_pet, type_of_pets_description )
F_{22222222222222222222} = (type_of_pets_id->kind_of_pet, type_of_pets_description)
R_{22222222222222222222} n R_{22222222222222222221} = breeds_id, клуч за R_{22222222222222222221} => нема губење на податоци.

R_{22222222222222222222} не е во 3NF поради type_of_pets_id->kind_of_pet, type_of_pets_description
type_of_pets_id+={ type_of_pets_id, kind_of_pet, type_of_pets_description}
R_{222222222222222222221} (type_of_pets_id, kind_of_pet, type_of_pets_description) клуч type_of_pets_id, BCNF
F_{222222222222222222221} {type_of_pets_id->kind_of_pet, type_of_pets_description }
R_{222222222222222222222} (type_of_pets_id)
F_{222222222222222222222} = {}
R_{222222222222222222222} n R_{222222222222222222221} = type_of_pets_id, клуч за R_{222222222222222222221} => нема губење на податоци.

Резултат