199960316008 [wedding management]
199960316019
199960316045
199960316015
Tittle : WEDDING MANAGEMENT
Submitted by
▪ Chhatbar Nisarg Rakesh Bhai (199960316008)
▪ Kansagra Harsh Ashok Bhai (199960316019)
▪ Patel Stuti Dipak Bhai (199960316045)
▪ Gadhiya Fenil Mahesh Bhai (199960313015)
Department of Diploma IT Engineering
Internal guide :- Hina mem
KHYATI SCHOOL OF ENGINEERING
SHAHIBAG ,AHEMDABAD.
❖ Definition
✓ now wedding and destination wedding location is
in trend . today people have craze about wedding
or destination wedding .
✓ so, in this website we allow user to access some
beautiful information and places regarding to their
needs .
❖ ABSTRACT
✓Our project is on wedding management .in which
all the facilities are available. you can also buy
order and windows shopping at home .
✓ In this website are also available in most popular
Indian weeding location and also popular and
more popular designer and photographer are
available in this website.
✓ You can also find the photos and videos of the
decoration of the wedding venue so that you an
select a good place . and also see the photos and
videos of the destination wedding and also be
prewedding location .
✓ You can also find the name and address and
photos of the showrooms and boutique for the
good wedding designer dresses .
❖ Software/ Hardware
Requirement
• Technology
HTML
CSS
PHP
MY SQL
jQuery
JavaScript
• Tools
• Notepad++
• Draw.io
• Software requirement
Software Recommended Software
Requirement
Technology PHP,CSS
,HTML,Jquery,javascript
Database MY SQL
Tools Notepad++,draw.io
OS Windows XP or Higher
,Linux, Mac
• Hardware requirement
Hardware Recommended Software
Requirement
Processor Minimum 2.0 GHz
Memory RAM 2GB OR Higher
GB Hard Disk /SSD 150GB
❖ Problems in exiting model
✓It is limited to a single system.
✓The present system is very less secure.
✓It unable to generate different kinds of reports.
✓It is difficult to maintain phone bookings and
cancellations.
✓Does not provide global support . User cannot do
the reservation from remote place.
✓Retrieval of information is difficult and time
consuming .
✓A lot of time and manual effort is required
❖ Need of the system
• The existing system is manual/ machine
System the user must have to perform their
manually .
• It will take more time and this whole
procedure is very tedious and takes a lot of
times .
• That’s why we are going to develop wedding
management for users easiness .
➢Design
• 0 level DFD
▪ 1ST Level DFD
• Admin
• 1ST Level customer
• 2nd Level DFD
• ER diagram
➢ UML Diagram
•USE CASE diagram
▪ Sequence Diagram
• Admin
• Customer
• Activity Diagram
▪ Admin
• Customer
• Class Diagram
❖Data Dictionary
• Admin table
Field Type Constrains Description
admin_id int primary key admin_id
username varchar(25) not null username
password varchar(25) not null password
email varchar(35) not null email
contact_no int not null contact
• Customer table
Field Type constrains Description
cust_id int Primary Key cust_id
cust_name varchar(50) not null cust_name
password varchar (50) not null password
address varchar (50) not null address
phone no. int not null phone no.
email varchar (50) not null email
image Varchar(50) not null image
city Varchar(50) Foreign key city
state Varchar(50) Foreign key State_id
• Venues Table
Field Type Constrains Description
venues_id int primary key venues_id
van_name varchar(30) not null van_name
van_price int not null van_price
Venue_img Varchar Not null Venue_img
Venue_ Varchar Not null Venue_
description (300) description
• Albums Table
Field type constrains description
alb_id int primary key alb_id
alb_name varchar(30) not null alb_name
alb_price int not null alb_price
alb_ Not null Alb_
Description varchar(300) description
alb_img int medium alb_img
blob
• Caterers Table
Field Type Constrains Description
cat_id int primary key cat_id
cat_name( int not null cat_name(
company) company)
Cat_ Varchar Not null Cat_
description (300) description
Cat_price int Not null Cat_price
No .of Int Not null No.of
Person person
cat_img medium not null cat_img
blob
• Groom ware table
Field Type Constrains Description
groom_id int primary key groom_id
groom_ varchar(25) not null groom_
name name
Groom_ int Not null Groom_
price price
groom_ Varchar Not null Groom _
description (300) description
groom_ medium not null groom_
Img blob img
• Booking Table
Filed Type Constrains Description
book_id int primary key book_id
Cust_id int Foreign key Cust_id
book_name varchar(30) not null book_name
book_price int not null book_price
Package_id int Foreign key Package_id
date varchar(25) Not null date
• package table
Filed Type Constrains Description
pack_id int primary key pack_id
venue_id int Foreign key venue_id
alb_id int Foreign key alb_id
groom_id int Foreign key groom_id
cat_id int Foreign key cat_id
Package_ int Not null Package_
price price
• City Table
field Type Constrains Description
City_id int Primary key City_id
City_name Varchar(20) Not null City_name
State_id Int Foreign key State_id
• State table
Field Type Constrains Description
State_id int Primary key State_id
State_ Varchar(20) Not null State
name _name
• Testimonial table
Filed Type Constrains Description
testi_id Int primary key testi_id
Testi_review varchar(200) not null testi_review
testi_date varchar(25) not null testi_date
Testi_name Varchar(25) Not null Testi_name
• Inquiry Table
Filed Type Constrains Description
inq_id int primary key inq_id
inq_date varchar(25) not null inq_date
inq_ varchar(400) not null inq_
Description description
❖ Future Enhancement
✓new system is a completely online web based
system so there can be less need for a physical
location .
✓in upcoming years it is more useful to user
who will prepare for the wedding planning at
home and also all facilities are available so
you can easily find out.
✓in the future ,in this use of a web site will
increase .
❖ Conclusion
• I hope this website will achieve its goal which is to
deliver the cultural facts and Indian wedding to
current and future generation
• I also hope that this website will be useful and the
information within is delivered for good
❖ Bibliography
• https://www.weddinghappy.com/
• https://www.venuereport.com/
• Weddingz.in
• www.wedmegood.com