BASELIOS POULOSE II CATHOLICOS

COLLEGE BASELIOS MOUNT,

PIRAVOM

Re-accredited with ‘A’ Grade by NAAC

(Affiliated to Mahatma Gandhi University)

DEPARTMENT OF COMPUTER
APPLICATIONS

2023-24
Project Report

On

EverAfter

(Wedding Event Management Website)

BASELIOS POULOSE II CATHOLICOS
COLLEGE BASELIOS MOUNT,
PIRAVOM

Re-accredited with ‘A’ Grade by NAAC

(Affiliated to Mahatma Gandhi University)

PIRAVO
M 2023-24

DEPARTMENT OF COMPUTER APPLICATIONS

Project Report
On
EverAfter
Submitted in partial fulfilment of the requirements for the award
of the degree of
BACHELOR OF COMPUTER APPLICATION

Guided by: Dr. Kurian MJ Submitted by:

(Dept. of Computer application) Jeena Joby
(210021093776)
 BASELIOS POULOSE II CATHOLICOS
COLLEGE BASELIOS MOUNT,
PIRAVOM

Re-accredited with ‘A’ Grade by NAAC

(Affiliated to Mahatma Gandhi University)

PIRAVO
M 2023-24

DEPARTMENT OF COMPUTER APPLICATIONS

Certificate
This is to certify that the project entitled “EverAfter” submitted in
partial fulfillment for the award of the degree of BACHELOR OF
COMPUTER APPLICATION is a bonafide report of the project done
by Jeena Joby
(Reg no: 210021093776) during the year 2023-24.

Internal Guide: Head of the department:

Dr. Kurian MJ Dr. Anu Paul

Examiner:1 Department Seal

College Seal
 DECLARATION

I hereby declare that the this project work entitled “EverAfter” is a

record of original work done by me under the guidance of Dr. Kurian
MJ, Associate Professor, Department of Computer Applications and
the work has not formed the basis for the award of any degree or
diploma or similar title to any candidate of any university subject.

Internal Guide: Signature of

Student Dr. Kurian MJ

ACKNOWLEDGEMENT
 ACKNOWLEDGEMENT

At the outset, I thank God Almighty for making endeavor a success.

I express my gratitude to Dr. Santhosh Potharay Kuruvilla, Principal,

Baselios Poulose II Catholicos College, for providing me with adequate facilities,
ways and means by which I was able to complete the project work. I express my
sincere thanks to my internal guide Dr. Kurian MJ, Associate Professor who guide
me properly from the beginning to the end of my project and examining the draft of
this project, suggestions and modifications .With immense pleasure I take this
opportunity to record out sincere thanks to Head of Department
Dr. Anu Paul, Associate Professor, Department of Computer Applications for his
motivation throughout this project.

Last but not the least, I also express my gratitude to all other members of the
faculty and well-wishers who assisted me in various occasions during the project
work.

Jeena Joby
ABSTRACT

9
 ABSTRACT

The web application, “EverAfter,” is a comprehensive online platform designed for

efficiently managing wedding events. The primary objective of this project is to provide a
user-friendly interface for individuals seeking to organize and plan their wedding
ceremonies seamlessly. Wedding events hold immense significance, and “EverAfter” aims
to streamline the entire process, making it more accessible and convenient.

“EverAfter” caters to three distinct user roles: Admin, Vendors, and Clients. The Admin
holds authoritative control over the system, overseeing and validating data submitted by
both vendors and clients. Vendors, such as venues, caterers, florists, and photographers, can
register, manage their profiles, and showcase their services. They also have the ability to set
pricing details based on package offerings.

Clients, the end-users, can register easily by providing basic details and access a multitude
of features. They can explore various vendors, check venue availability, select event
timings, input personal preferences, and make secure online payments through the platform.
Additionally, clients have the convenience of reviewing their event booking history,
ensuring a seamless and organized wedding planning experience.

EverAfter” revolutionizes wedding event management by centralizing all essential features

on a single, accessible platform. This not only saves time for clients by providing a
comprehensive overview of available services but also simplifies the vendor management
process for businesses in the wedding industry. The platform’s user-friendly design ensures
accessibility from anywhere, at any time, enhancing the overall wedding planning
experience for both clients and vendors.

10
 TABLE OF CONTENT

1. SYSTEM STUDY…………………………………………......11
1.1 EXISTING SYSTEM………………………………….12
1.1.1 DRAWBACKS……………................................12
1.1.2 SYSTEM ANALYSIS………………………….13
1.2 PROPOSED SYSTEM……………………...................14
1.2.1 ADVANTAGE OF PROPOSED SYSTEM……14
1.3 FEASIBILITY STUDY……………………………….15
1.3.1 ECONOMIC FEASIBILITY……………………15
1.3.2 TECHNICAL FEASIBILITY………………........15
1.3.3 BEHAVIOURAL FEASIBILITY…………..........16
2. SYSTEM SPECIFICATION……………………...................17
2.1 ABOUT FRONT END……………………....................18
2.2 ABOUT BACK END…………………..........................22
2.3 ABOUT OPERATING SYSTEM………………...........23
3. SYSTEM ANALYSIS AND DESIGN……………….............25
3.1 DATA FLOW DIAGRAM…………..............................26
3.2 TABLE DESIGN……………….....................................23
3.3 INPUT DESIGN…………..............................................38
3.4 OUTPUT DESIGN…………..........................................39

11
 3.5 MENU DESIGN……………….....................................39
