Wedding Planner Management System

The Wedding Planner Management System is a database designed to support the organization, booking, and coordination of all services involved in planning a wedding event. The system manages structured data about venues, hotels, churches, registrars, music bands, wedding packages, service providers, and guest lists. It also includes booking modules for church ceremonies, registrar appointments, venue reservations, and vendor scheduling. The database stores availability slots, customer profiles, reservations, pricing information, and event details, allowing efficient planning without conflicts such as double-booking. If fully developed as a complete project, it would become a platform enabling users to plan entire weddings from a single place: selecting venues, booking ceremonies, adding guests, hiring services, and managing timelines. The system would support both clients and administrators, offering real-time availability, automated verification of bookings, and centralized data management. This project aims to demonstrate correct database modeling, ER diagrams, constraints, normalization, and relational design suitable for real-world wedding planning applications.

Project team:

Marija Taseska 213087

Slobodanka Pistolova 211171

Jana Trpkovska 193284

Ivan Ivanovski 212093

Course: Databases in 2025/2026/Winter

Under the supervision of: Prof. Dr. Vangel V. Ajanovski

Detailed description of the project

The database and the future project are intended for a wedding planning that manages multiple users, weddings, vendors, and services simultaneously. Every user before their wedding, needs a centralized and reliable system to store information, schedule events, and avoid conflicts between bookings from other users.

The project solves several key problems:

-lack of centralized data between different wedding service providers

-risk of double-booking venues, churches, registrars, or bands

-inefficient manual communication between users(In this case Groom and Bride) and Venue, Band, Church and Register bookings.

-inconsistent guest management and event tracking

Types of users include:

-wedding planners in this case Users(Groom or Bride, can be both)

-service providers (bands, hotels, registrars)

Difference from similar systems: While existing wedding planner tools focus mostly on budgeting or design, this solution focuses on a full relational database with real booking constraints, availability management, and integration of ceremony scheduling.

The final application would be primarily web-based, with the potential to extend to mobile.