Changes between Version 1 and Version 2 of Normalization

Timestamp:

08/28/25 18:32:10 (2 months ago)

Author:

185022

Comment:

--

Normalization

@@ -1 +1 @@
 = Нормализација и подобрување на дизајн
+
+== Определување функционални зависности
+R = {user_id, user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id, city_name, region_id, region_name, cust_EDB, cust_company_name, cust_adr, cust_representative_img, wh_id, wh_adr, veh_id, veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin,veh_reg_date, ctg_id, ctg_name, man_id, man_name, man_adr, man_mobile, man_email, art_id, art_name, art_image, art_weight, price_id, price, price_eff_date, pf_id, pf_deadline, pf_date_created, pf_status_id, pf_status_name, pf_status_desc, del_id, del_date_created, del_date, del_start_km, del_end_km, del_start_time, del_end_time, d_status_id, d_status_name, d_status_desc, ord_id, ord_date, ord_sum, ord_fulfillment_date, ord_comment, o_status_id, o_status_name, o_status_desc, unit_id, unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, day_id, day_name, cust_day_id, start_time, end_time, t_id, t_value, t_date, t_type, t_expiry, t_validated_at, t_user, img_id, img_path, img_ent_type, img_ent_id}
+
+=== Функционални зависности
+==== Users and related entities
+
+user_id → user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, clazz_, user_role, city_id
+
+==== Customer extends User
+
+user_id → cust_EDB, cust_company_name, cust_adr, cust_representative_img  (where clazz_ = 'customer')
+
+==== Manager extends User
+
+user_id → wh_id  (where clazz_ = 'manager')
+
+==== Driver extends User
+
+user_id → veh_id  (where clazz_ = 'driver')
+
+==== Location data
+
+city_id → city_name, region_id
+
+region_id → region_name
+
+==== Warehouse
+
+wh_id → wh_adr, city_id
+
+==== Vehicle
+
+veh_id → veh_carry_weight, veh_service_interval, veh_kilometers, veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, wh_id
+
+==== Categories
+
+ctg_id → ctg_name
+
+==== Manufacturer
+
+man_id → man_name, man_adr, man_mobile, man_email
+
+==== Article
+
+art_id → art_name, art_image, art_weight, ctg_id, man_id
+
+==== Price
+
+price_id → price, price_eff_date, art_id
+
+==== Pro forma
+
+pf_id → pf_deadline, pf_date_created, pf_status_id
+
+pf_status_id → pf_status_name, pf_status_desc
+
+==== Delivery
+
+del_id → del_date_created, del_date, del_start_km, del_end_km, del_start_time, del_end_time, d_status_id, veh_id
+
+d_status_id → d_status_name, d_status_desc
+
+==== Order
+ord_id → ord_date, ord_sum, ord_fulfillment_date, ord_comment, o_status_id, cust_id, del_id, pf_id
+
+o_status_id → o_status_name, o_status_desc
+
+==== Article unit
+unit_id → unit_expiration_date, unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, wh_id, ord_id
+
+==== Weekday
+day_id → day_name
+
+==== Customer weekday
+cust_day_id → cust_id, day_id, start_time, end_time
+
+==== Token
+t_id → t_value, t_date, t_type, t_expiry, t_validated_at, t_user
+
+==== Image store
+img_id → img_path, img_ent_type, img_ent_id
+
+=== Класификација на атрибути
+==== Лево - атрибути кои одредуваат други
+cust_day_id, price_id, pf_id, del_id, ord_id, unit_id, t_id, img_id
+==== Лево и десно - атрибути кои одредуваат други и се одредени од други
+user_id, city_id, region_id, wh_id, veh_id, ctg_id, man_id, art_id, d_status_id, o_status_id, pf_status_id, day_id
+==== Десно - атрибути кои се одредени од други
+user_name, user_surname, user_pass, user_salt, user_email, user_mobile, user_active, user_image, 
+clazz_, user_role, city_name, region_name, cust_EDB, cust_company_name, cust_adr, cust_representative_img, wh_adr, veh_carry_weight, veh_service_interval, veh_kilometers, 
+veh_last_service, veh_last_service_km, veh_plate, veh_vin, veh_reg_date, ctg_name, man_name, 
+man_adr, man_mobile, man_email, art_name, art_image, art_weight, price, price_eff_date, 
+pf_deadline, pf_date_created, pf_status_name, pf_status_desc, del_date_created, del_date, 
+del_start_km, del_end_km, del_start_time, del_end_time, d_status_name, d_status_desc, ord_date, 
+ord_sum, ord_fulfillment_date, ord_comment, o_status_name, o_status_desc, unit_expiration_date, 
+unit_serial_number, unit_batch_number, unit_manufacture_date, unit_cost_price, day_name, 
+start_time, end_time, t_value, t_date, t_type, t_expiry, t_validated_at, t_user, img_path, 
+img_ent_type, img_ent_id