| 12 | | user_id → (first_name, last_name, phone, email, password), |
| 13 | | p_id → p_method, amount, p_date, |
| 14 | | reservation_id → start_date, end_date, reserv_date, status, |
| 15 | | building_id → address, city, floors, num_rooms, |
| 16 | | (building_id, room_number) → room_type, number_of_beds, price_per_night, available, |
| 17 | | service_id → service_type, service_date, service_status, |
| | 12 | 1. user_id → first_name, last_name, phone, email, password \\ |
| | 13 | 2. service_id → service_type, service_date, service_status, user_id, room_number, building_id \\ |
| | 14 | 3. reservation_id → start_date, status, end_date, reserv_date, user_id, p_id, room_number, building_id \\ |
| | 15 | 4. p_id → p_method, p_date, amount, user_id, reservation_id \\ |
| | 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 | } |
