Changes between Version 23 and Version 24 of Normalization

Timestamp:

02/24/25 09:22:43 (2 days ago)

Author:

175012

Comment:

--

Normalization

@@ -33 +33 @@
 
 
-=== 2. Менаџирање на осигурителни полиси (Policy, Package,Covers)
+=== 2. Менаџирање на осигурителни полиси (Package,Covers)
 Првична релација:
 
-R = { p_id, s_date,e_date, 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 }
 
-||= p_id  =||=  s_date  =||=  e_date   =||=  code  =||=  title   =||= type_pol  =||=  total  =||=  value  =||=  cov_id  =||= cov_amount =||= cov_type =||
-||= 1  =||=  2024-02-03 =||=  2024-02-13  =||=  1  =||=  Premium Package =||= 1  =||=  20000  =||=  Den  =||=  1  =||= 2000  =||= Personal Accident Insurance =||
-||= 2  =||=  2024-12-11  =||=  2024-12-21  =||=  2  =||=  Basic Package  =||= 1  =||=  10000  =||=  Den  =||=  2  =||= 4000  =||= Medical Expenses Cover =||
+||=  code  =||=  title   =||= type_pol  =||=  total  =||=  value  =||=  cov_id  =||= cov_amount =||= cov_type =||
+||=  1  =||=  Premium Package =||= 1  =||=  20000  =||=  Den  =||=  1  =||= 2000  =||= Personal Accident Insurance =||
+||=  2  =||=  Basic Package  =||= 1  =||=  10000  =||=  Den  =||=  2  =||= 4000  =||= Medical Expenses Cover =||
 
 Функциски зависности:
-
-p_id → s_date,e_date
 
 code → title,type_pol,total,value
@@ -52 +50 @@
 Декомпозиција во 3НФ:
 
-R1 = { p_id, s_date,e_date }
+R1 = { code,title,type_pol,total,value }
 
-R2 = { code,title,type_pol,total,value }
+R2 = { cov_id,cov_amount,cov_type }
 
-R3 = { cov_id,cov_amount,cov_type }
-
-R4 = { p_id,cov_id }
 
 === 3. Менаџирање на авто осигурување (Auto_pol, Vehicle)