Changes between Version 12 and Version 13 of Normalization

Timestamp:

09/13/25 17:21:49 (6 days ago)

Author:

222003

Comment:

--

Normalization

@@ -127 +127 @@
 == Декомпозиција во 2НФ ==
 За да ги отстраниме парцијалните зависиности ги делиме атрибутите во релации каде не-клучните атрибути целосно зависат од нивниот клуч:
-company_id → company_name, company_description, registration_number \\
-medicine_id → medicine_name, medicine_active_ingredient \\
-payment_method_id → payment_method_name \\
-user_id → first_name, last_name, username, hashed_password, e_mail, gender, date_created, date_of_birth, is_account_non_expired, is_account_non_locked, is_credentials_non_expired, is_enabled, is_verified (Client) \\
-facility_id → company_id, facility_name, facility_code \\
-inventory_id → facility_id \\
-branded_medicine_id → company_id (улога: manufacturer), branded_name, branded_price, branded_description, dosage_form, strength, origin_country \\
-branded_medicine_image_id → branded_medicine_id, branded_image, is_main_image \\
-clubcard_id → user_id, club_program, points \\
-contactinformation_id → phone, contact_address, contact_user_id, contact_facility_id \\
-healthprofile_id → user_id (улога: client), blood_type \\
-inventory_id, branded_medicine_id → quantity, last_changed \\
-client_order_id → user_id (улога: client), company_id (улога: delivery), payment_id, client_order_date, client_expected_arrival_date, client_order_status, total_price 
-client_order_id, branded_medicine_id → order_quantity \\
-shopping_cart_id → user_id (улога: client) \\
-shopping_cart_id, branded_medicine_id → cart_quantity
-supply_order_id → company_id (улога: distributor), company_id (улога: pharmacy), supply_order_date, supply_expected_arrival_date, supply_status, facility_id \\
-supply_order_id, branded_medicine_id → supply_quantity \\
-payment_id → user_id (улога: client), payment_method_id, payment_date, payment_amount, payment_status \\
-prescription_id → user_id (улога: client), medicine_id, issued_by, issued_at, valid_to, prescription_embg \\
-sensitiveclientdata_id → user_id (улога: client), user_id (улога: pharmacist), sensitive_embg, portrait_photo, verification_status \\
-medicine_id_1, medicine_id_2 → mi_type, mi_description, mi_severity \\
-healthprofile_id, medicine_id → date_diagnosed, allergic_description, allergic_severity \\
-branded_medicine_id, medicine_id → / \\
-company_id (улога: distributor), branded_medicine_id → / \\
-company_id (улога: pharmacy), branded_medicine_id → / \\
+**company_id** → company_name, company_description, registration_number \\
+**medicine_id** → medicine_name, medicine_active_ingredient \\
+**payment_method_id** → payment_method_name \\
+**user_id** → first_name, last_name, username, hashed_password, e_mail, gender, date_created, date_of_birth, is_account_non_expired, is_account_non_locked, is_credentials_non_expired, is_enabled, is_verified \\
+**facility_id** → company_id, facility_name, facility_code \\
+**inventory_id** → facility_id \\
+**branded_medicine_id** → company_id, branded_name, branded_price, branded_description, dosage_form, strength, origin_country \\
+**branded_medicine_image_id** → branded_medicine_id, branded_image, is_main_image \\
+**clubcard_id** → user_id, club_program, points \\
+**contactinformation_id** → phone, contact_address, contact_user_id, contact_facility_id \\
+**healthprofile_id** → user_id, blood_type \\
+**inventory_id, branded_medicine_id** → quantity, last_changed \\
+**client_order_id** → user_id, company_id, payment_id, client_order_date, client_expected_arrival_date, client_order_status, total_price 
+**client_order_id, branded_medicine_id** → order_quantity \\
+**shopping_cart_id** → user_id \\
+**shopping_cart_id, branded_medicine_id** → cart_quantity
+**supply_order_id** → company_id, company_id, supply_order_date, supply_expected_arrival_date, supply_status, facility_id \\
+**supply_order_id, branded_medicine_id** → supply_quantity \\
+**payment_id** → user_id, payment_method_id, payment_date, payment_amount, payment_status \\
+**prescription_id** → user_id, medicine_id, issued_by, issued_at, valid_to, prescription_embg \\
+**sensitiveclientdata_id** → user_id, user_id, sensitive_embg, portrait_photo, verification_status \\
+**medicine_id_1, medicine_id_2** → mi_type, mi_description, mi_severity \\
+**healthprofile_id, medicine_id** → date_diagnosed, allergic_description, allergic_severity \\
+**branded_medicine_id, medicine_id** → / \\
+**company_id, branded_medicine_id** → / \\
+**company_id, branded_medicine_id** → / \\
 
 Со ваква декомпозиција ги извлекуваме следните релации: