Wedding Planner Management System

The Wedding Planner Management System is a database-centered project designed to support the organization, booking, and coordination of all services involved in planning a wedding event. The system manages structured data related to venues, hotels, churches, registrars, music bands, photographers, and guest lists. It also includes booking modules for church ceremonies, registrar appointments, venue reservations, and additional service providers.

The database stores availability time slots, user profiles, reservations, pricing information, and event details, enabling efficient planning while preventing conflicts such as double-booking of resources. If fully developed as a complete application, the system would provide a unified platform where users can plan an entire wedding from a single place by selecting venues, booking ceremonies, managing guests, and organizing event timelines.

This project focuses on demonstrating proper database modeling techniques, including ER diagrams, constraints, normalization, relational design, and the implementation of real-world business rules relevant to wedding planning systems.

Project team:

• Marija Taseska 213087 – Coordinator
• Slobodanka Pistolova 211171
• Jana Trpkovska 193284
• Ivan Ivanovski 212093

Course: Databases (Winter Semester 2025/2026) Started: December 2025

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

Detailed description of the project

The database and the future application are intended to support wedding planning scenarios involving multiple users, weddings, vendors, and services operating simultaneously. Each user planning a wedding requires a centralized and reliable system to store information, schedule events, and avoid conflicts caused by overlapping bookings made by different users.

The system addresses several key challenges commonly encountered in wedding planning:

• Lack of centralized data shared between different wedding service providers
• Risk of double-booking venues, churches, registrars, bands, or photographers
• Inefficient manual communication between users (bride and groom) and service providers
• Inconsistent guest management and event attendance tracking

Types of users include:

• Wedding planners or end users (bride and groom)
• Service providers (venues, bands, photographers, churches, registrars)

Difference from similar systems: While many existing wedding planner tools focus primarily on budgeting or visual design, this solution emphasizes a robust relational database structure with enforced booking constraints, real-time availability checks, and integrated ceremony scheduling. The final application is envisioned as a web-based system, with the possibility of future mobile extension.

Project Phases

Phase	Phase name	Status
P0	Project definition	Completed
P1	Conceptual design – ER Diagram & data requirements	Submitted for review
P2	Logical and physical design – Database creation (DDL)	Submitted for review
P3	Application design – Use cases and SQL scenarios	Submitted for review
P4	Application prototype – Backend and database	Backend and database prototype completed.
P5	Advanced database queries and reports	Not started
P6	Normalization and design improvements	Not started
P7	Advanced application development	Not started
P8	P8	Not started
P9	P9	Not started