BEAUTY PARLOUR - REPORT .New

BEAUTY PARLOUR MANAGEMENT SYSTEM 2021-22
VISVESVARAYA TECHNOLOGICAL UNIVERSITY
“Jnana Sangama”, Belagavi-590 018
A
Mini Project Report
On
“BEAUTY PARLOUR MANAGEMENT SYSTEM”
Submitted in partial fulfillment of the requirement for the DBMS Laboratory with
Mini project (18CSL58) of V semester
Bachelor of Engineering
in
Computer Science and Engineering
Submitted By
AMISHA SARIKA GOWDA (1GA19CS011)

DEEPA P (1GA19CS042)
Under the Guidance of

Dr. Pramila B Mrs. Shruthi P
Professor, Dept. of CSE Professor, Dept. of CSE
Department of Computer Science and Engineering
GLOBAL ACADEMY OF TECHNOLOGY

Rajarajeshwarinagar, Bengaluru-560 098
2021
Dept. of CSE, GAT 1

GLOBAL ACADEMY OF TECHNOLOGY

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING
CERTIFICATE
Certified that the V Semester Mini Project in DBMS Laboratory Entitled “Beauty Parlour
Management System” carried out by Ms. AMISHA SARIKA GOWDA (1GA19CS011)
and Ms. DEEPA P (1GA19CS042), submitted in partial fulfillment for the award of the
BACHELOR OF ENGINEERING in Computer Science and Engineering from
Visvesvaraya Technological University, Belagavi during the year 2018-2019.The DBMS
Mini Project report has been approved as it satisfies the academic requirements in
respect of the mini project work prescribed for the said Degree.
----------------------- ---------------------------- ------------------------

Dr. Pramila B Mrs. Shruthi P Dr. Bhagyashri R Hanji
Professor Professor Professor & HOD
Dept of CSE Dept of CSE Dept of CSE
GAT,Bengaluru GAT,Bengaluru GAT,Bengaluru
EXTERNAL EXAM
Name of the Examiners Signature with Date
1. ____________________ ____________________
2. _____________________ ______________________
Dept. of CSE, GAT 2

ABSTRACT
With tremendous increase in technology, information technology is a fast developing

field. Technology which is in vogue today might become redundant tomorrow. This ever
changing scenario makes it possible to provide the latest and most modern IT solutions to
various business and institutions.
I am doing my project on Beauty Parlour Management System. There is the need for
efficient management of a network based system for handling customer services.
This project is an endeavor to provide a solution to this. The proposed system enables an
administrator to keep track of customer services and maintaining records of the
customers.
He can view the submitted requirements made by the customer. He can also view the
reports generated by him and can also sent approvals or rejections instantly.
Beauty Parlour Management System is essentially a web-based application that's inbuilt

Php with CSS, Ajax and js(javascript). The users of the system include the customers
where they can register initially with the minimum details and will be allowed to make
an appointment.
Thus the project is a sincere effort in simplifying the task of administrators in an easily
usable format.
I finalized to make this project and hence planned to develop this system using PHP for
front end and MySQL as the Back End.
Dept. of CSE, GAT 3

ACKNOWLEDGEMENT
The satisfaction and euphoria that accompany the successful completion of

any task would be incomplete without the mention of the people who made it
possible and whose constant encouragement and guidance crowned our efforts
with success.
I consider myself proud, to be part of Global Academy of Technology family,

the institution which stood by the way in endeavors.
I express my deep and sincere thanks to our Principal Dr. N. Ranaprathap

Reddy.
I am grateful to Dr. Bhagyashri R Hanji, Professor and HOD, Dept of CSE

who is source of inspiration and of invaluable help in channelizing my efforts
in right direction.
I wish to thank my internal guide Dr. Pramila B Professor Mrs. Shruthi P

Assistant Professor, Dept of CSE for guiding and correcting various
documents of mine with attention and care. She has taken lot of pain to go
through the document and make necessary corrections as and when needed.
I would like to thank the faculty members and supporting staff of the
Department of CSE, GAT for providing all the support for completing the
Project work.
Finally, I am grateful to my parents and friends for their unconditional support and
help during the course of my Project work.
AMISHA SARIKA GOWDA
DEEPA P
Dept. of CSE, GAT 4

TABLE OF CONTENTS
ABSTRACT
LIST OF TABLES
LIST OF FIGURE
1.INTRODUCTION
1.1 INTRODUCTION TO SQL
1.2 INTRODUCTION TO FRONTEND SOFTWARE
1.3 PROJECT REPORT OUTLINE
2. REQUIREMENT SPECIFICATION
2.1SOFTWARE REQUIREMENTS
2.2HARDWARE REQUIREMENTS
3. OBJECTIVE OF THE PROJECT
4. IMPLEMENTATION
4.1 ER DIAGRAM
4.2 MAPPING OF ER DIAGRAMSCHEMA DIAGRAM
4.3 MAPPING OF THE ER SCHEMA TO RELATIONS
4.4 CREATION OF TABLES
4.5 INSERTION OF TUPLES
4.6 CREATION OF TRIGGERS
4.7 CREATION OF STORED PROCEDURES
5. FRONT END DESIGN

6.TESTING
6.1 TEST CASES OF THE PROJECT
Dept. of CSE, GAT 5

7. RESULTS
7.1 SNAPSHOTS
CONCLUSION
REFERENCES
Dept. of CSE, GAT 6

