Changes between Version 3 and Version 4 of Normalization
- Timestamp:
- 08/06/25 15:22:57 (6 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Normalization
v3 v4 9 9 Множество функциски зависности: 10 10 11 F,,D,, = {12 1. user_id → first_name, last_name, phone, email, password11 F,,D,, = 12 {1. user_id → first_name, last_name, phone, email, password 13 13 2. service_id → service_type, service_date, service_status, user_id, room_number, building_id \\ 14 14 3. reservation_id → start_date, status, end_date, reserv_date, user_id, p_id, room_number, building_id \\ 15 15 4. p_id → p_method, p_date, amount, user_id, reservation_id \\ 16 16 5. (room_number, building_id) → room_type, number_of_beds, price_per_night, available \\ 17 6. building_id → address, city, floors, num_rooms \\ 18 } 17 6. building_id → address, city, floors, num_rooms \\} 19 18 20 19 ----