A

Micro-Project Report
ON
“WEDDING MANAGEMENT DATABASE
SYSTEM”
Partial Fulfillment of the Requirement for the Diploma in Computer Engineering,

By
1)Shelar Omkar Ashok [1714660110]
2)Thorat Akash Dadabhau [2014660118]
3)Swant Pravin Hemarj [2014660120]
4)Gore Aarati Manik [2114660141]
Guided By
Prof. More Meghna

Shree Samarth Academy’s

Shree Samarth Polytechnic
Mhasane Phata, Ahmednagar
Maharashtra State Board of Technical Education
(2020-2021)
1
 Shree Samarth Academy’s
Shree Samarth Polytechnic
Department of Computer Engineering.

CERTIFICATE
This is to certify that the project work entitled
“WEDDING MANAGEMENT DATABASE
SYSTEM’’

Is
Submitted by
1)Shelar Omkar Ashok [1714660110]
2)Thorat Akash Dadabhau [2014660118]
3)Swant Pravin Hemarj [2014660120]
4)Gore Aarati Manik [2114660141]
in the partial fulfillment of Diploma in Computer Engineering has been
Satisfactory carried out under my guidance as per the requirement of Maharashtra
State Board of Technical Education, Mumbai during the academic year 2020-2021
Date:
Place:

GUIDE HOD PRINCIPAL

(Prof. More M ) (Prof. Chaure S. M) (Prof. Anarse B.V.)

2
 Micro-Project Proposal

“WEDDING MANAGEMENT DATABASE

SYSTEM”

1.0 Brief Introduction:

The main aim of a DBMS is to supply a way to store up and retrieve
databaseinformation that is both convenient and efficient. By data, we mean known
can be recorded and that have embedded meaning. Normally people use software s
uch asDBASE IV or V, Microsoft ACCESS, or EXCEL to store data in the form
of database.Database systems are meant to handle large collection of information.
Managementof data involves both defining structures for storage of information
and providingmechanisms that can do the manipulation of those stored
information. Moreover, thedatabase system must ensure the safety of the
information stored, despite system crashes orattempts at unauthorized access.This
project is aim at computerizing the manual process of wedding system. Frontend
and backend are implemented using HTML and MySQL respectively. Along with
theJSP program to analyse the program. The project consists of seven forms(entity)
namelyPlanner who will plan for the wedding. The form Planner will have number
of staffs. Aswell as each staff will maintains the guests and staffs are belongs
to particular department.The weddings are held at Venue.

3
 3.0 Action plan:

Planned Planned Name of Responsible

Sr.no. Details of activity
start date Finish date Team Member
SEARCHING
1. INFORMATION PRAVINSAWANT
ABOUT TOPIC
FINDING
2. GORE ARATI
INFORMATION
DISCUS WITH
3. OMLAR SHELAR
SUBJECT TEACHER
4. MAKING PROPOSAL AKASH THORAT
5. MAKING REPORT AKASH THORAT
SUBMIT TO SUBJECT ALL GROUP
6.0
TEACHER. MEMBERS

4.0 Actual Resources Used:

S.NO Name of Resource/material Specifications Qty Remarks

1 MS OFFICE 2013 Application 1 -

2 Google Search engine 1 -

4
 Format for Micro-Project Report

“WEDDING MANAGEMENT DATABASE

SYSTEM”
Brief Description:

The services of a wedding planner can include:

Interviewing the couple and the parents to identify their needs.
Budget preparation
Event design and styling
Planning detailed checklist
Attendee list preparation
Identification of event venues (hotels, wedding manor etc.)
Identifying and hiring of wedding professionals and service providers
caterers, photographers, videographers, beautician, florists, bakers etc.
Procurement of customized decorations such as a journey map Coordination ofdeliveries/servic
es on the wedding day.
Management System:
DBMS stands for Database Management System. We can break it like this DBMS=Database
+Management System. Database is a collection of data and Management Systemis a set of
programs to store and retrieve those data. Based on this we can define DBMSlike this: DBMS
is a collection of inter-related data and set of programs to store and accessthose data in an easy
and effective manner.Database system are basically developed for large amount of data.
Whendealing with huge amount of data, there are two things that require optimization:
Storageof data and retrieval of data. According to the principles of database systems, the data
isstored in such a way that it acquires a lot less space as the redundant data(duplicate data)has
been removed before storage.Along with storing the data in an optimized and systematic
manner, It is alsoimportant that we retrieve the data quickly when needed. Database system
ensures that datais retrieved as quickly as possible.

Applications of DBMS

5
 The development of computer graphics has been driven both by the needs ofthe user
community and by the advances in hardware and software. The applicationsof database are
many and varied; it can be divided into four major areas: 

 Hierarchical and network system. 
 Flexibility with relational database.
 Object oriented application.
 Interchanging the data on the web for e-commerce.