LIST OF TABLES
TABLE NO TITLE
4.1 ER diagram of Beauty Parlor Management System
4.2 Mapping of ER diagram to Schema diagram
4.2 Schema diagram of Beauty Parlor Management System
LIST OF FIGURES
Dept. of CSE, GAT 7
FIGURE NO. TITLE PAGE NO.
Snapshot 1 Index Page 42
Snapshot 2 Operation Page 43
Snapshot 3 Insert Page 43
Snapshot 4 Output of insert 44
Snapshot 5 Search Page 44
Snapshot 6 Update Page 45
Snapshot 7 Updating Details 45
Snapshot 8 Stored Procedure 46
Snapshot 9 Triggers 46
CHAPTER 1
INTRODUCTION
Dept. of CSE, GAT 8

1.1 INTRODUCTION TO SQL

SQL is used to communicate with a database. According to ANSI (American
National Standards Institute), it is the standard language for relational database
management systems. SQL statements are used to perform tasks such as update data on a
database, or retrieve data from a database. Some common relational database management
systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.
Although most database systems use SQL, most of them also have their own
additional proprietary extensions that are usually only used on their system. However, the
standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and
"Drop" can be used to accomplish almost everything that one needs to do with a database.
MySQL is the most popular Open Source Relational SQL Database Management System.
MySQL is one of the best RDBMS being used for developing various web-based software
applications. MySQL is developed, marketed and supported by MySQL AB, which is a
Swedish company.
A database is a separate application that stores a collection of data. Each database

has one or more distinct APIs for creating, accessing, managing, searching and replicating
the data it holds. Other kinds of data stores can also be used, such as files on the file
system or large hash tables in memory but data fetching and writing would not be so fast
and easy with those types of systems. Nowadays, we use relational database management
systems (RDBMS) to store and manage huge volume of data. MyppSQL is released under
an opensource license. So, you have nothing to pay to use it. MySQL is a very powerful
program in its own right. JAVA, etc. MySQL works very quickly and works well even
with large data sets.
1.2 INTRODUCTION TO FRONT END SOFTWARE
Dept. of CSE, GAT 9

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 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
CLike.PHP performs system functions, i.e. from files on a system it can create, open, read,
write, and close them.
PHP can handle forms, i.e. gather data from files, save data to a file, through email
you can send data, return data to the user. Access cookies variables and set cookies. Using
PHP, you can restrict users to access some pages of your website. It can encrypt data.
1.3 PROJECT REPORT OUTLINE
Dept. of CSE, GAT 10

The report is arranged in the following way:
Chapter 1: Introduction
In this chapter, an introduction to SQL and an introduction to the front end software is
given.
Chapter 2: Problem Statement
It gives an overview about what the project is about. It describes and analyses the intention
of project in detail.
Chapter 3: Requirement Specification
In this chapter the software requirements and hardware requirements required for the
project are specified.
Chapter 4: System Design and Implementation
The required ER diagram and the mapping of ER diagram to the Relational Schema
diagram is done.
Chapter 5: Front end design
This chapter deals with the front end code and php code, HTML page designing required
for the project.
Chapter 6: Testing
This chapter gives the outline of all testing methods that are carried out to get a bug free
system.
Chapter 7: RESULTS
Displays the results obtained.
CHAPTER 2

REQUIREMENT SPECIFICATION
2.1 SOFTWARE REQUIREMENTS
Operating System : 64bit operating system, Windows 10

Database : MYSQL
Software : XAMPP Server
2.2 HARDWARE REQUIREMENTS
Processor : Intel® Core i5, 10 gen

th
RAM : 8.00 GB
Hard Disk : 476GB
Compact Disk : CD-ROM, CD-R, CD-RW
Input Device : Keyboard, Mouse
Output Device : Monitor
Language Used : PHP
User Interface Design
AJAX,JQUERY,JAVASCRIPT : HTML
Web Browser Chrome,
IE8,OPERA : Mozilla,Google
CHAPTER 3

OBJECTIVE
The main objective of creating a Beauty Parlour Management System project is to manage
the day-to-day tasks of the parlour & to automate all the parlour activity. The purpose of
the project is to build an application program to reduce the manual work. It manages the
information about the services available. Beauty parlour management system is a web-
based parlour management application with appointment scheduling functionality. In this
system user can review parlour and stylist online and can make appointment online. In this
system beauty parlour owner can make their account online and give details of the
services they offer and also describe the stylist information. User can review the parlours
and their services using this system and can make appointment with favorite stylist online.
User can also cancel appointments online. User can also write and reviews about the
parlours or stylist. This system helps both the customer and the parlour. Customer can
easily find best parlour in their locality and can check the review of other customer of that
parlour online. It helps him/her to take decision of taking the services of a particular
parlour.
It is designed to achieve the following objectives:

1. To computerize all details of availability of special services.
2. New customers can register, so that there is a digitalized record of it.
3. The details of every customer is maintained and stored.
4. A bill is generated after every successful transaction.
CHAPTER 4
IMPLEMENTATION

1. ER DIAGRAM
An entity relationship diagram shows the relationships of entity sets stored in a

database. Entity-Relationship Diagram is a graphical representation of entities
and their relationship to each other. It describes how data is related to each
other. An entity is a piece of data an object or a concept about which data is
stored. A relationship is how the data is shared between entities.
Fig 4.1: ER Diagram

4.2 MAPPING OF ER DIAGRAM TO SCHEMA DIAGRAM
Fig 4.2: Schema Diagram
4.3MAPPING OF THE ER SCHEMA TO RELATIONS

