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.