Логички и физички дизајн

(in progress...)

Релациска шема

Мапирачка трансформација

Ознаки: bold - not null, underline - primary key, *foreign key

Ентитети

User (id_user, date_created_user, name_user, email_user, password_user, telephone_user)

Adopter (id_user*(user), free_time, funds, has_other_pets, has_kids, housing, physical_activity_adopters, will_foster, is_verified)

Surendee (id_user*(user))

Employee (id_user*(user), position)

Admin (id_user*(user))

Donor (id_user*(user), is_from_organisation)

Organization (id_organisation, name_organisation, email_organisation, billing_information)

Shelter (id_shelter, address_shelter, telephone_shelter)

Post (id_post, date_post, url_thumbanail)

• ограничување: Post мора да биде во точно една од релациите surrendees_publishes_and_manages_posts или employee_publishes_and_manages_post, не смее да не биде во ниту една или пак во двете

Adoption (id_adoption, start_date, end_date_foster)

Pet (id_pet, url_pet_image, age_group, size, breed, name_pet, species, gender, can_be_fostered)

Category (id_category, name_category)

Food (id_food, manufacturer, name_food, type)

Therapy (id_therapy, health_problem, start_date, end_date)

VetClinic (id_vet_clinic, telephone_vet_clinic, address_vet_clinic)

Слаби Ентитети

PersonalProfile (id_pet*(pet), friendly_to_kids, friendly_to_pets, attention, physical_activity, grooming_needed)

М-М Релации

donor_donates_to_organisation (id_user*(donor), id_organisation*(organisation))

adopter_views_post (id_user*(adopter), id_post*(post))

pet_belongs_to_category (id_pet*(pet), id_category*(category))

pet_needs_therapy (id_pet*(pet), id_therapy*(therapy))

pet_preferably_eats_food (id_pet*(pet), id_food*(food), quantity_a_day)

pet_needs_intervention_in_vet_clinic (id_pet*(pet), id_vet_clinic*(vetClinic), date_of_interventing)

Релациски дијаграм

DML скрипти

• скрипта за бришење на табелите и креирање на табелите

kreiranje.sql

• скрипта за полнење на табелите со податоци

polnenje.sql

​Назад кон почетна