A

Synopsis
On
“WEDDING MANAGEMENT DATABASE SYSTEM”
Submitted to M.R.I.T. College of Engineering, Mandya in partial fulfillment
of the requirement for the degree of Bachelor of Engineering.

Submitted by
Nida Syeda (4MU21CS049)
Hitha L. Gowda (4MU21CS049)

Under the Guidance of

Chandrakala L.

DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

M.R.I.T. COLLEGE OF ENGINEERING, MANDYA
Session 2022-2025
 Table Of Contents

Sl. No. Title Pg. No.

1. Introduction
1.1 About Project
1.2 Main Features
1.3 Objectives
2. Software Requirements
2.1 Input Requirements
2.2 Output Requirements
2.3 Hardware Requirements
3. System Design
3.1 Table Design
3.2 Schema Diagram
3.3 Er Diagram
4. Result And Snapshots
5. Conclusion And References
 1. Introduction
1.1 About Project

The celebration of love, unity, and lifelong commitment is a momentous occasion

that demands meticulous planning and seamless execution. In the realm of event
management, few events rival the complexity and significance of a wedding.
Recognizing the need for a comprehensive solution to streamline the myriad tasks
involved in orchestrating this joyous affair, our team embarked on a journey to
develop a cutting-edge Wedding Management Database Management System
(DBMS) project.

Weddings, being multifaceted events, involve a myriad of tasks ranging from guest
list management and venue selection to catering arrangements and financial
tracking. Navigating through these intricate details can be overwhelming, often
leading to stress and oversight. Traditional methods of manual planning and
coordination are prone to errors, delays, and miscommunication. Hence, the idea of
a Wedding Management DBMS project emerged as a solution to revolutionize the
way weddings are organized.

The Wedding Management System is a mini-project for database management

using MySQL. The system is designed to facilitate the arrangement and
organization of weddings. It provides a centralized platform to manage various
aspects of wedding planning, including cost management, venue selection, music
selection, vendor coordination and task scheduling etc.

1.2 Main Features

Our Wedding Management DBMS project incorporates a plethora of features
designed to cater to the diverse needs of wedding planning. From creating and
managing guest lists to coordinating vendor contracts, the system ensures that no
detail is overlooked. Key features include:

The Wedding Management Database Management System (DBMS) project

incorporates a range of key features designed to revolutionize and simplify the
intricate process of wedding planning. These features include:

1. Guest Management:
Efficient creation and management of guest lists, including tools for tracking
RSVPs, managing meal preferences, and generating seating charts. This feature
ensures a personalized and seamless experience for both hosts and guests.

2. Vendor Coordination:

A comprehensive system for storing, organizing, and communicating with vendors.

This includes managing vendor details, contracts, and contact information,
fostering effective collaboration and reducing misunderstandings between wedding
parties and service providers.

3. Budget Tracking:

The implementation of a robust budget management module, allowing users to

create, track, and manage budgets for various wedding expenses. Real-time
expenditure comparisons against allocated budgets provide financial transparency
and aid in strategic financial planning.

4. Event Timeline:

Development of a detailed and dynamic timeline covering pre-wedding, wedding

day, and post-wedding events. This feature integrates automated reminders and
notifications to guide users through the timely execution of tasks and milestones,
minimizing oversights and ensuring a well-coordinated celebration.

5. Resource Management:

Tools for efficient allocation and utilization of resources, including venues,

decorations, and equipment. This feature enables users to manage inventory, track
resource availability in real-time, and optimize resource utilization to minimize
costs.

6. Financial Reporting:
Generation of comprehensive financial reports to provide users with insights into
their expenditures. These reports empower users to make informed financial
decisions, contributing to strategic financial planning throughout the wedding
planning process.

7. User-Friendly Interface:

Design of an intuitive and user-friendly interface catering to the diverse needs of

wedding planners, couples, and vendors. This interface fosters collaboration and
communication within the wedding planning ecosystem, enhancing the overall user
experience.

These key features collectively aim to elevate the efficiency, accuracy, and
satisfaction associated with wedding planning. By addressing various aspects of
the planning process, the Wedding Management DBMS project strives to create a
seamless and memorable experience for all involved parties.

1.3 Objectives
The Wedding Management Database Management System (DBMS) project is
conceived with the overarching goal of revolutionizing the intricate process of
wedding planning. Our primary objective is to offer a centralized and user-friendly
platform that harmonizes various facets of wedding organization, empowering both
wedding planners and couples to focus on the joyous essence of the celebration.
Recognizing the challenges inherent in coordinating diverse tasks, we aim to
streamline the entire process, minimizing stress and errors associated with
traditional manual planning.