ER Model, when conceptualized into diagrams, gives a good overview of

entityrelationship, which is easier to understand. ER diagrams can be mapped to relational
schema, that is, it is possible to create relational schema using ER diagram. We cannot
import all the ER constraints into relational model, but an approximate schema can be
generated.
There are several processes and algorithms available to convert ER Diagrams into
Relational Schema. Some of them are automated and some of them are manual.
User Has Admin
User Request Appointment
Admin Accept/Reject Appointment
Admin Add Services
Admin Generate Invoice
Admin
Add Customer
Customer Belongs to Invoice
Customer Add Services
Fig 4.3: Mapping of ER Diagram to Schema

4.4 CREATION OF TABLES

1.CREATING ADMIN TABLE
CREATE TABLE `tbladmin` (
ÌD` int(10) NOT NULL,
ÀdminName` char(50) DEFAULT NULL,
ÙserName` char(50) DEFAULT NULL,
`MobileNumber` bigint(10) DEFAULT NULL,
Èmail` varchar(200) DEFAULT NULL,
`Password` varchar(200) DEFAULT NULL,
ÀdminRegdate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2. CREATING APPOINTMENT TABLE

CREATE TABLE `tblappointment` (
ÀptNumber` varchar(80) DEFAULT NULL,
`Name` varchar(120) DEFAULT NULL,
`PhoneNumber` bigint(11) DEFAULT NULL,
ÀptDate` varchar(120) DEFAULT NULL,
ÀptTime` varchar(120) DEFAULT NULL,
`Services` varchar(120) DEFAULT NULL,
ÀpplyDate` timestamp NULL DEFAULT current_timestamp(),
`Remark` varchar(250) NOT NULL,
`Status` varchar(50) NOT NULL,
`RemarkDate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE
current_timestamp()
3. CREATING CUSTOMERS TABLE
CREATE TABLE `tblcustomers` (

`Name` varchar(120) DEFAULT NULL,
`Gender` enum('Female','Male','Transgender') DEFAULT NULL,
`Details` mediumtext DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp(),
ÙpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp()

4. CREATING INVOICE TABLE

CREATE TABLE `tblinvoice` (
ìd` int(11) NOT NULL,
Ùserid` int(11) DEFAULT NULL,
`ServiceId` int(11) DEFAULT NULL,
`BillingId` int(11) DEFAULT NULL,
`PostingDate` timestamp NULL DEFAULT current_timestamp()
5. CREATING PAGE TABLE
CREATE TABLE `tblpage` (

`PageType` varchar(200) DEFAULT NULL,
`PageTitle` mediumtext DEFAULT NULL,
`PageDescription` mediumtext DEFAULT NULL,
ÙpdationDate` date DEFAULT NULL,
`Timing` varchar(200) NOT NULL
6. CREATING SERVICES TABLE

CREATE TABLE `tblservices` (
`ServiceName` varchar(200) DEFAULT NULL,
`Cost` int(10) DEFAULT NULL,
`CreationDate` timestamp NULL DEFAULT current_timestamp()
4.5 INSERTION OF TUPLES
INSERTION OF VALUES INTO ADMIN :
INSERT INTO `tbladmin` (ÌD`, ÀdminName`, ÙserName`, `MobileNumber`, Èmail`, `Password`,

ÀdminRegdate`) VALUES
(1, 'test', 'admin', 7898799798, '[email protected]', 'f925916e2754e5e03f75dd58a5733251', '2019-07-
25 06:21:50');
INSERTION OF VALUES INTO APPOINTMENT:

INSERT INTO `tblappointment` (ÌD`, ÀptNumber`, `Name`, Èmail`, `PhoneNumber`, ÀptDate`,

ÀptTime`, `Services`, ÀpplyDate`, `Remark`, `Status`, `RemarkDate`) VALUES
(1, '261064124', 'Komal', '[email protected]', 7798797897, '7/27/2019', '4:00pm', '1', '2019-07-26
04:48:25', 'Accepted', '1', '2019-07-26 06:41:16'),
(2, '985645887', 'Kashish', '[email protected]', 4654654654, '7/29/2019', '4:30pm', 'Deluxe Pedicure',
'2019-07-26 05:04:38', 'Rejected', '2', '2019-07-26 06:47:04'),
(3, '965887988', 'Sanjeeta Jain', '[email protected]', 5646464646, '8/20/2019', '2:30pm', 'Loreal Hair
Color(Full)', '2019-08-19 12:35:30', 'we will wait', '1', '2019-08-19 13:37:39'),
(4, '578797544', 'Anuj Kumar', '[email protected]', 123456789, '8/30/2019', '1:30am',
'Test', '2019-08-21 16:13:13', '', '', '0000-00-00 00:00:00'),
(5, '899118550', 'bb', '[email protected]', 4234235423, '8/27/2019', '1:30am', 'Loreal Hair Color(Full)',
'2019-08-21 16:14:14', '', '', '0000-00-00 00:00:00'),
(6, '621107928', 'ABC', '[email protected]', 1234567890, '8/27/2019', '1:30am', 'Rebonding', '2019-08-21
16:22:25', 'Testing', '2', '2019-08-21 16:24:10');
INSERTION OF VALUES INTO CUSTOMERS:
INSERT INTO `tblcustomers` (ÌD`, `Name`, Èmail`, `MobileNumber`, `Gender`, `Details`,

`CreationDate`, ÙpdationDate`) VALUES
(1, 'Sunita Verma', '[email protected]', 5546464646, 'Transgender', 'Taking Hair Spa', '2019-07-26
11:09:10', '2019-07-31 15:15:54'),
(2, 'Rahul Singh', '[email protected]', 5565565656, 'Male', 'Taken haircut by him', '2019-07-26
11:10:02', NULL),
(3, 'Khusbu', '[email protected]', 4646445464, 'Transgender', 'khjhhkjkjkuhj', '2019-07-26 11:10:28',
NULL),
(4, 'Sanjeeta Jain', '[email protected]', 5646464646, 'Female', 'Taking Body Spa', '2019-08-19 13:38:58',
NULL),
(5, 'Test user', '[email protected]', 1234567890, 'Female', 'Test', '2019-08-21 16:24:53', '2019-08-21
16:25:11');
INSERTION OF VALUES INTO INVOICE:
INSERT INTO `tblinvoice` (ìd`, Ùserid`, `ServiceId`, `BillingId`, `PostingDate`) VALUES

(1, 2, 2, 621839533, '2018-07-30 15:33:22'),
(2, 2, 5, 621839533, '2019-06-04 15:33:22'),
(3, 2, 6, 621839533, '2019-07-30 15:33:22'),
(4, 2, 7, 621839533, '2019-07-30 15:33:22'),
(5, 1, 1, 904156433, '2019-07-30 15:40:42'),
(6, 1, 2, 904156433, '2019-07-30 15:40:42'),
(7, 1, 3, 904156433, '2019-07-30 15:40:42'),
(8, 1, 4, 904156433, '2019-07-30 15:40:42'),
(9, 3, 1, 225057023, '2019-07-30 16:03:32'),
(10, 3, 8, 225057023, '2019-07-30 16:03:32'),

(11, 3, 1, 970548035, '2019-07-31 04:42:45'),
(12, 3, 6, 970548035, '2019-07-31 04:42:45'),
(13, 3, 9, 970548035, '2019-07-31 04:42:45'),
(14, 4, 2, 942476283, '2019-08-19 13:39:13'),
(15, 4, 12, 942476283, '2019-08-19 13:39:13'),
(16, 5, 3, 297018570, '2019-08-21 16:25:27'),
(17, 5, 4, 297018570, '2019-08-21 16:25:27'),
(18, 5, 8, 297018570, '2019-08-21 16:25:27');
INSERTION OF VALUES INTO PAGE:
INSERT INTO `tblpage` (ÌD`, `PageType`, `PageTitle`, `PageDescription`, Èmail`, `MobileNumber`,

ÙpdationDate`, `Timing`) VALUES
(1, 'aboutus', 'About Us', ' Our main focus is on quality and hygiene. Our Parlour is well equipped
with advanced technology equipments and provides best quality services. Our staff is well trained and
experienced, offering advanced services in Skin, Hair and Body Shaping that will provide you with a
luxurious experience that leave you feeling relaxed and stress free. The specialities in the parlour are,
apart from regular bleachings and Facials, many types of hairstyles, Bridal and cine make-up and
different types of Facials & fashion hair colourings.', NULL, NULL, NULL, ''),
(2, 'contactus', 'Contact Us', '890,Sector 62, Gyan Sarovar, GAIL Noida(Delhi/NCR)', '[email protected]',
7896541236, NULL, '10:30 am to 7:30 pm');
INSERTION OF VALUES INTO SERVICES:

INSERT INTO `tblservices` (ÌD`, `ServiceName`, `Cost`, `CreationDate`) VALUES
(1, 'O3 Facial', 1200, '2019-07-25 11:22:38'),
(2, 'Fruit Facial', 500, '2019-07-25 11:22:53'),
(3, 'Charcol Facial', 1000, '2019-07-25 11:23:10'),
(4, 'Deluxe Menicure', 500, '2019-07-25 11:23:34'),
(5, 'Deluxe Pedicure', 600, '2019-07-25 11:23:47'),
(6, 'Normal Menicure', 300, '2019-07-25 11:24:01'),
(7, 'Normal Pedicure', 400, '2019-07-25 11:24:19'),
(8, 'U-Shape Hair Cut', 250, '2019-07-25 11:24:38'),
(9, 'Layer Haircut', 550, '2019-07-25 11:24:53'),
(10, 'Rebonding', 3999, '2019-07-25 11:25:08'),
(11, 'Loreal Hair Color(Full)', 1200, '2019-07-25 11:25:35'),
(12, 'Body Spa', 1500, '2019-08-19 13:36:27'),
(14, 'Test', 100, '2019-08-21 15:45:50'),
(15, 'ABC', 200, '2019-08-21 16:23:23');
4.6 CREATION OF TRIGGERS
A database trigger is procedural code that is automatically executed in response to certain
events on a particular table or view in a database. The trigger is mostly used for
maintaining the integrity of the information on the database. For example, when a new
record (representing a new worker) is added to the employees table, new records should
also be created in the tables of the taxes, vacations and salaries. Triggers can also be used
to log historical data, for example to keep track of employees' previous salaries.
DELIMITER $$
BEGIN
select * from tblservices ;
END
4.7 CREATION OF STORED PROCEDURES

Stored procedures are a batch of SQL statements that can be executed in a couple of ways.
Most major DBMs support stored procedures; however, not all do. You will need to verify
with your particular DBMS help documentation for specifics. As I am most familiar with
SQL Server I will use that as my samples.
DELIMITER $$
--trigger
create add_key_tbladmin
before
insert | delete | update
on tbladmin
for each row
ALTER TABLE `tbladmin`
ADD PRIMARY KEY (ÌD`);
CHAPTER 5
FRONT END DESIGN
5.1 CONNECTIVITY TO DATABASE

In computer science, a database connection is the means by which a database server and its
client software communicate with each other. The term is used whether or not the client
and the server are on different machines.
The client uses a database connection to send commands to and receive replies from the
server. A database is stored as a file or a set of files on magnetic disk or tape, optical disk,
or some other secondary storage device. The information in these files may be broken
down into records, each of which consists of one or more fields.
Fields are the basic units of data storage, and each field typically contains information
pertaining to one aspect or attribute of the entity described by the database. Records are
also organized into tables that include information about relationships between its various
fields. Although database is applied loosely to any collection of information in computer
files, a database in the strict sense provides cross-referencing capabilities.
Connections are a key concept in data-centric programming. Since some DBMSs require
considerable time to connect, connection pooling is used to improve performance. No
command can be performed against a database without an "open and available" connection
to it.
Connections are built by supplying an underlying driver or provider with a connection

string, which is used to address a specific database or server and to provide instance and
user
Server=sql_box;Database=Common;User
ID=uid;Pwd=password;
authentication credentials
(for example, ).
<?php mysql_select_db('medicine',mysql_connect('localhost','root',''))or
die(mysql_error()); ?>
5.2 FRONT END CODE

Systems design is the process of defining the architecture, components, modules,
interfaces, and data for a system to satisfy specified requirements. Systems design could
see it as the application of systems theory to product development. There is some overlap
with the disciplines of systems analysis, systems architecture and systems engineering. If
the broader topic of product development "blends the perspective of marketing, design, and
manufacturing into a single approach to product development," then design is the act of
taking the marketing information and creating the design of the product to be
manufactured. Systems design is therefore the process of defining and developing systems
to satisfy specified requirements of the user.

Until the 1990s systems design had a crucial and respected role in the data
processing industry. In the 1990s standardization of hardware and software resulted in the
ability to build modular systems. The increasing importance of software running on
generic platforms has enhanced the discipline of software engineering.
Object-oriented analysis and design methods are becoming the most widely used
methods for computer systems design.[citation needed] The UML has become the standard
language in object-oriented analysis and design.[citation needed] It is widely used for
modelling software systems and is increasingly used for high designing non-software
systems and organizations.[citation needed]
System design is one of the most important phases of software development

process. The purpose of the design is to plan the solution of a problem specified by the
requirement documentation. In other words the first step in the solution to the problem is
the design of the project.
CODE FOR INDEX.PHP
<?php
include('includes/dbconnection.php');
session_start();
error_reporting(0);
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$email=$_POST['email'];
$services=$_POST['services'];
$adate=$_POST['adate'];
$atime=$_POST['atime'];
$phone=$_POST['phone'];
$aptnumber = mt_rand(100000000, 999999999);
$query=mysqli_query($con,"insert into
tblappointment(AptNumber,Name,Email,PhoneNumber,AptDate,AptTime,Services)
value('$aptnumber','$name','$email','$phone','$adate','$atime','$services')");
if ($query) {

$ret=mysqli_query($con,"select AptNumber from tblappointment where Email='$email' and

PhoneNumber='$phone'");
$result=mysqli_fetch_array($ret);
$_SESSION['aptno']=$result['AptNumber'];
echo "<script>window.location.href='thank-you.php'</script>";
}
else
{
$msg="Something Went Wrong. Please try again";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>BPMS||Home Page</title>
<link
href="https://fonts.googleapis.com/css?family=Work+Sans:100,200,300,400,500,600,700,800,900"
rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Pacifico" rel="stylesheet">
<link href="https://fonts.googleapis.com/css?family=Playfair+Display:400,400i,700,700i,900,900i"
rel="stylesheet">
<link rel="stylesheet" href="css/open-iconic-bootstrap.min.css">

<link rel="stylesheet" href="css/animate.css">
<link rel="stylesheet" href="css/owl.carousel.min.css">

<link rel="stylesheet" href="css/owl.theme.default.min.css">
<link rel="stylesheet" href="css/magnific-popup.css">
<link rel="stylesheet" href="css/aos.css">
<link rel="stylesheet" href="css/ionicons.min.css">
<link rel="stylesheet" href="css/bootstrap-datepicker.css">

<link rel="stylesheet" href="css/jquery.timepicker.css">
<link rel="stylesheet" href="css/flaticon.css">

<link rel="stylesheet" href="css/icomoon.css">
<link rel="stylesheet" href="css/style.css">

</head>
<body>
<?php include_once('includes/header.php');?>

<section id="home-section" class="hero" style="background-image: url(images/bg.jpg);" data-stellar-

background-ratio="0.5">
<div class="home-slider owl-carousel">
<div class="slider-item js-fullheight">
<div class="overlay"></div>
<div class="container-fluid p-0">
<div class="row d-md-flex no-gutters slider-text align-items-end justify-content-end" data-
scrollax-parent="true">
<img class="one-third align-self-end order-md-last img-fluid" src="images/bg_1.png" alt="">
<div class="one-forth d-flex align-items-center ftco-animate" data-scrollax=" properties:
{ translateY: '70%' }">
<div class="text mt-5">
<span class="subheading">Beauty Parlour</span>
<h1 class="mb-4">Get Pretty Look</h1>
<p class="mb-4">We pride ourselves on our high quality work and attention to
detail. The products we use are of top quality branded products.</p>
</div>
</div>
</div>
</div>
</div>
<div class="slider-item js-fullheight">

<div class="container-fluid p-0">
<div class="row d-flex no-gutters slider-text align-items-center justify-content-end" data-
scrollax-parent="true">
<img class="one-third align-self-end order-md-last img-fluid" src="images/bg_2.png" alt="">
<div class="one-forth d-flex align-items-center ftco-animate" data-scrollax=" properties:
{ translateY: '70%' }">
<div class="text mt-5">
<span class="subheading">Natural Beauty</span>
<h1 class="mb-4">Beauty Salon</h1>
<p class="mb-4">This parlour provides huge facilities with advanced
technology equipments and best quality service. Here we offer best treatment that you might have never
experienced before.</p>

</div>
</div>
</div>
</div>
</div>
</div>
</section>
<br>
<section class="ftco-section ftco-no-pt ftco-booking">
<div class="container-fluid px-0">
<div class="row no-gutters d-md-flex justify-content-end">
<div class="one-forth d-flex align-items-end">
<div class="text">
<div class="appointment-wrap">
<span class="subheading">Reservation</span>
<h3 class="mb-2">Make an Appointment</h3>
<form action="#" method="post" class="appointment-form">
<div class="row">
<div class="col-sm-12">
<div class="form-group">
<input type="text" class="form-control" id="name"
placeholder="Name" name="name" required="true">
</div>
</div>
<input type="email" class="form-control"
id="appointment_email" placeholder="Email" name="email" required="true">
</div>
</div>
<div class="select-wrap">
<div class="icon"><span class="ion-ios-arrow-down"></span></div>
<select name="services" id="services" required="true" class="form-control">
<option value="">Select Services</option>
<?php $query=mysqli_query($con,"select * from tblservices");
while($row=mysqli_fetch_array($query))
{
?>
<option value="<?php echo $row['ServiceName'];?>"><?php echo
$row['ServiceName'];?></option>

<?php } ?>
</select>
</div>
</div>
</div>
<input type="text" class="form-control appointment_date"
placeholder="Date" name="adate" id='adate' required="true">
</div>
</div>
<input type="text" class="form-control appointment_time"
placeholder="Time" name="atime" id='atime' required="true">
</div>
</div>
<input type="text" class="form-control" id="phone" name="phone"
placeholder="Phone" required="true" maxlength="10" pattern="[0-9]+">
</div>
</div>
</div>
<input type="submit" name="submit" value="Make an Appointment"
class="btn btn-primary">
</div>
</form>
</div>
</div>
</div>
<div class="one-third">
<div class="img" style="background-image: url(images/bg-
1.jpg);">
</div>
</div>
</div>
</div>
</section>
<br>

<?php include_once('includes/footer.php');?>


<div id="ftco-loader" class="show fullscreen"><svg class="circular" width="48px"
height="48px"><circle class="path-bg" cx="24" cy="24" r="22" fill="none" stroke-width="4"
stroke="#eeeeee"/><circle class="path" cx="24" cy="24" r="22" fill="none" stroke-width="4" stroke-
miterlimit="10" stroke="#F96D00"/></svg></div>
<script src="js/jquery.min.js"></script>
<script src="js/jquery-migrate-3.0.1.min.js"></script>
<script src="js/popper.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/jquery.easing.1.3.js"></script>
<script src="js/jquery.waypoints.min.js"></script>
<script src="js/jquery.stellar.min.js"></script>
<script src="js/owl.carousel.min.js"></script>
<script src="js/jquery.magnific-popup.min.js"></script>
<script src="js/aos.js"></script>
<script src="js/jquery.animateNumber.min.js"></script>
<script src="js/bootstrap-datepicker.js"></script>
<script src="js/jquery.timepicker.min.js"></script>
<script src="js/scrollax.min.js"></script>
<script
src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBVWaKrjvy3MaE7SQ74_uJiULgl1JY0H2s&
sensor=false"></script>
<script src="js/google-map.js"></script>
<script src="js/main.js"></script>
</body>
</html>
CODE FOR ADMIN_LOGIN

<?php
session_start();
error_reporting(0);
if (strlen($_SESSION['bpmsaid']==0)) {
header('location:logout.php');
} else{

if(isset($_POST['submit']))
{
$adminid=$_SESSION['bpmsaid'];
$aname=$_POST['adminname'];
$mobno=$_POST['contactnumber'];
$query=mysqli_query($con, "update tbladmin set AdminName ='$aname', MobileNumber='$mobno'

where ID='$adminid'");
if ($query) {
$msg="Admin profile has been updated.";
}
else
{
$msg="Something Went Wrong. Please try again.";
}
}
?>
<!DOCTYPE HTML>
<html>
<head>
<title>BPMS | Admin Profile</title>
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar,

0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>

<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />

<link href="css/style.css" rel='stylesheet' type='text/css' />


<link href="css/font-awesome.css" rel="stylesheet">



<script src="js/jquery-1.11.1.min.js"></script>
<script src="js/modernizr.custom.js"></script>

<link
href='//fonts.googleapis.com/css?family=Roboto+Condensed:400,300,300italic,400italic,700,700italic'
rel='stylesheet' type='text/css'>


<link href="css/animate.css" rel="stylesheet" type="text/css" media="all">
<script src="js/wow.min.js"></script>
<script>
new WOW().init();
</script>


<script src="js/metisMenu.min.js"></script>
<script src="js/custom.js"></script>
<link href="css/custom.css" rel="stylesheet">

</head>
<body class="cbp-spmenu-push">
<div class="main-content">

<?php include_once('includes/sidebar.php');?>



<div id="page-wrapper">
<div class="main-page">
<div class="forms">
<h3 class="title1">Admin Profile</h3>

<div class="form-grids row widget-shadow" data-example-id="basic-forms">

<div class="form-title">
<h4>Update Profile :</h4>
</div>
<div class="form-body">
<form method="post">
<p style="font-size:16px; color:red" align="center">
<?php if($msg){
echo $msg;
} ?> </p>
<?php
$adminid=$_SESSION['bpmsaid'];
$ret=mysqli_query($con,"select * from tbladmin where ID='$adminid'");
$cnt=1;
while ($row=mysqli_fetch_array($ret)) {
?>
<div class="form-group"> <label
for="exampleInputEmail1">Admin Name</label> <input type="text" class="form-control"
id="adminname" name="adminname" placeholder="Admin Name" value="<?php echo
$row['AdminName'];?>"> </div> <div class="form-group"> <label for="exampleInputPassword1">User
Name</label> <input type="text" id="username" name="username" class="form-control" value="<?php
echo $row['UserName'];?>" readonly="true"> </div>
for="exampleInputPassword1">Contact Number</label> <input type="text" id="contactnumber"
name="contactnumber" class="form-control" value="<?php echo $row['MobileNumber'];?>"> </div>
for="exampleInputPassword1">Email address</label> <input type="email" id="email" name="email"
class="form-control" value="<?php echo $row['Email'];?>" readonly='true'> </div>
<button type="submit" name="submit" class="btn btn-
default">Update</button> </form>
</div>
<?php } ?>
</div>

</div>
</div>
</div>

<script src="js/classie.js"></script>
<script>
var menuLeft = document.getElementById( 'cbp-spmenu-s1' ),
showLeftPush = document.getElementById( 'showLeftPush' ),
body = document.body;
showLeftPush.onclick = function() {
classie.toggle( this, 'active' );
classie.toggle( body, 'cbp-spmenu-push-toright' );
classie.toggle( menuLeft, 'cbp-spmenu-open' );
disableOther( 'showLeftPush' );
};
function disableOther( button ) {

if( button !== 'showLeftPush' ) {
classie.toggle( showLeftPush, 'disabled' );
}
}
</script>

<script src="js/jquery.nicescroll.js"></script>
<script src="js/scripts.js"></script>


<script src="js/bootstrap.js"> </script>
</body>
</html>
<?php } ?>
CODE FOR MANAGE SERVICES

<?php
session_start();
error_reporting(0);
if (strlen($_SESSION['bpmsaid']==0)) {
header('location:logout.php');
} else{
?>
<!DOCTYPE HTML>
<html>
<head>
<title>BPMS || Manage Services</title>
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar,

0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>

<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />

<link href="css/style.css" rel='stylesheet' type='text/css' />


<link href="css/font-awesome.css" rel="stylesheet">


<script src="js/jquery-1.11.1.min.js"></script>
<script src="js/modernizr.custom.js"></script>


<link
href='//fonts.googleapis.com/css?family=Roboto+Condensed:400,300,300italic,400italic,700,700italic'
rel='stylesheet' type='text/css'>


<link href="css/animate.css" rel="stylesheet" type="text/css" media="all">
<script src="js/wow.min.js"></script>
<script>
new WOW().init();
</script>


<script src="js/metisMenu.min.js"></script>
<script src="js/custom.js"></script>
<link href="css/custom.css" rel="stylesheet">

</head>
<body class="cbp-spmenu-push">
<div class="main-content">
<?php include_once('includes/sidebar.php');?>



<div id="page-wrapper">
<div class="main-page">
<div class="tables">
<h3 class="title1">Manage Services</h3>

<div class="table-responsive bs-example widget-shadow">

<h4>Update Services:</h4>
<table class="table table-bordered"> <thead> <tr> <th>#</th>
<th>Service Name</th> <th>Service Price</th> <th>Creation Date</th><th>Action</th> </tr> </thead>
<tbody>
<?php
$ret=mysqli_query($con,"select *from tblservices");
$cnt=1;
while ($row=mysqli_fetch_array($ret)) {
?>
<tr> <th scope="row"><?php echo $cnt;?></th> <td><?php echo

$row['ServiceName'];?></td> <td><?php echo $row['Cost'];?></td><td><?php echo
$row['CreationDate'];?></td> <td><a href="edit-services.php?editid=<?php echo
$row['ID'];?>">Edit</a></td> </tr> <?php
$cnt=$cnt+1;
}?></tbody> </table>
</div>
</div>
</div>
</div>


</div>

<script src="js/classie.js"></script>
<script>
var menuLeft = document.getElementById( 'cbp-spmenu-s1' ),
showLeftPush = document.getElementById( 'showLeftPush' ),
body = document.body;
showLeftPush.onclick = function() {

classie.toggle( this, 'active' );

classie.toggle( body, 'cbp-spmenu-push-toright' );
classie.toggle( menuLeft, 'cbp-spmenu-open' );
disableOther( 'showLeftPush' );
};
function disableOther( button ) {

if( button !== 'showLeftPush' ) {
classie.toggle( showLeftPush, 'disabled' );
}
}
</script>

<script src="js/jquery.nicescroll.js"></script>
<script src="js/scripts.js"></script>


<script src="js/bootstrap.js"> </script>
</body>
</html>
<?php } ?>
CODE FOR LOGOUT.PHP
<?php
session_start();
session_unset();
session_destroy();
header('location:index.php');
?>

CHAPTER 6
TESTING
1.TESTING PROCESS
Testing is an integral part of software development. Testing process certifies whether the
product that is developed compiles with the standards that it was designed to. Testing
process involves building of test cases against which the product has to be tested.
2. TESTING OBJECTIVES
The main objectives of testing process are as follows.

• Testing is a process of executing a program with the intent of finding an
error.
• A good test case is one that has high probability of finding undiscovered
error.
• A successful test is one that uncovers the undiscovered error.
6.1 TEST CASES
The test cases provided here test the most important features of the project.

6.1.1 Test cases for the project
Table 6.1 ------- Test Case
CHAPTER 7
RESULTS
This section describes the screens of the “Beauty Parlour Management System”.
The snapshots are shown below for each module.
7.1 SNAPSHOTS
Index page of the front end which displays option to login into the account.
Fig 7.1: Index page
User can take appointment with beauty parlour on particular date and time

Home page

In this section admin can see all the details in brief like total no. of appointments, customer, accepted,
rejected appointment, accepted appointment
Fig 7.2: Operation page
In this section admin can manage customer (add)
Fig 7.3: Insert page

In this section admin can view customer list and assign service
Fig 7.4: Output of insert
In this section admin can search appointment with the help of his/her appointment number, name and
contact number
Fig 7.5: Search page

In this the admin can update his/her profile page
Fig 7.6: Admin page
In this section admin can manage services of parlour (update)

Fig 7.7: Updating details
Here it will display all the services
Fig 7.8: Stored procedure

CHAPTER 8
CONCLUSION
By using “Beauty Parlour Management System”, there is the need for efficient
management of a network-based system for handling customer orders.
This project is an endeavor to provide a solution to this. The proposed system

enables an administrator to keep track of customer orders and maintaining records of the
customers. He can view the submitted requirements made by the customer. He can also
view the reports generated by him and can also sent approvals or rejections instantly.

CHAPTER 9
REFERENCES
For PHP
https://www.w3schools.com/php/default.asp
https://www.sitepoint.com/php/
https://www.php.net/
For MySQL
https://www.mysql.com/
http://www.mysqltutorial.org/
For XAMPP

https://www.apachefriends.org/download.html

BEAUTY PARLOUR - REPORT .New

Uploaded by

Copyright:

Available Formats

BEAUTY PARLOUR - REPORT .New

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

BEAUTY PARLOUR - REPORT .New

Uploaded by

Copyright:

Available Formats

BEAUTY PARLOUR MANAGEMENT SYSTEM 2021-22

VISVESVARAYA TECHNOLOGICAL UNIVERSITY

“Jnana Sangama”, Belagavi-590 018

AMISHA SARIKA GOWDA (1GA19CS011)

Under the Guidance of

Department of Computer Science and Engineering

GLOBAL ACADEMY OF TECHNOLOGY

Dept. of CSE, GAT 1

GLOBAL ACADEMY OF TECHNOLOGY

----------------------- ---------------------------- ------------------------

Dept. of CSE, GAT 2

With tremendous increase in technology, information technology is a fast developing

Beauty Parlour Management System is essentially a web-based application that's inbuilt

Dept. of CSE, GAT 3

The satisfaction and euphoria that accompany the successful completion of

I consider myself proud, to be part of Global Academy of Technology family,

I express my deep and sincere thanks to our Principal Dr. N. Ranaprathap

I am grateful to Dr. Bhagyashri R Hanji, Professor and HOD, Dept of CSE

I wish to thank my internal guide Dr. Pramila B Professor Mrs. Shruthi P

AMISHA SARIKA GOWDA

Dept. of CSE, GAT 4

3. OBJECTIVE OF THE PROJECT

4.2 MAPPING OF ER DIAGRAMSCHEMA DIAGRAM

4.3 MAPPING OF THE ER SCHEMA TO RELATIONS

4.4 CREATION OF TABLES

4.5 INSERTION OF TUPLES

4.6 CREATION OF TRIGGERS

4.7 CREATION OF STORED PROCEDURES

5. FRONT END DESIGN

Dept. of CSE, GAT 5

Dept. of CSE, GAT 6

4.1 ER diagram of Beauty Parlor Management System

4.2 Mapping of ER diagram to Schema diagram

4.2 Schema diagram of Beauty Parlor Management System

FIGURE NO. TITLE PAGE NO.

Snapshot 1 Index Page 42

Snapshot 2 Operation Page 43

Snapshot 3 Insert Page 43

Snapshot 4 Output of insert 44

Snapshot 5 Search Page 44

Snapshot 6 Update Page 45

Snapshot 7 Updating Details 45

Snapshot 8 Stored Procedure 46

Dept. of CSE, GAT 8

1.1 INTRODUCTION TO SQL

A database is a separate application that stores a collection of data. Each database

1.2 INTRODUCTION TO FRONT END SOFTWARE

Dept. of CSE, GAT 9

PHP is a recursive acronym for "PHP: Hypertext Preprocessor".PHP is a server-

1.3 PROJECT REPORT OUTLINE

Dept. of CSE, GAT 10

The report is arranged in the following way:

Chapter 2: Problem Statement

Chapter 3: Requirement Specification

Chapter 4: System Design and Implementation

Chapter 5: Front end design

Dept. of CSE, GAT 11

2.1 SOFTWARE REQUIREMENTS

Operating System : 64bit operating system, Windows 10