= Нормализација и подобрувања на дизајнот на базата =

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}

== Определување на функциски зависности == 

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]] 

== Лево ==