Changes between Version 4 and Version 5 of Normalization

Timestamp:

08/10/25 21:16:46 (8 hours ago)

Author:

211228

Comment:

--

Normalization

@@ -5 +5 @@
 == Определување на функциски зависности == 
 
-u_id -> phone_number, first_name, last_name, email, pass, faculty_name, year_of_studies, is_exempt, gender[[br]] 
-email → u_id, phone_number, first_name, last_name, pass[[br]] 
-p_id → amount, payment_date, payment_month, student_id[[br]] 
-student_id -> phone_number, first_name, last_name, email, pass, faculty_name, year_of_studies, is_exempt, gender[[br]] 
-d_id → d_comment, d_name, d_status, upload_date, file_path, emp_id, student_id[[br]] 
-block_id → num_available_rooms[[br]] 
-
-== Лево == 
+u_id -> phone_number, first_name, last_name, email, pass, student_id, faculty_name, year_of_studies, is_exempt, gender[[br]] 
+email -> u_id, phone_number, first_name, last_name, pass[[br]] 
+student_id -> u_id, phone_number, first_name, last_name, email, pass, faculty_name, year_of_studies, is_exempt, gender[[br]]
+emp_id -> phone_number, first_name, last_name, email, pass [[br]]
+p_id -> amount, payment_date, payment_month, student_id[[br]] 
+d_id -> d_comment, d_name, d_status, upload_date, file_path, emp_id, student_id[[br]] 
+block_id -> num_available_rooms[[br]] 
+room_number, block_id -> is_available, capacity [[br]]
+room_number, block_id, student_id -> status, roommate_email, employee_id, requested_time [[br]]
+student_id, room_num, block_id -> start_date, end_date [[br]]