4. SYSTEM DESCRIPTION…....................................................41
5. SYSTEM TESTING AND IMPLEMENTATION….............43
5.1 SYSTEM TESTING…...................................................44
5.1.1 UNIT TESTING…..............................................45
5.1.2 INTEGRATION TESTING….............................46
5.1.3 VALIDATION TESTING…...............................46
5.1.4 OUTPUT TESTING…........................................46
5.2 SYSTEM IMPLEMENTATION…...............................46
6. CONCLUSION….....................................................................48
7. BIBLIOGRAPHY…................................................................50
8. APPENDIX…...........................................................................52
8.1 SCREENSHOTS……………………………………...53

12
SYSTEM STUDY

13
 1.SYSTEM STUDY

1.1 EXISTING SYSTEM

The study about the existing system helps to know as much information as possible about the system. We
can find many faults in the existing system. The existing system runs under manual actions. It includes a lot of
paper works and calculations. This may consume a lot time of the user.

The main limitation of the system is that it is time consuming process. In the existing system the
data entry is made on papers and it Become a tedious process; resulting over use of manpower. There is
no security and a great chance for loss of valuable data stored in paper files due to hazards life fire and
improper storage. Error detection is very difficult in this system. While carrying out error correction
methods, the whole process may have to be repeated. All accounting processes are done on paper with
the help of a calculator, this often leads to inaccurate results and cash mismatch. So an alternative
solution is needed.

1.1.1 Drawbacks of Existing System

1. Data storage:- In manual system paper files require a huge amount of storage space and paper
storage creates several problems like spoilage the deterioration by way of aging, humidity etc…
Paper based systems are generally very bulky both to handle to store and office space are
expensive.
2. Speed of processing:- The speed of execution of data is slow in the existing system.
Processing is slower where large volumes of data need to be dealt with. Slower processing means
that some information that could be provided if computerized systems were used will not be
provided at all, because there is no time.
3.Speed of retrieval of information:- The speed of retrieval information is very slow in this
system.
4.Time and manpower consuming:- A considerable amount of time is required for recording
details into the system.
5.Accuracy:- In the existing system the error rate is high and it is difficult to locate the errors and
correct them. Calculations made on papers often leads to cash mismatch and inaccurate results.
6.Alternations:- It is difficult to make corrections. If a manual document contains errors or need
updating it is often necessary to recreate the whole document from scratch, rather than just a new
version with the relevant details changed.

14
 7.Redundancy:- If a customer gives different works at different time, each time the customer
arrives, the administrator want to store the personnel details repeatedly with each work.
8.User friendliness:- In the existing system, the degree of user friendliness is considerably low.
This system involves readability of the records and maintenance of different details
9.Back up:- Back up of data cannot be done easily since all data are in different registers and are
written on paper

1.1.2 System Analysis

3.2.3.2 Identifying Needs of the System
The work that was being carried out with the help of the manual system has to be transferred to
that of an automated one for a variety of reasons,
1. The manual system is slowly being phased out and all the activities that are being carried out
by the manual system could easily and efficiently been alone by the automated system.
2. There are many functions that demanded computerization, but were not being covered by the
manual system.
3. The throughout time is high for processing.
4. As information is very voluminous and it is not possible to run systematically and accurately
considering the time factor.
The system also needs easy access with a computer system we can easily access any records in it. But
when it is in manual systems it is difficult to find it using its serial numbers or something like that. So
now a day the need of the automated system is important.

1.1.2.2 Preliminary Investigation

In the process of designing any system, conducting a thorough preliminary investigation is
paramount, serving as a crucial aspect of requirement analysis. The primary objective of this
investigation is to elucidate issues within the existing system while fortifying the analyst’s understanding
and background in the problem domain. Throughout the investigative phase for my wedding event
management system, I extensively explored various online platforms offering details about event
planning. However, I observed a lack of interactivity in many existing websites.
This realization prompted a focused approach, recognizing the scarcity of websites specifically tailored
for wedding event management. While numerous general event planning websites exist, there is a
noticeable gap in platforms dedicated exclusively to the intricacies of wedding planning. This
observation led to the inception of a system designed specifically for wedding events. The targeted focus

15
on the wedding category aims to provide users with a more efficient and tailored experience, making it
easier to find and manage wedding-related services.
By honing in on the wedding event management niche, the system endeavors to offer a more interactive
and user-friendly interface, distinguishing itself from generic event planning platforms. This tailored
approach not only addresses the unique needs of individuals planning weddings but also streamlines the
process of locating suitable vendors and services within this specific category. Ultimately, the system
aims to fill a void in the online landscape, providing a dedicated and comprehensive solution for
individuals embarking on the journey of planning their wedding events.

3.2 PROPOSED SYSTEM

The primary objective of the proposed system is to enhance efficiency while optimizing storage and
retrieval of data, facilitating a streamlined decision-making process within the realm of wedding event
management. This system adopts a menu-driven approach, prioritizing higher user-friendliness to ensure
that users can navigate the application with ease. The goal is to empower users to input data accurately,
minimizing errors in the process.
The proposed system for wedding event management encompasses distinct modules for data entry and
report generation, providing users with dedicated functionalities tailored to their specific needs. Its user-
friendly design encourages a seamless experience for individuals involved in planning wedding events.
Users can explore a range of services, check venue availability, select event timings, input personal
details, make secure payments using card details, and review their past event booking history.
The administrative role in the system involves the verification of all accounts during the registration
process. The admin assumes a pivotal role in monitoring the data provided by both users and vendors,
ensuring the integrity and authenticity of the information. This oversight guarantees a reliable and secure
platform for users and vendors alike, establishing a foundation of trust in the wedding event management
process. The proposed system is poised to revolutionize the wedding planning experience, offering a
comprehensive solution that aligns with the evolving needs of individuals navigating the intricacies of
organizing memorable events.
1.2.1 Advantages of Proposed System
Data entry screens are designed such that they are very user friendly and minimum typing is required
from the user,
• Not much training required
• System provides various information’s report quickly and accurately in easily understandable
formats.