At the heart of our project lies the ambition to facilitate efficient guest
management. Through the implementation of advanced features, we seek to assist
in the creation and management of guest lists, RSVP tracking, meal preferences,
and seamless generation of seating charts. By automating these aspects, our system
ensures a personalized and hassle-free experience for both hosts and guests,
fostering a positive atmosphere for the entire celebration.

Vendor coordination stands as another crucial aspect of our project. We aspire to

create a comprehensive system that enables the seamless storage, organization, and
communication with vendors. This includes the management of contracts, contact
details, and timely updates, ensuring a harmonious collaboration between wedding
parties and service providers. This feature aims to enhance communication, reduce
misunderstandings, and optimize the overall efficiency of the wedding planning
process.

Our commitment extends to resource allocation and management, providing tools

to optimize the utilization of venues, decorations, and equipment. Through
inventory management and real-time tracking of resource availability, our system
minimizes costs while maximizing the efficiency of resource utilization.

In essence, the Wedding Management DBMS project seeks to redefine the

landscape of wedding planning by leveraging technology to enhance efficiency,
accuracy, and client satisfaction. By providing a comprehensive and intuitive
platform, we aim to contribute to the creation of memorable and joyous wedding
celebrations.
 2. Software Requirements
2.1 Input Requirements
Technology used :

A. phpmyadmin used for mysql database

B. php used for backend
C. html5 | css | javascript | bootstrap4 for frontend
D. Xampp server

E. The input data that is provided to this project are detailed about the wedding

management .The wedding management needs to create the admission

system to organize the wedding records and other information.

2.2 Output requirements

The wedding management database project necessitates a well-structured output
system to efficiently organize and coordinate various elements of the event. It is
imperative to generate reports that cater to the diverse needs of stakeholders
involved in the wedding planning process.

Comprehensive guest list management is a crucial output requirement, facilitating

the creation of detailed lists that include RSVP status, dietary preferences, and
seating arrangements. This ensures a systematic approach to guest management
during the event, enhancing the overall experience.

Financial transparency is paramount, and the system should produce budget

tracking reports outlining budget allocations, expenses incurred, and remaining
funds. This assists in closely monitoring and controlling costs throughout the
wedding planning journey.

A dynamic task and timeline reporting system is vital to track the progress of
various activities leading up to the wedding day. This assists in identifying
bottlenecks and ensures the timely completion of all tasks.

Efficient venue and resource utilization reports contribute to optimal use of

facilities and equipment. These reports help in managing logistics effectively and
ensuring that resources are allocated judiciously.

Post-event analysis reports are instrumental in gathering feedback from clients,

guests, and vendors. This valuable input identifies areas of improvement and
success, contributing to continuous enhancement in wedding planning services.

2.3 Hardware Requirements

1. Processor:

- A mid-range processor (e.g., Intel Core i5 or equivalent AMD processor) is

generally sufficient for handling the workload of a local wedding management
database.
2. Memory (RAM):
 - 8GB or higher RAM is recommended to ensure smooth performance, especially
when dealing with multiple concurrent database operations.
3. Storage:
- Adequate local storage (e.g., 256GB SSD or higher) for storing the database
files and related software. SSDs are preferable for faster data access.
4. Monitor:
- A standard monitor with a resolution suitable for comfortable viewing and
interaction with the database application.
5. Input Devices:
- A standard keyboard and mouse for user input. The complexity of these devices
can be based on user preference.

6. Operating System:

- The system should be running a compatible operating system (e.g., Windows,

Linux, or macOS) based on the requirements of the database software.

7. Backup Solution:

- While not directly hardware, a local backup solution, such as an external hard
drive, is essential to safeguard data in case of accidental deletions or system
failures.

8. Network Connectivity:

- Since this is a local project, a stable network connection is not as critical as it

would be in a distributed environment.
 3. System Design
The wedding management DBMS is designed with a modular structure, featuring
tables for Guests, Events, Vendors, Expenses, and Admins. Relationships between
tables facilitate seamless data retrieval. The system incorporates a secure Admin
login, ensuring data integrity. Its schema supports efficient tracking of guests,
events, vendor details, and expenses for comprehensive wedding planning.

3.1 Table Design

1. Admin Log-in table:

Field Name Datatype

Admin Id Varchar()
Password Varchar()

2. Venue table:

