Phase P4 – First Application Prototype Description This phase presents a working prototype application that demonstrates how selected application scenarios from Phase P3 can be implemented using a real database and backend logic. Technology - Programming language: Python - Framework: Flask - Database: SQLite - Execution environment: Local development (Windows) Implemented Scenarios The prototype implements a representative subset of the application scenarios defined in Phase P3: 1. Listing weddings for a user 2. Viewing events for a selected wedding 3. Viewing guests for a wedding 4. Attendance overview for an event 5. RSVP overview for an event 6. Venue availability check with conflict detection Venue Availability Logic The application implements business logic to detect overlapping venue bookings for a selected date and time interval. If a conflict exists, the system returns: - available: false - list of conflicting bookings If no conflict exists, the system returns: - available: true Screenshots Below are screenshots demonstrating: - Wedding listing - Attendance overview - RSVP overview - Venue availability with conflict - Venue availability without conflict This prototype demonstrates the feasibility of implementing the database usage scenarios and validates the database design.