Version 1 (modified by 11 days ago) ( diff ) | ,
---|
Нормализација
Функциски зависности
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)
Множество функциски зависности:
FD = { 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, (building_id, room_number) → room_type, number_of_beds, price_per_night, available, service_id → service_type, service_date, service_status,
}