Changes between Version 12 and Version 13 of Normalization

Timestamp:

02/13/25 11:47:20 (8 days ago)

Author:

175012

Comment:

--

Normalization

@@ -16 +16 @@
 R = { client_id, client_name, client_email, client_phone, client_type_id, client_type_name, client_type_description, address_id, street, city, postcode }
 
-||= ID (client_id)  =||=  Name (client_name)  =||=  Email (client_email)  =||=  Phone (client_phone)  =||=  Type ID (client_type_id) =||= Type name (client_type_name)  =||=  Type description (client_type_description)  =||=  Address ID (address_id)  =||=  Street  =||= City =||= Postcode =||
+||= client_id  =||=  client_name  =||=  client_email  =||=  client_phone  =||=  client_type_id  =||= client_type_name  =||= client_type_description  =||=  address_id  =||=  street  =||= city =||= postcode =||
 ||= 1  =||=  John Doe  =||=  john@example.com  =||=  123-456-789  =||=  1  =||= Individual =||=  Personal client  =||=  101  =||=  Main St 123  =||= Skopje =||= 1000 =||
 ||= 2  =||=  Jane Smith  =||=  jane@example.com  =||=  987-654-321  =||=  2 =||=  Corporate =||=  Business client  =||=  102  =||=  Oak Ave 456  =||= Bitola =||= 2000  =||
@@ -42 +42 @@
 R = { policy_id, policy_number, policy_date, policy_type_id, policy_type_name, policy_type_description, client_id, coverage_id, coverage_type, coverage_description }
 
+||= policy_id  =||=  policy_number  =||=  policy_date  =||=  policy_type_id  =||=  policy_type_name =||= policy_type_description  =||=  client_id  =||=  coverage_id  =||=  coverage_type  =||= coverage_description =||
+||= 1  =||=  POL123  =||=  11.10.2023  =||=  1  =||=  Auto =||= Vehicle Insurance  =||=  1  =||=  101  =||=  Collision  =||= Covers vehicle damage =||
+||= 2  =||=  POL456  =||=  07.11.2023  =||=  2  =||=  Property =||= Home Insurance  =||=  2  =||=  102  =||=  Fire  =||= Covers fire damage =||
+
 Функциски зависности:
 
@@ -66 +70 @@
 R = { vehicle_id, vehicle_registration, vehicle_make, vehicle_model, vehicle_year, client_id, policy_id }
 
+||= vehicle_id  =||=  vehicle_registration  =||=  vehicle_make  =||=  vehicle_model  =||=  vehicle_year =||= client_id  =||=  policy_id  =||
+||= 1  =||=  SK-1234-AB  =||=  Toyota  =||=  Corolla  =||=  2020 =||= 1  =||=  1  =||
+||= 2  =||=  BT-2154-BA  =||=  Ford  =||=  Focus  =||=  2018 =||= 2  =||=  2  =||
+
 Функциски зависности:
 
@@ -85 +93 @@
 
 R = { property_id, property_type, property_value, property_address_id, client_id, policy_id }
+
+||= property_id  =||=  property_type  =||=  property_value  =||=  property_address_id  =||=  client_id =||= policy_id  =||
+||= 1  =||=  House  =||=  150000  =||=  201  =||=  1 =||= 1  =||
+||= 2  =||=  Apartment  =||=  80000  =||=  202  =||=  2 =||= 2  =||
 
 Функциски зависности:
@@ -106 +118 @@
 R = { travel_insurance_id, travel_date, travel_destination_id, destination_name, destination_country, client_id, policy_id }
 
+||= travel_insurance_id  =||=  travel_date  =||=  travel_destination_id  =||=  destination_name  =||=  destination_country =||= client_id  =||=  policy_id  =||
+||= 1  =||=  01.03.2025  =||=  301  =||=  Paris  =||=  France =||= 1  =||=  1  =||
+||= 2  =||=  20.02.2025  =||=  302  =||=  Berlin  =||=  Germany =||= 2  =||=  2  =||
+
 Функциски зависности: