Нормализација

Функциски зависности

R(user_id, first_name, last_name, phone, email, password, p_id, p_method, amount, p_date, reservation_id, start_date, end_date, reserv_date, status, building_id, address, city, floors, num_rooms, room_number, room_type, number_of_beds, price_per_night, available, service_id, service_type, service_date, service_status)

---

Множество функциски зависности:

F_D = {

1. user_id → first_name, last_name, phone, email, password
   
2. service_id → service_type, service_date, service_status, user_id, room_number, building_id
   
3. reservation_id → start_date, status, end_date, reserv_date, user_id, p_id, room_number, building_id
   
4. p_id → p_method, p_date, amount, user_id, reservation_id
   
5. (room_number, building_id) → room_type, number_of_beds, price_per_night, available
   
6. building_id → address, city, floors, num_rooms
   

}

---