16
 • It aims on paperless work.
• Fast access information.
• Efficient traceability
• Duplication of data will be avoided.
• Menu driven interface provides ease to use.
• Availability of previous data for future reference.

3.2 FEASIBILITY STUDY

During the system analysis, a feasibility study of the proposed system was carried out to see
whether it was beneficial to the organization or not. The existing system is manual. Some data are
currently recorded in books. The books have to be referred every time when a new item is added or an
item is removed. The existing system is compared with the merits of the new system. If there is no loss
for the organization then the proposed system is considered as financially feasible.
The results of the feasibility study are:-
1. Economic feasibility
2. Technical feasibility
3. Behavior feasibility

1.3.1 Economic Feasibility

Economic analysis is the most frequently used method for evaluating the effectiveness of the
proposed system. It is more commonly known as cost benefit analysis, the procedure is to determine the
benefit and saving that are expected from the proposed system and compare them with the cost of the
existing system. If the benefits outweigh cost then a decision is made to design and implement the
system. Otherwise make alterations in the proposed system. The system can be developed technically
and if used would still be good for the organization. The cost is found to be lesser as compared to the
benefits of the proposed system. The work load of the user will decrease to half of the current work load.
Hence the proposed system is found to be economically feasible.

1.3.2 Technical Feasibility

Technical study is a study of hardware and software requirements. Technical feasibility concentrates
on the organization to what extend it and support the proposed system. The question to be answered is
whether the organization is technically capable to operate the system.

17
1.3.2.1 Hardware Requirements:
• Pentium IV
• 256MB RAM
• 500MB HDD
1.3.2.2 Software Requirements:
• Windows 2000 or above
• Web browser with active Internet connectivity

1.3.3 Behavior Feasibility

The developed system is completely driven and user friendly. Also the system is developed using
HTML, CSS and JavaScript as front end, which is user interface. There is no need of skill for new user
to open this Website and use it. Reports will be exactly as per our requirements.

18
SYSTEM SPECIFICATION

19
 1. SYSTEM SPECIFICATION

2.1 ABOUT THE FRONT END

The system is created using HTML, CSS, Ajax, jQuery, Bootstrap and JavaScript as front end.

HTML
HTML is a computer language devised to allow Website creation. These Websites can then be
viewed by anyone else connected to the Internet. It is relatively easy to learn, with the basics being
accessible to most people in one sitting; and quite powerful in what it allows you to create. It is
constantly undergoing revision and evolution to meet the demands and requirements of the growing
Internet audience under the direction of the W3C, the organization charged with designing and
maintaining the language.
HTML consists of a series of short codes typed into a text-file by the site author these are the
tags. The text is then saved as a HTML file, and viewed through a browser, like Internet Explorer. This
browser reads the file and translates the text into a visible form, hopefully rendering the page as the
author had intended. Writing your own HTML entails using tags correctly to create your vision. You can
use anything from a rudimentary text editor to a powerful graphical editor to create HTML pages.
Despite its simplicity, HTML is a powerful tool that allows creators to fashion a wide array of
web content. From static web pages to dynamic and interactive elements, HTML forms the backbone of
web development. Its versatility is further enhanced by its compatibility with other technologies and
languages, allowing seamless integration for more complex web projects.
Creating HTML pages can be done using a range of tools, from rudimentary text editors to
sophisticated graphical editors. The choice of tools depends on the complexity of the project and the
preferences of the developer. Regardless of the tool used, understanding and correctly employing HTML
tags is essential for translating creative visions into fully functional and visually appealing web pages.

CSS
Stands for “Cascading Style Sheet.” Cascading style sheets are used to format the layout of Web
pages. They can be used to define text styles, table sizes, and other aspects of Web pages that previously
could only be defined in a page’s HTML. CSS helps Web developers create a uniform look across
several pages of a Web site. Instead of defining the style of each table and each block of text within a
page’s HTML, commonly used styles need to be defined only once in a CSS document. Once the style is
defined in cascading style sheet, it can be used by any page that references the CSS file. Plus, CSS

20
makes it easy to change styles across several pages at once. For example, a Web developer may want to
increase the default text size from 10pt to 12pt for fifty pages of a Web site. If the pages all reference the
same style sheet, the text size only needs to be changed on the style sheet and all the pages will show the
larger text.
While CSS is great for creating text styles, it is helpful for formatting other aspects of Web page
layout as well. For example, CSS can be used to define the cell padding of table cells, the style,
thickness, and color of a table’s border, and the padding around images or other objects. CSS gives Web
developers more exact control over how Web pages will look than HTML does. This is why most Web
pages today incorporate cascading style sheets.
CSS provides web developers with a high degree of flexibility and ease of modification. When
changes need to be applied across multiple pages, such as adjusting the default text size or altering the
layout, CSS simplifies the process. For instance, if a web developer wants to increase the text size for
fifty pages, modifying the style in the CSS document achieves this uniformly across all referenced
pages. This centralized approach to styling contributes to efficient maintenance and the ability to make
global adjustments seamlessly.
In the modern web development landscape, CSS has become a standard and widely adopted
technology. Its ability to provide control over visual elements, offer efficient style management, and
enable consistent designs across websites has made it an indispensable tool for web developers. As a
result, the incorporation of cascading style sheets is commonplace in the creation of web pages,
demonstrating their significance in shaping the present and future of web design and development.

