Changes between Version 18 and Version 19 of Normalization

Timestamp:

02/20/25 00:33:42 (43 hours ago)

Author:

175012

Comment:

--

Normalization

@@ -11 +11 @@
 
 
-=== 1. Менаџирање на клиенти и нивни податоци (Customer ,Pol_dog)
+=== 1. Менаџирање на клиенти и нивни податоци (Policy, Pol_dog, Customer)
 Првична релација (не нормализирана):
 
-R = { c_id,email,pass,type, d_embg,name,surname, birthdate,policy,kontakt }
+R = {p_id,s_date,e_date,d_embg,name,surname, birthdate,policy,kontakt,c_id,email,pass,type }
 
-||= c_id  =||=  email  =||=  password  =||=  type =||= d_embg  =||= name  =||= surname  =||=  birthdate  =||=  policy  =||= kontakt =||
-||= 1  =||=  armend@outlook.com  =||=  as12345  =||=  0  =||=  290699842  =||= Armend =||=  Selmani   =||=  19980629  =||=  1 =||= 072227959  =||
-||= 2  =||=  ardit@gmail.com  =||=  aa9876   =||=  1   =||=  290699945 =||=  Ardit =||=  Ameti  =||=  19990629  =||=  2  =||= 071234787  =||
+||= p_id =||= s_date =||= e_date =|| = d_embg  =||= name  =||= surname  =||=  birthdate  =||=  policy  =||= kontakt =||= c_id  =||=  email  =||=  password  =||=  type =||
+||= 1 =||= 2025-01-02 =||= 2025-01-12 =|| =  290699842  =||= Armend =||=  Selmani   =||=  19980629  =||=  1 =||= 072227959  =||= 1  =||=  armend@outlook.com  =||=  as12345  =||=  0  =||
+||= 2 =||= 2025-02-01 =||= 2025-02-11 =||=  290699945 =||=  Ardit =||=  Ameti  =||=  19990629  =||=  2  =||= 071234787  =||= 2  =||=  ardit@gmail.com  =||=  aa9876   =||=  1   =||
 
 Функциски зависности:
 
-c_id → email, client_pass, type
+p_id → s_date,e_date
 
 d_embg → name_surname, birthdate_policy,kontakt
 
+c_id → email, client_pass, type
+
 Декомпозиција во 3НФ:
 
-R1 = { c_id,email,pass,type }
+R1 = { p_id,s_date,e_date }
 
 R2 = { d_embg,name,surname, birthdate,policy,kontakt }
+
+R3 = { c_id,email,pass,type }