Field Name Datatype

Venue Name Char()
Amount Varchar()
Description Varchar()

3. Theme table:

Field Name Datatype

Theme Name Char()
Amount Varchar()
Description Varchar()
4. Music table:

Field Name Datatype

Music Type Char()
Amount Varchar()
Description Varchar()

5. Catering table:

Field Name Datatype

Caterer’s Name Char()
Amount Varchar()
Description Varchar()

6. Photoshop table:

Field Name Datatype

Photoshop Name Char()
Amount Varchar()
Description Varchar()

7. Final details table:

Field Name Datatype

Reg id Varchar()
Service Varchar()
Date Integer

8. Personal details table:

 Field Name Datatype
Name Varchar()
Username Varchar()
Email-id Varchar()
Contact No. Integer
Reg. Name Varchar()
Password Varchar()

3.2 Schema Diagram

3.2.1 System Analysis and Design for Wedding Management DBMS:

1. Admins Table

- Purpose: Manages administrator login credentials.

- Attributes: AdminID (Primary Key), Username (Unique), Password Hash.

2. Venues Table:

- Purpose: Records details about wedding venues.

- Attributes: Venue Name, Amount, Description.

3. Themes Table:

- Purpose: Stores information about wedding themes.

- Attributes: Theme Name, Amount, Description.

4. Music Table:

- Purpose: Manages details of wedding music services.

- Attributes: Music type, Amount, Description.

5. Catering Table:

- Purpose: Tracks information about catering services.

- Attributes: Caterer Name, Amount, Description.

6. Photoshop Table:

- Purpose: Records details about wedding photography services.

- Attributes: Photoshop Name, Amount, Description.

7. Personal Table:

- Purpose: Manages personal details related to the wedding.

- Attributes: Name, Username, Email-id(Unique), Register Id(Primary Key),

Admin Id(Primary Key), Password.

Relationships:

- Venues - Events: Venues are associated with specific events (ceremonies,

receptions).

-Themes - Events: Themes are linked to particular events for consistent decor.

- Music - Events: Music services are associated with specific events.

- Catering - Events: Catering services are linked to particular events.

- Photoshop - Events: Photography services are associated with specific events.

- Personal - (Any Relevant Table): Personal details are linked to other wedding
aspects.
This adjusted design reflects the specific categories mentioned (admin, venue,
theme, music, catering, photoshop, personal) and maintains relationships to ensure
comprehensive wedding planning data management.

Admin_details Venue_Details

Admin_ID(PK) Venue_Name

Password Amount
Description

Theme_table
Music_table
Theme_Name
Music_Theme
Amount
Amount
Description
Description
Photoshoot_details
Photoshoot_Name
Catering_table
Amount
Caterer’s_Name
Amount Descrition
Description

Personal_Details
Name
Final’s_details Username
Reg_id(PK) Email_id
Service Contact_No.
Date
Reg_name
Password(PK)
3.3 ER Diagram
 4. Result And Snapshots
1. Home page:

2. Service page:

3. Portfolio page:
4. Creator’s information:

5. After login page:

6. Personal details form filling page:

7. Brief detailing page about venue, theme, music, catering, photoshoot:

8. Final details page:
 5. Conclusion And References
In summary, the wedding management database system presents a comprehensive
solution for seamless event coordination. The interconnected tables, encompassing
guest details, event specifics, vendor information, and expenses, form a robust
foundation. This system streamlines the wedding planning process, offering
administrators a centralized platform to manage every facet of the event. From
guest lists and venue details to themes, music, catering, and photography services,
the database ensures efficient organization and retrieval of crucial information. The
design fosters collaboration, enhances decision-making, and contributes to the
overall success of wedding events, underscoring the importance of a well-
structured database in modern event management.

Books:
1. "Database Systems: The Complete Book" by Hector Garcia-Molina, Jeffrey D.
Ullman, Jennifer Widom.

2. "SQL Performance Explained" by Markus Winand.

3. "Learning SQL" by Alan Beaulieu.

4. "Database Design for Mere Mortals" by Michael J. Hernandez.

Websites:

1. [W3Schools]([Link] Comprehensive tutorials on

SQL, a crucial language for database management.

2. [MySQL Documentation]([Link] Official documentation

for MySQL, providing in-depth information on the MySQL database system.
3. [phpMyAdmin]([Link] A popular tool for managing
MySQL databases via a web interface.

4. [Google]([Link] A versatile search engine where you can

find a wealth of information on database design principles and best practices.