Ajax
Ajax is a set of web development techniques using many web technologies on the client side to create
asynchronous web applications. With Ajax, web applications can send and retrieve data from a server
asynchronously (in the background) without interfering with the display and behavior of the existing
page. By decoupling the data interchange layer from the presentation layer, Ajax allows web pages and,
by extension, web applications, to change content dynamically without the need to reload the entire
page. In practice, modern implementations commonly utilize JSON instead of XML.
A key feature of Ajax is its ability to enable asynchronous data interchange between the client
and the server. This asynchronous communication means that web applications can fetch or send data
without waiting for a full page reload. This results in a more seamless and responsive user experience, as
users can interact with the application while data is being exchanged with the server in the background.
Ajax adopts a decoupled approach by separating the data interchange layer from the presentation

21
layer. This separation allows web pages and applications to dynamically change their content without the
need for a complete page reload. By doing so, Ajax enhances the responsiveness of web applications,
offering a smoother and more interactive user interface.
One of the significant advantages of Ajax is its capacity to update content dynamically.
Traditional web applications often required reloading the entire page to reflect changes, causing
interruptions and delays. Ajax eliminates this need, enabling specific parts of a page to be updated
independently. This results in a more efficient use of resources and a faster, more dynamic user
experience.

jQuery
jQuery is a JavaScript library designed to simplify HTML DOM tree traversal and manipulation, as
well as event handling, CSS animation, and Ajax. It is free, open source software using the permissive
MIT License. As of May 2019, jQuery is used by 73% of the 10 million most popular websites. Web
analysis indicates that it is the most widely deployed JavaScript library by a large margin, having 3 to 4
times more usage than any other JavaScript library.
At its core, jQuery simplifies the process of interacting with the HTML DOM. It provides a
concise and expressive syntax for selecting and manipulating elements within a web page, significantly
reducing the amount of code required for common tasks. Additionally, jQuery includes built-in functions
for handling events, creating animations using CSS, and implementing Ajax requests seamlessly.
jQuery is open source software distributed under the permissive MIT License. This means that
developers are free to use, modify, and distribute the library without stringent restrictions. The open
source nature of jQuery has contributed to its widespread adoption and collaborative development,
fostering a large and active community of contributors and users.
The widespread use of jQuery can be attributed to its versatility and comprehensive set of
features. Whether it's simplifying complex DOM manipulations, handling events with ease, creating
smooth CSS animations, or facilitating seamless Ajax requests, jQuery stands as a go-to solution for
developers aiming to enhance the functionality and user experience of their web applications.

Bootstrap
Bootstrap is a free and open-source CSS framework directed at responsive, mobile first front-end web
development. It contains CSS- and (optionally) JavaScriptbased design templates for typography, forms,
buttons, navigation and other interface components. Bootstrap offers a comprehensive suite of CSS and
optional JavaScript-based design templates. These templates cover a wide range of interface

22
components, including typography, forms, buttons, navigation bars, and more. The framework's
intention is to streamline the development process by providing well-designed, reusable components that
contribute to the creation of visually consistent and user-friendly interfaces.
Bootstrap primarily operates as a CSS framework but also offers optional JavaScript components to
enhance interactivity and functionality. These components, such as carousels, modals, dropdowns, and
tooltips, complement the CSS styling. The integration of JavaScript functionalities seamlessly aligns
with Bootstrap's CSS framework, providing developers with a cohesive and comprehensive toolkit for
front-end development.
Bootstrap stands out for its high degree of extensibility and customization. Developers can tailor the
framework to suit the specific requirements of their projects. The customizable build system allows for
the selection of specific components, optimizing the final output and eliminating unnecessary elements.
This flexibility enables developers to maintain a lightweight and efficient development process.

JavaScript
JavaScript is a dynamic computer programming language. It is lightweight and most commonly
used as a part of Web pages, whose implementations allow clientside script to interact with the user and
make dynamic pages. It is an interpreted programming language with object-oriented capabilities.
JavaScript was first known as LiveScript, but Netscape changed its name to JavaScript, possibly
because of the excitement being generated by Java. JavaScript made its first appearance in Netscape 2.0
in 1995 with the name LiveScript. The general-purpose core of the language has been embedded in
Netscape, Internet Explorer, and other Web browsers.
JavaScript is prominently utilized for client-side scripting, enabling the creation of dynamic pages
that respond to user actions without the need for constant communication with the server. Its ability to
interact with users in real-time enhances the overall user experience on websites. JavaScript is
instrumental in validating forms, updating content dynamically, and creating interactive elements that
contribute to the user interface's responsiveness.
JavaScript's core capabilities lie in its ability to manipulate the Document Object Model (DOM)
of web pages, enabling dynamic changes to the content and structure of a page. Additionally, JavaScript
is imbued with object-oriented features, allowing developers to create modular and reusable code. This
object-oriented nature enhances code organization and promotes the creation of scalable and
maintainable web applications.
JavaScript's integration into web browsers such as Netscape and Internet Explorer played a
pivotal role in its widespread adoption. Being embedded in browsers allowed developers to execute

23
scripts directly on the client side, contributing to the rise of dynamic and interactive web pages. This
integration remains a fundamental aspect of JavaScript's role in modern web development.
2.2 ABOUT THE BACK END
The system is created with PHP , MySQL and XAMPP Server as back end.

PHP
PHP started out as a small open source project that evolved as more and more people found out
how useful it was. Rasmus Lerdorf unleashed the first version of PHP way back in 1994.
PHP is a MUST for students and working professionals to become a great Software
Engineer specially when they are working in Web Development Domain. The key advantages of
learning PHP are:
PHP is a recursive acronym for “PHP: Hypertext Preprocessor”. PHP is a server side
scripting language that is embedded in HTML. It is used to manage dynamic content, databases, session
tracking, even build entire e-commerce sites. It is integrated with a number of popular databases,
including MySQL, PostgreSQL, Oracle, Sybase, Informix, and Microsoft SQL Server. PHP is pleasingly
zippy in its execution, especially when compiled as an Apache module on the Unix side. The MySQL
server, once started, executes even very complex queries with huge result sets in record-setting time.
PHP supports a large number of major protocols such as POP3, IMAP, and LDAP.PHP4 added support
for Java and distributed object architectures (COM and CORBA), making n-tier development a
possibility for the first time. PHP is forgiving: PHP language tries to be as forgiving as possible. PHP
Syntax is C-Like.

