Changes between Version 20 and Version 21 of normalizacija

Timestamp:

05/06/25 11:39:45 (11 days ago)

Author:

213209

Comment:

--

normalizacija

@@ -97 +97 @@
 ||3     ||2025-05-03    ||17:00 ||18:30 ||3     ||103   ||Elena ||13    ||3     ||203   ||Bella Italia  ||Skopje, Aerodrom||
 
-R = {
-  reservation_id, reservation_date, time_from, time_to, number_of_people,
+'''R''' = {  reservation_id, reservation_date, time_from, time_to, number_of_people,
+
   user_id, user_name,
+
   table_id, table_number,
+
   restaurant_id, restaurant_name, restaurant_location
 }
+
+'''Функциски зависности:'''
+
+reservation_id → reservation_date, time_from, time_to, number_of_people, user_id, table_id
+
+user_id → user_name
+
+table_id → table_number, restaurant_id
+
+restaurant_id → restaurant_name, restaurant_location
+
+лево:
+
+reservation_id, user_id, table_id, restaurant_id
+
+Само десно (зависни атрибути):
+
+user_name, restaurant_name, restaurant_location, reservation_date, time_from, time_to, number_of_people, table_number