Changes between Version 3 and Version 4 of Normalization

Timestamp:

08/10/25 15:14:17 (4 days ago)

Author:

211228

Comment:

--

Normalization

@@ -1 +1 @@
 = Нормализација и подобрувања на дизајнот на базата =
+
+R = { u_id, phone_number, first_name, last_name, email, pass, faculty_name, year_of_studies, is_exempt, gender, p_id, amount, payment_date, student_id, payment_month, d_id, d_comment, d_name, d_status, [[br]] upload_date, file_path, emp_id, block_id, num_available_rooms, room_number, is_available, capacity, status, roommate_email, requested_time, start_date, end_date}
 
 == Определување на функциски зависности == 
 
-1. Функциски зависности кај Dorm_user: 
+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 [[br]]
-email -> u_id, phone_number, first_name, last_name, pass
-
+== Лево ==