MySQL
MySQL is an open-source relational database management system (RDBMS).Its name is a
combination of “My”, the name of co-founder Michael Widenius’s daughter and “SQL”, the
abbreviation for Structured Query Language. MySQL is free and open-source software under the terms
of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL
was owned and sponsored by the Swedish company MySQL AB, which was bought by Sun
Microsystems (now Oracle Corporation). In 2010, when Oracle acquired Sun, Widenius forked the open-
source MySQL project to create MariaDB. MySQL is a component of the LAMP web application
software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python. MySQL
is used by many database-driven web applications, including Drupal, Joomla, phpBB, and WordPress.

24
MySQL is also used by many popular websites, including Facebook, Flickr, MediaWiki, Twitter, and
YouTube

XAMPP Server
XAMPP is a free and open-source cross-platform web server solution stack package developed by
Apache Friends, consisting mainly of the Apache HTTP Server, MariaDB database, and interpreters for
scripts written in the PHP and Perl programming languages. Since most actual web server deployments
use the same components as XAMPP, it makes transitioning from a local test server to a live server
possible.
XAMPP’s ease of deployment means a WAMP or LAMP stack can be installed quickly and simply
on an operating system by a developer. With the advantage of common add-in applications such as
WordPress and Joomla! Can also be installed with similar ease using Bitnami.
A database system is an overall collection of different database software components and database
containing the part viz. Database application programs, front-end components, Database management
systems and Database.

A database system must provide the following features:

• A variety of user interfaces

• Physical data independence
• Logical data independence
• Query optimization
• Data integrity
• Concurrency control
• Backup and recovery
• Security and authentication
When creating a database, the main concept is to know how the database is structured in
SQL. SQL stands for Structured Query Language. It is a language that enables us to create and operate
on relational database, which are sets of related information stored in tables. Because of its elegance and
independence.

2.3 ABOUT THE OS

25
The OS used is Windows Operating System.

WINDOWS OS
The hall mark software of Microsoft, which had created a new wave of graphical user interface in
the industry, WINDOWS XP stands in the top of its popularity. The advent of Microsoft plus has cured
whatever faults were there in the original WINDOWS XP version and made it and useful tool to work
with the memory resident programs of it, make the reloading of WINDOWS XP easier, it plug and play
connectivity for input output devices makes a new dimension towards the use of computer system.
Connectivity to the information network slice Internet through modems makes it overstate software.
Almost all new software have their windows version also. The programmer and file manager facilities of
it had made a leap way towards giving a new dimension towards the operation of computer systems

26
SYSTEM ANALYSIS
AND
DESIGN

27
 3. SYSTEM ANALYSIS AND DESIGN

System design’s main aim is to identify the modules that should be in the system, and the
specifications of these modules and how they interact with each other to produce the desired results. At
the end of the system design all the major data structures, file formats and the major modules in the
system and their specification are decided.

3.1 DATA FLOW DIAGRAM

A DFD has the purpose of clarifying system requirements and identifying major transformations
that will become programs in system design. These symbols are used
in the DFD:

Source or destination of data

Data Flow

Process that transforms data flow

Data Store

28
CONTEXT LEVEL DFD

Fig 3.1 Context Level DFD for EverAfter

29
LEVEL 1.0 DFD

Fig 3.2 Level 1 DFD for EverAfter

30
LEVEL 2.0 DFD

Fig 3.3 Level 2 DFD for Admin

31
Fig 3.4 Level 2 DFD for Wedding Event

32
Fig 3.5 Level 2 DFD for User

33
3.2 TABLE DESIGN
The general theme behind a database is to handle information as an integrated whole. A database
is a collection of interrelated data stored with minimum redundancy to serve quick access and effective
storage. The database is a collection of stored data organized in such a way that all the data requirements
are satisfied by the database.
The aim of database design is to improve the existing system situation. A number of
database files were designed to hold the data requirements for running their systems. Here we have 11
major tables, described below:

DATABASE: Wedding Events Booking

TABLE OVERVIEW

SI. Table Name Description

No
1 tbl_admin To store the details of administrator.

2 tbl_weddingevents To store details of wedding events.

3 tbl_user To store details of user.

4 tbl_district To store details of district.

5 tbl_place To store details of place.

6 tbl_package To store details of packages.

7 tbl_gallery To store photos.

8 tbl_booking To store details of booking.

9 tbl_feedback To store feedback of wedding events.

10 tbl_review To store reviews of users.

11 tbl_complaint To store Complaint details.

1.

34
Table no: 1

Table Name : tbl_admin

Description : To store the details of administrator.
Primary key : admin_id
Foreigen key : nil

Sl. No Field Name Data type Size Constraints

1 admin_id INT Primary key

2 admin_name VARCHAR 100

3 admin_email VARCHAR 100

4 admin_contact VARCHAR 100

5 admin_password VARCHAR 100

Table no: 2

Table Name : tbl_weddingevents

Description : To store details of wedding events.
Primary key : wedding_event_id
Foreigen key : place_id

Sl. No Field Name Data type Size Constraints