Design
Professions such as engineering and architecture are concerned with design.Starting with a set
of specification engineers and architects seek a cost effective and  esthetic solutions that
satisfies the specifications. Design is an iterative processrarely in the real world is a problem
specified such that there is a unique optimalsolution. Thus the designer works iteratively.

User Interfaces
Our interactions with computers has become dominated by a visual paradigm that
includes windows, icons, menus, pointing device, such as a mouse.Although we are familiar
with the syntax of MySQL, advances in MySQL havemade possible other forms of advantages.

Triggers:
A database trigger is procedural code that is automatically executed inresponse to certain
events on a particular table or view in a database. The trigger is mostlyused for maintaining the
integrity of the information on the database. For example, when anew record (representing a
new worker) is added to the employees table, new recordsshould also be created in the tables
of the taxes, vacations and salaries. Triggers can also be used to log historical data.

Stored procedure:
A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc,sp, or SP) is a
subroutine available to applications that access a relational databasemanagement system
(RDBMS). Such procedures are stored in the database data dictionary.Uses for stored
procedures include data-validation (integrated into the database) oraccess-control
mechanisms. Furthermore, stored procedures can consolidate and centralizelogic that was
originally implemented in applications. To save time and memory, extensiveor complex
processing that requires execution of several SQL statements can be saved intostored
procedures, and all applications call the procedures. One can use nested stored procedures
by executing one stored procedure from within another.

6
ANALYSIS & REQUIREMENT SPECIFICATION
Purpose
The purpose of this project is to outline Wedding data and requirements,
torecommend data management solutions and to provide a information
regarding thewedding. The purpose of this project is to develop a data
management system toconsolidate, organize, document, store and distribute
information related to weddingmanagement system.A centralized database
created to consolidate data,allowing integrated,long termanalyses, and dynamic
search abiliy with user friendly query tools to be performed tosupport adaptive
management. Many data
collection,analysisandpresentation software programs that are currently being us
ed must be able to interface with any new datamanagement system.
Scope
The scope of the project is managing a consistency and storage of data by dedicateddata
administrator. It provides most of the features that a Database Management Systemshould
have. It is developed by using MySQL database. It has been implemented inWINDOWS
platform.

7
 DESIGN OF THE PROJECT
 
This project has been developed using MySQL software which is queries oriented. Changesat
the queries and the way in which it uses a system state may cause anticipated changes inthe
behaviour of other result.
ER-Diagram

Schema Diagram:
8
SNAPSHOTS
9
Home page

Login page

10
 Options for Admin

  Registration By User

11
Insertion into planner table

After successful insertion

12
  Analysis

Query results
CONCLUSION

13
In this project we have created one application which is easy to access and user
friendly.The application keeps a backup of the wedding management data which
includes theirdetails. A wedding planner is a professional who assists with the
design, planning andmanagement of a client's wedding.

FUTURE ENHANCEMENT

14
In this, application keeps a backup of the wedding management data which
includes theirdetails.Here we assists with the design, planning and management of
a client's wedding. Further we will modify the application by adding external
features like Vehicle services,we will change the entire venues and also we will
make planning and management of client’s wedding wherever they require
worldwide.

Teacher Evaluation Sheet

Name of Student………………………………………………………………………………………
Enrollment No………………………………………………...….………...….………...….………...

15
Name of Program…………………………………………………….….....….………...….………...
Semester……………………………………………………………….…....….………...….………..
Course Title…………………………………………………………….…...….………...….………..
Code………………………………………………………………………...….………...….………...
Title of the Micro-Project……………………………………………………………………………...
Course Outcomes Achieved
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………
………………………………………………………………………………………………………………

Evaluation as per suggested Rubric for Assessment of Micro-Project

Sr. Characteristic to be Poor Average Good Excellent
No. assessed (Marks 1-3) (Marks 4- (Marks 6- (Marks 9-10)
5) 8)
1 Relevance to the course
2 Literature survey/
Information Collection
3 Project Proposal
4 Completion of the
Target as per project
proposal
5 Analysis of Data &
Representation
6 Quality of
Prototype/Model
7 Report Preparation
8 Presentation

Micro-Project Evaluation Sheet

Process Assessment Product Assessment Total
Part A- Project Part B-Project Individual Marks
Project Methodology Report/Working Model Presentation/Viva 10
Proposal (2 mark) (2 marks) (4 mark)
(2 marks)

Note:

16
Every course teacher is expected to assign marks for group evolution in first 3 columns & individual
evaluation in 4th columns for each group of students as per rubrics

Comments/Suggestions about team work/leadership/inter-personal communication (if any).

.................................................................................................................................................
.................................................................................................................................................
.........................................................................

Any other comment:

......................................................................................................................................
.................................................................................................................................................
.................................................................................................................................................
.........................................................................

Name and designation of the faculty member........................................................

Signature...................................................................

*****************

17