Changes between Version 9 and Version 10 of Normalization


Ignore:
Timestamp:
09/13/25 10:28:56 (6 days ago)
Author:
222004
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Normalization

    v9 v10  
    155155
    156156Со ваква декомпозиција ги извлекуваме следните релации:
    157 R1 { company_id, company_name, company_description, registration_number } - **во BCNF** \\
    158 R2 { medicine_id, medicine_name, medicine_active_ingredient } - **во BCNF** \\
    159 R3 { payment_method_id, payment_method_name } - **во BCNF** \\
    160 R4 { 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 } - **во BCNF** \\
    161 R5 { facility_id, company_id, facility_name, facility_code } - **во BCNF** \\
    162 R6 { inventory_id, facility_id } - **во BCNF** \\
    163 R7 { branded_medicine_id, company_id (улога: manufacturer), branded_name, branded_price, branded_description, dosage_form, strength, origin_country } - **во BCNF** \\
    164 R8 { branded_medicine_image_id, branded_medicine_id, branded_image, is_main_image } - **во BCNF** \\
    165 R9 { clubcard_id, user_id, club_program, points } - **во BCNF** \\
    166 R10 { contactinformation_id, phone, contact_address, contact_user_id, contact_facility_id } - **во BCNF**
    167 R11 { healthprofile_id, user_id (улога: client), blood_type } - **во BCNF** \\
    168 R12 { inventory_id, branded_medicine_id, quantity, last_changed } - **во BCNF** \\
    169 R13 { client_order_id, user_id (улога: client), company_id (улога: delivery), payment_id, client_order_date, client_expected_arrival_date, client_order_status, total_price } - **во BCNF** \\
    170 R14 { client_order_id, branded_medicine_id, order_quantity } - **во BCNF** \\
    171 R15 { shopping_cart_id, user_id (улога: client) } - **во BCNF** \\
    172 R16 { shopping_cart_id, branded_medicine_id, cart_quantity } - **во BCNF** \\
    173 R17 { supply_order_id, company_id (улога: distributor), company_id (улога: pharmacy), supply_order_date, supply_expected_arrival_date, supply_status, facility_id } - **во BCNF** \\
    174 R18 { supply_order_id, branded_medicine_id, supply_quantity } - **во BCNF** \\
    175 R19 { payment_id, user_id (улога: client), payment_method_id, payment_date, payment_amount, payment_status } - **во BCNF** \\
    176 R20 { prescription_id, user_id (улога: client), medicine_id, issued_by, issued_at, valid_to, prescription_embg } - **во BCNF**
    177 R21 { sensitiveclientdata_id, user_id (улога: client), user_id (улога: pharmacist), sensitive_embg, portrait_photo, verification_status } - **во BCNF** \\
    178 R22 { medicine_id_1, medicine_id_2, mi_type, mi_description, mi_severity } - **во BCNF** \\
    179 R23 { healthprofile_id, medicine_id, date_diagnosed, allergic_description, allergic_severity } - **во BCNF** \\
    180 R24 { branded_medicine_id, medicine_id } (Branded_Medicine_InstanceOf_Medicine) - **во BCNF** \\
    181 R25 { company_id (улога: distributor), branded_medicine_id } (Distributor_BrandedMedicine) - **во BCNF** \\
    182 R26 { company_id (улога: pharmacy), branded_medicine_id } (Pharmacy_Catalog) - **во BCNF** \\
     157**R1** { company_id, company_name, company_description, registration_number } - **во BCNF** \\
     158**R2** { medicine_id, medicine_name, medicine_active_ingredient } - **во BCNF** \\
     159**R3** { payment_method_id, payment_method_name } - **во BCNF** \\
     160**R4** { 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 } - **во BCNF** \\
     161**R5** { facility_id, company_id, facility_name, facility_code } - **во BCNF** \\
     162**R6** { inventory_id, facility_id } - **во BCNF** \\
     163**R7** { branded_medicine_id, company_id (улога: manufacturer), branded_name, branded_price, branded_description, dosage_form, strength, origin_country } - **во BCNF** \\
     164**R8** { branded_medicine_image_id, branded_medicine_id, branded_image, is_main_image } - **во BCNF** \\
     165**R9** { clubcard_id, user_id, club_program, points } - **во BCNF** \\
     166**R10** { contactinformation_id, phone, contact_address, contact_user_id, contact_facility_id } - **во BCNF**
     167**R11** { healthprofile_id, user_id (улога: client), blood_type } - **во BCNF** \\
     168**R12** { inventory_id, branded_medicine_id, quantity, last_changed } - **во BCNF** \\
     169**R13** { client_order_id, user_id (улога: client), company_id (улога: delivery), payment_id, client_order_date, client_expected_arrival_date, client_order_status, total_price } - **во BCNF** \\
     170**R14** { client_order_id, branded_medicine_id, order_quantity } - **во BCNF** \\
     171**R15** { shopping_cart_id, user_id (улога: client) } - **во BCNF** \\
     172**R16** { shopping_cart_id, branded_medicine_id, cart_quantity } - **во BCNF** \\
     173**R17** { supply_order_id, company_id (улога: distributor), company_id (улога: pharmacy), supply_order_date, supply_expected_arrival_date, supply_status, facility_id } - **во BCNF** \\
     174**R18** { supply_order_id, branded_medicine_id, supply_quantity } - **во BCNF** \\
     175**R19** { payment_id, user_id (улога: client), payment_method_id, payment_date, payment_amount, payment_status } - **во BCNF** \\
     176**R20** { prescription_id, user_id (улога: client), medicine_id, issued_by, issued_at, valid_to, prescription_embg } - **во BCNF**
     177**R21** { sensitiveclientdata_id, user_id (улога: client), user_id (улога: pharmacist), sensitive_embg, portrait_photo, verification_status } - **во BCNF** \\
     178**R22** { medicine_id_1, medicine_id_2, mi_type, mi_description, mi_severity } - **во BCNF** \\
     179**R23** { healthprofile_id, medicine_id, date_diagnosed, allergic_description, allergic_severity } - **во BCNF** \\
     180**R24** { branded_medicine_id, medicine_id } (Branded_Medicine_InstanceOf_Medicine) - **во BCNF** \\
     181**R25** { company_id (улога: distributor), branded_medicine_id } (Distributor_BrandedMedicine) - **во BCNF** \\
     182**R26** { company_id (улога: pharmacy), branded_medicine_id } (Pharmacy_Catalog) - **во BCNF** \\
    183183
    184184
    … …  
    220220**AllergicReaction_HealthProfile_Medicine** { healthprofile_id, medicine_id, date_diagnosed, allergic_description, allergic_severity } - **BCNF** \\
    221221
    222 Дополнителни релациите Company и Client ги поделив на подтипови кои ги рефернецираат id-то на нивните родители. Оваа поделба ја правиме за подобра контекстуализација, и овие ентитети (освен Client, на кој му е додаден атрибутот is_verified, кој е одземен на самиот user, затпа што има повеќе логика да постои само кај клиент) не соддржат дополнителни аттрибути. Сите во BCNF:
     222Дополнителни релациите Company и Client ги поделивме на подтипови кои ги рефернецираат id-то на нивните родители. Оваа поделба ја правиме за подобра контекстуализација, и овие ентитети (освен Client, на кој му е додаден атрибутот is_verified, кој е одземен на самиот user, затпа што има повеќе логика да постои само кај клиент) не соддржат дополнителни аттрибути. Сите во BCNF:
    223223
    224224**Admins** { user_id } \\