1 wedding_event_id INT Primary key
2 wedding_event_name VARCHAR 100
3 wedding_event_contact VARCHAR 100
4 wedding_event_email VARCHAR 100
5 wedding_event_password VARCHAR 100
6 wedding_event_logo VARCHAR 00
7 wedding_event_address VARCHAR 200
8 Place_id VARCHAR 100 Foreigen key
9 Proof VARCHAR 200
10 Verification_status INT

35
Table no: 3

Table Name : tbl_user

Description : To store details of user.
Primary key : user_id
Foreigen key : place_id

Sl. No Field Name Data type Size Constraints

1 user_id INT Primary key

2 user_name VARCHAR 100

3 user_email VARCHAR 100

4 user_password VARCHAR 100

5 user_contact VARCHAR 100

6 user_gender VARCHAR 100

7 user_photo VARCHAR 100

8 user_address VARCHAR 100

9 Place_id INT Foreigen key

10 User_doj VARCHAR 100

Table no: 4

Table Name : tbl_district

Description : To store details of district.
Primary key : district_id
Foreigen key : nil

Sl. No Field Name Data type Size Constraints

1 district_id INT Primary key

2 district_name VARCHAR 100

36
Table no: 5

Table Name : tbl_place

Description : To store details of place.
Primary key : place_id
Foreigen key : district_id

Sl. No Field Name Data type Size Constraints

1 place_id INT Primary key
2 place_name VARCHAR 100
3 Place_pincode INT
4 district_id INT Foreigen key

Table no: 6

Table Name : tbl_package

Description : To store details of package.
Primary key : package_id
Foreigen key : place_id

Sl. No Field Name Data type Size Constraints

1 package_id INT Primary key

2 wedding_event_id INT Foreigen key

3 PackageName VARCHAR 255

4 PackageDescription VARCHAR 255

5 Image VARCHAR 255

6 CreatedDate VARCHAR 255

7 LastUpdate VARCHAR 255

8 price VARCHAR 255

9 venue_option VARCHAR 255

10 catering_option VARCHAR 255

11 entertainment_option VARCHAR 255

37
12 photography_option VARCHAR 255

13 grooming_option VARCHAR 255

14 stationary_option VARCHAR 255

15 transportation_option VARCHAR 255

16 coordination_option VARCHAR 255

17 party_option VARCHAR 255

Table no: 7

Table Name : tbl_gallery

Description : To store photos.
Primary key : gallery_id
Foreigen key : package_id

Sl. No Field Name Data type Size Constraints

1 gallery_id INT Primary key

2 gallery_image VARCHAR 400

3 package_id INT Foreigen key

Table no: 8

Table Name : tbl_booking

Description : To store details of booking.
Primary key : booking_id
Foreigen key : user_id, package_id

Sl. No Field Name Data type Size Constraints

1 booking_id INT Primary key

2 package_id INT Foreigen key

38
3 user_id INT 100 Foreigen key

4 booking_status INT

5 payment_amount INT

6 current_date VARCHAR 60

7 booking_date VARCHAR 50

8 description VARCHAR 50

Table no: 9

Table Name : tbl_feedback

Description : To store feedback entered by Wedding Events.
Primary key : feedback_id
Foreigen key : user_id

Sl. No Field Name Data type Size Constraints

1 feedback_id INT Primary key
2 user_id INT Foreigen key
3 user_name VARCHAR 255
4 user_email VARCHAR 255
5 message VARCHAR 255
6 created_at TIMESTAMP

Table no: 9

Table Name : tbl_review

Description : To store review of user.
Primary key : review_id
Foreigen key : user_id, wedding_event_id

Sl. No Field Name Data type Size Constraints

1 review_id INT Primary key

39
2 user_id INT Foreigen key
E3 user_rating INT
4 user_review VARCHAR 50
5 review_datetime DATETIME
6 wedding_event_id INT Foreigen key

Table no: 12

Table Name : tbl_complaint

Description : To store Complaint details.
Primary key : complaint_id
Foreigen key : user_id,

Sl. No Field Name Data type Size Constraints

1 complaint_id INT Primary key
2 user_id INT Foreigen key
3 user_name VARCHAR 50
4 subject VARCHAR 50
5 description VARCHAR 50
6 replay TEXT
7 created_at TIMESTAMP 100

3.3 INPUT DESIGN

Input is the process of converting user inputs computer based format. The project requires a set of
information from the user to prepare a report. In the order, when organized input data are needed.
In the system design phase, the expanded DFD identifies logical data flow, data stores and destination.
Input data is collected and organized into groups of similar data. The goal behind designing input data is

40
to make the data entry easy and make it free from logical error. So the input screens in the system should
be really flexible and faster to use. The input entry to all type of user is the Email and password. If they
are valid the user is allowed to enter into the Web page. (Refer Appendix 8.1)
Objectives
 To produce a cost-effective method of input
 To achieve the highest possible level of accuracy.
 To ensure that the input is acceptable and understandable
 To make clutter free screens
 The prevention of irrelevant data entry
 To make a user friendly input screen
Entry and modification of personal details can be done easily. All data entry screens should be
interactive nature. The input design determines whether the user can interact directly with the computer.
Without input design, we can say that it is more user friendly as compared to the existing manual system
containing paper operations.

3.4 OUTPUT DESIGN

Outputs are the most important direct source of information to the user and to the management.
Efficient and eligible output design should improve the system’s relationship with the user and help in
decision making, (Refer Appendix 8.2)

Output design generally deals with the results generated by the system i.e, reports. These reports
can be generated from stored or calculated values. Reports are displayed either as screen window
preview or printed form. Most end users will not actually operate the information system or enter data
through workstation, but they will use the output from the system.

3.5 MENU DESIGN

