= Нормализација и подобрување на дизајн

== Определување функционални зависности
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