Changes between Version 26 and Version 27 of Normalization

Timestamp:

02/24/25 11:20:15 (2 days ago)

Author:

175012

Comment:

--

Normalization

@@ -14 +14 @@
 Првична релација (не нормализирана):
 
-R = {**d_embg**,name,surname, birthdate,policy,kontakt,**c_id**,email,pass,type }
+R = {**d_embg** ,name,surname, birthdate,policy,kontakt, **c_id** ,email,pass,type }
 
 ||= d_embg  =||= name  =||= surname  =||=  birthdate  =||=  policy  =||= kontakt =||= c_id  =||=  email  =||=  password  =||=  type =||
@@ -28 +28 @@
 Декомпозиција во 3НФ:
 
-R1 = { **d_embg**,name,surname, birthdate,policy,kontakt }
+R1 = { **d_embg** ,name,surname, birthdate,policy,kontakt }
 
-R2 = { **c_id**,email,pass,type }
+R2 = { **c_id** ,email,pass,type }
 
 
@@ -36 +36 @@
 Првична релација:
 
-R = { code,title, type_pol, total, value, cov_id, cov_amount, cov_type }
+R = { **code** ,title, type_pol, total, value, **cov_id** , cov_amount, cov_type }
 
 ||=  code  =||=  title   =||= type_pol  =||=  total  =||=  value  =||=  cov_id  =||= cov_amount =||= cov_type =||
@@ -44 +44 @@
 Функциски зависности:
 
-code → title,type_pol,total,value
+**code** → title,type_pol,total,value
 
-cov_id → cov_amount,cov_type
+**cov_id** → cov_amount,cov_type
 
 Декомпозиција во 3НФ:
 
-R1 = { code,title,type_pol,total,value }
+R1 = { **code** ,title,type_pol,total,value }
 
-R2 = { cov_id,cov_amount,cov_type }
+R2 = { **cov_id** ,cov_amount,cov_type }
 
-R3 = { code,cov_id }
+R3 = { **code** , **cov_id** }
 
 === 3. Менаџирање на осигурување (Policy,Auto_pol,Vehicle,Property_pol,Property,Travel_pol,Pol_osi)
 Првична релација:
 
-R = { p_id, s_date, e_date, a_id, pol_id, v_id, marka, model, license_plate, type, pr_id, pol_id, prop_id, address, floor, year_build, security, tr_id, pol_id, o_embg, name, surname, birthdate, kontakt}
+R = { **p_id** , s_date, e_date, **a_id** , pol_id, **v_id** , marka, model, license_plate, type, **pr_id** , pol_id, **prop_id** , address, floor, year_build, security, **tr_id** , pol_id, **o_embg** , name, surname, birthdate, kontakt}
 
 ||= p_id =||= s_date =||= e_date =||= a_id =||=  pol_id  =||=  v_id   =||=  marka   =||=  model =||= license_plate  =||= type =||= pr_id =||= pol_id =||= prop_id =||= address =||= floor =||= year_build =||= security =||= tr_id =||= pol_id =||= o_embg =||= name =||= surname =||= birthdate =||= kontakt =||
@@ -67 +67 @@
 Функциски зависности:
 
-p_id → s_date,e_date
+**p_id** → s_date,e_date
 
-a_id → pol_id
+**a_id** → pol_id
 
-v_id → marka,model,license_plate,type
+**v_id** → marka,model,license_plate,type
 
-pr_id → pol_id
+**pr_id** → pol_id
 
-prop_id → address, floor,year_build,security
+**prop_id** → address, floor,year_build,security
 
-tr_id → pol_id
+**tr_id** → pol_id
 
-o_embg → name,surname,birthdate,kontakt
+**o_embg** → name,surname,birthdate,kontakt
 
 Декомпозиција во 3НФ:
 
-R1 = { p_id,s_date,e_date }
+R1 = { **p_id** ,s_date,e_date }
 
-R2 = { a_id,pol_id }
+R2 = { **a_id** ,pol_id }
 
-R3 = { v_id,marka,model,license_plate,type }
+R3 = { **v_id** ,marka,model,license_plate,type }
 
-R4 = { pr_id,pol_id }
+R4 = { **pr_id** ,pol_id }
 
-R5 = { prop_id,address,floor,year_build,security }
+R5 = { **prop_id** ,address,floor,year_build,security }
 
-R6 = { tr_id,pol_id}
+R6 = { **tr_id** ,pol_id}
 
-R7 = { o_embg,name,surname,birthdate,kontakt }
+R7 = { **o_embg** ,name,surname,birthdate,kontakt }
 
-
+R8 = { **p_id** , **a_id** , **v_id** , **pr_id** , **prop_id** , **tr_id** , **o_embg** }