Menus are designed for the manipulation of the screen. Menu is universal interface for any type of
environment. The menu allows the user’s choice of response but reduce the chances of error in data.
There is a main window, which contain main menu. By using the appropriate menu option we select

41
screens or windows for input data entry. Access protection is achieved through the password. The user
can enter into main window only by giving the correct email and password. Menu provides a set of
options on the screen. Cursor movements can select the options. The application consists of number of
data manipulation screens. By clicking in the options or menu items we can go to the desired form.

42
SYSTEM DESCRIPTION

43
 4. SYSTEM DESCRIPTION

‘EverAfter’ website for Booking wedding events is intended to perform the following tasks,

User Registration and Authentication: Any user interested in planning a wedding can easily
create an account by providing basic personal details. The admin verifies and approves these details,
granting users access to their accounts upon successful authentication. Users can then log in using
their credentials, allowing them to view, edit profile details, and change their account password.

Search and Booking: Users are empowered to explore various wedding vendors and services
through the platform. They can efficiently check the availability of different services, select specific
time slots, and seamlessly complete the booking process. Payments are facilitated by providing
necessary details, and users receive email notifications confirming their bookings. The platform
enables users to view detailed billing information and access their entire booking history.

Vendor (Service Provider) Registration: Service providers such as venues, caterers, florists, etc.,
can register on the platform by submitting their details along with relevant licenses. After thorough
verification by the admin, vendors gain access to their accounts. Once logged in, vendors can
manage and update their details, change passwords, and handle their bookings. Vendors have the
flexibility to set and update pricing for their services, view user complaints, and respond to user
feedback.

Admin Responsibilities: The admin holds a pivotal role in the system, responsible for verifying
and approving user and vendor registrations. They possess the authority to add wedding service
categories, manage complaint types, input district information, and incorporate venue locations.
Admins can effectively monitor and respond to feedback and complaints submitted by users and
vendors, ensuring a responsive and secure platform.

The 'EverAfter' system is meticulously designed to offer a comprehensive and user-friendly

experience for individuals embarking on the journey of planning their wedding events. It establishes
seamless communication between users and vendors while prioritizing the integrity and security of
the platform.

44
 SYSTEM TESTING
AND
IMPLEMENTATION

45
 5. SYSTEM TESTING AND IMPLEMENTATION

oftware testing is a crucial phase in the realm of system quality assurance, serving as the ultimate review
of specifications, design, and coding. This process is integral to the success of a software system, acting
as a safeguard against errors that may be introduced at any stage during development. The primary
objective of testing is to ensure that the software functions as intended, meeting the specified
requirements and delivering a reliable and robust performance.
The testing phase involves the execution of the program with a predefined set of test data. The output
generated by the program is then meticulously evaluated to determine whether it aligns with the
expected behavior outlined in the system's design and specifications. This systematic evaluation aims to
uncover defects, bugs, or deviations from the desired functionality, allowing for their timely
identification and rectification.
It's important to note that software testing is a multifaceted process, encompassing various levels and
types of testing. The testing hierarchy typically includes unit testing, integration testing, system testing,
and user acceptance testing. Each level addresses different aspects of the software's functionality,
ensuring a comprehensive examination of its behavior under diverse conditions.
Unit testing involves scrutinizing individual units or components of the software in isolation, verifying
that each unit functions correctly. Integration testing assesses the interactions between different units,
ensuring seamless integration and communication between them. System testing takes a holistic
approach, evaluating the entire system's performance as a unified entity. This level of testing assumes
that if each individual part is correct, the overall system will successfully achieve its intended goals.
Furthermore, user acceptance testing is a critical step where the software is evaluated by end-users to
ensure that it meets their needs and expectations. This phase provides valuable insights into the
software's usability, performance, and overall user experience.
The significance of thorough testing becomes evident when considering the dynamic nature of software
development. Changes in requirements, evolving user needs, and unforeseen issues can all contribute to
the introduction of defects. Rigorous testing practices serve as a safety net, helping to identify and
mitigate these issues early in the development lifecycle, ultimately enhancing the reliability and quality
of the software.
In summary, software testing is a comprehensive and dynamic process that plays a pivotal role in
ensuring the success of a system. It not only validates the correctness of individual components but also
examines the system as a whole, providing assurance that the software performs reliably and meets the
specified requirements before it undergoes user acceptance testing. Through systematic testing,
developers can confidently deliver high-quality software that aligns with user expectations and industry

46
standards.
TYPES OF TESTING:
• Unit Testing
• Integration Testing
• Validation Testing
• Output Testing

5.1 SYSTEM TESTING

5.1.1. UNIT TESTING

Unit testing focuses verification effort on the smallest unit of the software design, the module this
is known as module testing. Since the proposed system has modules the testing is individually
performed on each module. Using the details description as a guide, important control paths are tested to
uncover errors within the boundary of The modules. This testing was carried out during programming
stage itself. In This testing step each module is found to be working satisfactorily as regards to the
expected output from the module. In our system, we want to check the information like whether the
inputs are saved to back end correctly. So every form includes this testing because we want to maintain
our database because information like document to be saved, the personal information, security features
are so sensitive and should check it perfectly by each module from the beginning. These are checked in
the programming step itself.

5.1.2 INTEGRATION TESTING

Data can be test across an interface, one module can have adverse effect on another, sub function
when combined may not produced the desired function. Integration testing is a systematic technique for
constructing the program structure while at the same time conducting test to uncover errors associated
within the interface. The objective is to take unit tested modules and built a program structure that has
been dictated by design. All modules are combined in this testing step. The entire program is tested as a
whole. Correction is difficult at this stage because the isolation of causes is complicated by the vast
expense of the program.

47
Thus in the integration testing step all the errors uncover are corrected for the next testing step.
Primarily we have met with several errors like data save and table linking. These are corrected well.

5.1.3 VALIDATION TESTING

At the culmination of integration testing, software is completely assembled as a package.
Interfacing errors have been uncovered and corrected and a final series of software test-validation
testing begins. Validation testing can be defined in many ways, but a simple definition is that
validation succeeds when the software functions in manner that is reasonably expected by the user.
Software validation is achieved through a series of tests that demonstrate conformity with
requirement. After validation test has been conducted, one of two conditions exists.
•The function or performance characteristics confirm to specifications and are accepted.
•A validation from specification is uncovered and a deficiency created.
Deviation or error discovered at this step in this project is corrected prior to completion of the
project with the help of the user. Thus the proposed system under consideration has been tested by
using validation testing and found to be working satisfactorily.

5.1.4 OUTPUT TESTING

After performing the validation testing, the next step is output testing of the proposed system
since no system could be useful if it does not produce the required output in the specific format. The
output generated or displayed by the system under consideration is tested asking the users about the
format required by them.

In the first test, we saw that our services are disordered and not interactive. We made it in this
step. The output format on the screen is found to be correct as the format designed according to the
user needs. For the hard copy also, the output comes out as specified by the user. Hence output
testing doesn’t result in any connection in the system.

5.2 SYSTEM IMPLEMENTATION

Implementation is the stage in the project where the theoretical design is turned into a working
system and is giving confidence on the new system for the users, that it will work efficiently and
effectively. It involves careful planning, investigation of the current system and its constraints
implementation, design of methods to achieve the change over, an evaluation, of change over
methods.

48
 Implementation is the final and important phase. The most critical stage in achieving a successful
new system and in giving the users confidence that the new system will work and be effective. The
system can be implemented only after through testing is done and if it found to working according to
the specification. This method also offers the greatest security since the old system can take over if
the errors are found or inability to handle certain type of transactions while using the new system.

At the beginning of the development phase a preliminary implementation plan is created to schedule
and manage the many different activities must be integrated into plan. The implementation plan is
updated throughout the development phase, culminating in A changeover plan for the operation
phase. The major elements of implementation plan are test plan, training plan, equipment installation
plan and A conversion plan.

There are three types of implementation:

• Implementation of a computer system to replace a manual system.

• Implementation of a new computer system to replace an existing one.
• Implementation of a modified application to replace an existing one, using the same computer.

49
CONCLUSION

50
 6. CONCLUSION

The successful completion of the "EverAfter" wedding event management platform marks a
significant milestone in the realm of streamlined and user-centric event planning. The project was
executed within the designated timeframe, fostering maximum interaction and adaptability to meet
the diverse needs of clients and vendors alike. Rigorous testing affirmed the system's efficiency,
with data maintenance achieving commendable results.

Utilizing a robust technology stack including HTML, CSS, Bootstrap, Ajax, jQuery, JavaScript,
PHP, MySQL, and the XAMPP Server, "EverAfter" was meticulously developed and tested with
diverse datasets. The system's attractive design and modular architecture facilitate swift
development, implementation, and maintenance. The incorporation of advanced features ensures
versatility and user-friendliness, aligning with the sophisticated demands of the wedding planning
domain.

The seamless integration of modules, coupled with real-data testing, underscored the well-planned
and designed nature of the system. The performance of "EverAfter" met and exceeded
expectations, successfully realizing all predefined objectives. The system's minimal hardware
requirements enhance accessibility, providing a robust communication environment for connecting
clients and vendors seamlessly.

In conclusion, "EverAfter" emerges as a testament to effective event management, offering

numerous advantages in facilitating communication and connecting individuals involved in the
intricate process of wedding planning. The platform not only meets but surpasses the identified
objectives, setting a new standard for user-friendly and efficient wedding event management
systems.

51
BIBLIOGRAPHY

7.BIBLIOGRAPHY

52
Text Book

• SYSTEM ANALYSIS AND DESIGN,

Elias M Award, Second Edition, 1999,
Galgotica Publications, Delhi.

• DATABASE SYSTEM CONCEPTS,

Silberschatz, Korth,
Sudarshan, Fourth Edition.

• WEB PROGRAMMING USING PHP,

Dr. Jeeva Jose,
Kalyani Publication

Website References

https://www.tutorialspoint.com
GeeksforGeeks | A computer science portal for geeks
WordPress Themes & Website Templates - Colorlib

53
APPENDIX

54
 8.Appendix

8.1 SCREENSHOTS

Fig 8.1 Guest Homepage

Fig 8.2 Login Page

55
 Fig 8.3 User Registration

Fig 8.4 Wedding Event Registration

56
57
 Fig 8.5 User Homepage

Fig 8.6 User My Profile

58
Fig 8.7 User Edit Profile

Fig 8.8 User Change Password

59
Fig 8.9 Search Events

Fig 8.10 Packages

Fig 8.11 Booking Page

60
Fig 8.12 Gallery

61
Fig 8.13 Payment Page

Fig 8.14 User Bookings

62
Fig 8.15 Post user Complaint

Fig 8.15 Wedding Event Homepage 1.0

63
Fig 8.16 Wedding Event Homepage 1.1

Fig 8.17 Wedding Event My Profile

64
Fig 8.18 Wedding Events Edit Profile

Fig 8.19 Wedding Events Change Password

65
Fig 8.20 Packages Insertion

66
 Fig 8.21 My Packages

Fig 8.22 Rating By User

67
Fig 8.23 View Events Complaints

Fig 8.24 Adding District

68
Fig 8.25 Place

Fig 8.26 Verification

69
 Fig 8.27 View Complaints

Fig 8.28 View Feedbacks

70
Fig 8.29 Booking Report

Fig 8.30 User Report

71