VISVESVARAYA TECHNOLOGICAL UNIVERSITY

JNANA SANGAMA, BELAGAVI – 590 018, KARNATAKA

DBMS LABORATORY WITH MINI PROJECT REPORT ON

“MEN’S SALON MANAGEMENT SYSTEM”

Submitted By

PUSHPITHA.G
USN:1VK21CS059

Submitted in the partial fulfilment of the requirements for the fifth Semester Database Management Lab
(21CSL55)

BACHELOR OF
ENGINEERING IN
COMPUTER SCIENCE AND ENGINEERING

UNDER THE GUIDANCE OF

Soniya L
Asst Professor department of CSE VKIT,
Bengaluru

Janatha Education Society®

VIVEKANANDA INSTITUTE OF TECHNOLOGY

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING GUDIMAVU, KUMBALAGODU
POST, KENGERI HOBLI, BENGALURU –560 074
2023-2024
 Janatha Education Society®
VIVEKANANDA INSTITUTE OF TECHNOLOGY
Gudimavu, Kumbalagodu Post, Kengeri Hobli, Bengaluru – 560 074

Department of Computer Science and Engineering

CERTIFICATE
This is to certify that the Mini project work entitled “Men’s salon Management System”
carried out by PUSHPITHA.G bearing the USN: 1VK21CS059 is a bonafide student of
Vivekananda Institute of Technology, Bengaluru in partial fulfillment of the requirements
for the fifth semester DBMS LABORATORY WITH MINI PROJECT(21CSL55) of
Bachelor of Engineering in Computer Science and Engineering of the Visvesvaraya
Technological University, Belagavi during the year 2023-24. It is certified that all
corrections/suggestions indicated for internal assessment have been incorporated in the report
deposited in the departmental library. The mini project report has been approved as it satisfies
the academic requirements in respect of Project work prescribed for the said degree.

Signature of the Guide Signature of the HOD Signature of the Principal

Soniya L Dr. Vidya A Dr. K M Ravi Kumar
Asst. Professor Prof. & Head Principal
Department of CSE Department of CSE VKIT, Bengaluru
VKIT, Bengaluru VKIT, Bengaluru

External Viva-Voce
Name of the Examiners Signature with date

1.

2.
 ACKNOWLEDGEMENT

It gives us immense pleasure to write an acknowledgement to this mini project, a contribution of all
people who helped me realize it. We are very thankful to our Principal, Dr. K M Ravi Kumar,
VKIT, Bengaluru, for being kind enough to provide us an opportunity to work on a project in this
institution. We would like to convey our heartfelt thanks to our beloved HOD, Dr. Vidya A,
Department of Computer Science and Engineering, VKIT, Bengaluru for giving us the
opportunity to embark up to this topic. We would like to sincerely thank our project guide Soniya L
Asst. Professor, Dept. of Computer Science and Engineering for their valuable guidance,
constant assistance, support and constructive suggestions for the betterment of the project, without
which this project would have not been possible.

Finally, it is a pleasure and happiness to the friendly co-operation showed by all the staffs of
Computer Science and Engineering Department, VKIT

PUSHPITHA.G (1VK21CS059)

i
 ABSTRACT

THE “MEN’S SALON MANAGEMENT” that allows users to check the advanced technology

equipments and provide best quality services . The users will get well trained and experienced

offering advanced services in skin ,hair and body shaping that provide users a luxurious experience

that users feel relaxed and stress free. 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. The user may select

different services as per categories. If the user likes any of the service , he may book an appointment .

Once the user book the appointment the user can subscribe so that the admin can add another

customer . Here we use CSS and for framework to make the entire frontend. The middle tier or code

behind model is designed in HTML. And SQL serves as a backend to store different service lists data,

Thus the men’s saloon project brings a different types of facials and fashion hair colouring and

provide best service to users .

ii
 TABLE OF CONTENTS

Acknowledgement i
Abstract ii
Table of contents iii
List of Snapshots iv
List of Tables v
List of Figures vi
List Of Abbreviation vii

1. Introduction 1
1.1 Project Overview 1
1.2 Project Objectives 1
1.3 Existing System 2
1.4 Proposed System 3
1.5 Advantages 3

2. Hardware and Software requirements

2.1 Feasibility studies 4
2.1.1 Economical Feasibility 4
2.1.2 Technical Feasibility 4
2.1.3 Operational Feasibility 4
2.2 Software Requirements Specifications 5
2.1 Software Interface 5
2.2 Hardware interface 5
2.3 The proposed system has the following requirements 5
2.4 About Technologies Used 6

3. System Design 8
3.1 Input design 8
3.2 Er diagram of flower bouquet system 8

iii
 3.3 Schema diagram of flower bouquet system 9

4. Database Technique 10
3.4 Database Management System 10

3.4.1 The CREATE TABLE Command in SQL 10

3.4.2 The INSERT Command 10

3.4.3 The DELETE Command 11

3.4.4 The UPDATE Command 11

3.4.5 Unspecified WHERE Clause and Use of Asterisk 11

3.5 Trigger 11

3.6 Stored procedures 12

3.7 Normalization 12
3.7.1 First normal form 12

3.7.2 Second normal form 13

3.7.3 Third normal form 13

3.7.4 Fourth normal form 13

3.7.5 Fifth normal form 13

3.8 Testing 14
3.8.1 Unit testing 14

3.8.2 User acceptance testing 14

3.8.3 GUI testing 15

3.8.4 Validation testing 16

3.8.5 Output testing 16

5. SNAPSHOT AND RESULTS 17

6. CONCLUSION 20

7. BIBLIOGRAPHY 21

iii
 LIST OF
SNAPSHOTS

5.1 Login Page 18

5.2 Home Page 18

5.3 Service List Page 19

5.4 Appointment Form 19

5.5 Booking an Appointment 19

5.6 Adding The Service 19

5.7 Service Added 20

5.8 Add The Customer 20

5.9 Customer List 20

iv
 LIST OF
FIGURES
Fig 3.1 ER diagram of flower bouquet system 08

Fig 3.2 Schema diagram of flower bouquet system 09

v
 LIST OF
TABLES
4.1 User Acceptant Test Table 16

vi
 LIST OF
ABBREVATIONS
1. HTML: Hypertext Markup Language

2. CSS : Cascading Style Sheet

3. JS : Java Script

4. PHP : Hypertext Preprocessor

5. 1NF : First Normal Form

6. 2NF : Second Normal Form

7. 3NF : Third Normal Form

vii
Chapter 1

INTRODUCTION
A Database Management System (DBMS) refers to the technology for creating and managing databases.
Basically, DBMS is a software tool to organize (create, retrieve, update and manage) data in a database.
The main aim of a DBMS is to supply a way to store up and retrieve database information that is both
convenient and efficient. By data, we mean known facts that can be recorded and that have embedded
meaning. Normally people use software such as DBASE IV or V, Microsoft ACCESS, or EXCEL to store
data in the form of database. Database system is meant to handle large collection of information. Management
of data involves both defining structures for information and providing mechanisms that can do the
manipulation of those stored information. Moreover, the database system must ensure the safety of the
information stored, despite system crashes or attempts at unauthorized access.

1.1 PROJECT OVERVIEW

The main focus is on quality and hygiene. The men’s salon 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 specialaities in the salon are, apart from regular bleachings and Facials,
many types of hairstyles, Bridal and cine make-up and different types of Facials & fashion hair colourings.

1.2 PROJECT OBJECTIVES

Item Module:

The item module is helps to manage overall item details. Here we can insert the new item, delete the existing
item, modify the item, and view.

Company Module:

The item module is helps to manage overall company details. Like company name, company address, contact.

Dept. of CSE, 2023-2024 Page 1

VKIT
CHAPTER-1 MEN,S SALON MANAGEMENT SYSTEM

Sales module:

The sales module is used to manage sales items. Sales date, sales item, customer name and so on. This module
is also used to collect information about sales that in the electronic products purchased by the customer. This
input saved in the database. It’s called sales module.

Purchase module:

This is used to manage purchase detail information like name of the item and company name, supplier id,
product cost, date and so an.

Complaint module:

This module is used to store the complaint details. Here this system can store complaint description,
complaint name, product id and so an. This module is also helps to resolve the complaints or problems.

1.3 EXISTING SYSTEM

The existing system maintained the data manually. The data maintenance adopted by the system is not
systematic. The personal details about the customers, the transactions made with the customer in various
places, Bill of material details, Receipt details, Stock, Packing, each of these are maintained manually in a
separate register. Maintaining data becomes difficult, when the details are maintained in the form of hard
copy.

Disadvantages:

• Highly Expensive.

• Storing data and retrieval becomes very difficult.

• It is not computerized and hence not systematic.

• Lack of database security.

• Same data are stored in more than one location.

• Access speed is less for searching and modifying data.

Dept. of CSE, 2023-2024 Page 2

VKIT
 CHAPTER-1 MEN,S SALON MANAGEMENT SYSTEM

• products, offers, change in prices.

1.4 PURPOSE SYSTEM

Objective is to overcome the major limitation of the existing enabling effective management of the customer
details thereby improving the performance. With improved computerization being involved in the maintenance of
customer details, error and inconsistencies can be kept at par. Easy retrieval of data will be made possible by
finding techniques. Validation of data will ensure only accurate, valid and complete data is stored in the database.
Proper monitoring of the processes from customer registration to activation. Report generation will help make it
easy to analyze the performance at the Bank. This will be much less time-consuming comparing to existing
system.

Advantage of Proposed System

➢With improved computerization being involved in the maintenance of user's appointment, customer details.
Error and inconsistencies can be kept at per.
➢Validation of data will be ensure only accurate valid and complete data stored in the database.

➢Easy retrieval or data will be made possible by finding techniques.

➢Report generation will help made it easy to analyze the performance or clinic Administration.

Dept. of CSE, 2023-2024 Page 3

VKIT
 Chapter 2

Hardware and Software requirements

2.1 Feasibility Study:

A feasibility study is undertaken to determine to the possibility or probability of either improving the existing
system or developing a completely new system. It helps to obtain the overview of the problem and to get a rough
assessment of whether other feasible solution exists.

2.1.1 Economical Feasibility

Economic analysis is most frequently used for evaluation of the effectiveness of the system. More commonly
known as cost/benefit analysis the procedure is to determine the benefit and saving that are expected from a system
and compare them with costs, decisions is made to design and Implement the system. This part of feasibility study
gives the top management the economic justification for the new system. This is an important input tothe
management the management, because very often the top management does not like to get confounded by the
various technicalities that bound to be associated with a project of this kind. A simple economic analysis that gives
the actual comparison of costs and benefits is much more meaningful in such cases.

2.1.2 Technical Feasibility

Technical feasibility centers on the existing manual system of the test management process and to what extent it
can support the system. According to feasibility analysis procedure the technical feasibility of the system is
analyzed and the technical requirements such as software facilities, procedure, inputs are identified. It is also one
of the important phases of the system development activities. The system offers greater levels of user friendliness
combined with greater processing speed. Therefore, the cost of maintenance can be reduced. Since, processing
speed is very high and the work is reduced in the maintenance point of view management convince that the project
is operationally feasible.

2.1.3 Operational Feasibility

No doubt the proposed system is fully GUI based that is very user friendly and all inputs to be taken all self-

explanatory even to a layman. Besides, a proper training has been conducted to concerned the clients are

comfortable and happy as the system has cut down their loads and doing.

Dept. of CSE, 2023-2024 Page 4

VKIT
CHAPTER-2 MEN’S SALON MANAGEMENT SYSTEM

2.2 Software Requirement Specification

The Software Requirements Specification is produced at the culmination of the analysis task. The function
and performance allocated to software as part of system engineering are refined by establishing a complete
information description, a detailed functional and behavioral description, an indication of performance.

2.1 Software Interfaces

1. Visual Studio 2021

2. OS: Windows Vista/7/8/10/11
3. DB Server: Xampp
4. Front End Language: HTML, CSS, JS
5. Back End Language: MYSQL
6. Host Language: PHP

2.2 Hardware interfaces

1. Intel core i3 processor with minimum 2GHZ speed.

2. RAM: Minimum 4GB
3. Hard Disk: Minimum 1TB

2.2.1 The proposed system has the following requirements:

• Easy retrieval of data will be made possible by finding techniques.

• Validation of data will ensure only accurate, valid and complete data is stored in the database.
• Proper monitoring of the processes from customer registration to activation.
• Report generation will help make it easy to analyze the performance at the Bank.
• This will be much less time-consuming comparing to existing system
.
2.3 About technologies Used

 MYSQL
MYSQL is language used to manipulate relational databases. It is tied closely with relational model. It is
issued for the purpose of data definition and data manipulation. Program runs as server providing multi-user
access to number of databases. MySQL is a multithreaded, multi-user SQL database management system
(DBMS). It includes facilities to add, modify or delete data from the database, ask questions (or queries)

Dept. of CSE, 2023-2024 Page 5

VKIT
CHAPTER-2 MEN’S SALON MANAGEMENT SYSTEM

about the data stored in database and produce reports summarizing selected contents.

 PHP

Hypertext Preprocessor (or simply PHP) is a server-side scripting language designed for Web development,
but also used as a general-purpose programming language. It was originally created by Rasmus Lerdorf in
1994,] the PHP reference implementation is now produced by The PHP Group. PHP originally stood for
Personal Home Page,] but it now stands for the Recursive acronym PHP: Hypertext Preprocessor PHP code
may be embedded into HTML code, or it can be used in combination with various web template systems, web
content management systems, and web frameworks. PHP code is usually processed by a PHP interpreter
implemented as a module in the web server or as a Common Gateway Interface (CGI) executable. The web
server combines the results of the interpreted and executed PHP code, which may be any type of data,
including images, with the generated web page. PHP code may also be executed with a command-line
interface (CLI) and can be used to implement standalone graphical applications.

 Xampp

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 programming languages. XAMPP stands for Cross-Platform (X), Apache (A),
MariaDB (M), PHP (P) and Perl (P). It is a simple, lightweight Apache distribution that makes it extremely
easy for developers to create a local web server for testing and deployment purposes. Everything needed to set
up a web server – server application (Apache), database (MariaDB), and scripting language (PHP) – is
included in an extractable file. XAMPP is also cross-platform, which means it works equally well on.

 HTML

Hypertext Markup Language (HTML) is the standard markup language for creating web pages and web
applications. With Cascading Style Sheets (CSS) and JavaScript, it forms a triad of cornerstone technologies
for the Web browsers receive HTML documents from a server or from local storage and render the
documents into multimedia web pages. HTML describes the structure of a web page semantically and
originally included cues for the appearance of the document.HTML elements are the building blocks of
HTML pages. With HTML constructs, images and other objects such as interactive forms may be embedded
into the rendered page.

Dept. of CSE, 2023-2024 Page 6

VKIT
Chapter 3

System Design

In this phase initially ER Diagram has been designed in order to identify various entities and relationship set,
entity set, attributes.

After this step database for the new system has been designed and normalized it.

3.1 INPUT DESIGN

• The login page has username and password for user login.

• In this section admin can see all detail in brief like total number of customers, Total number of
appointments, Rejected Appointment, Accepted Appointment, Total Services, Today's sales, yesterday's
sale, Last seven days sales and total sales.

3.2 ER DIAGRAM

An entity–relationship model (ER model) describes inter-related things of interest in a specific domain of
knowledge. An ER model is composed of entity types (which classify the things of interest) and specifies
relationships that can exist between instances of those entity types. In software engineering an ER model is
commonly formed to represent things that a business needs to remember in order to perform business
processes. Consequently, the ER model becomes an abstract data model that defines a data or information
structure that can be implemented in a database, typically a relational database.

An entity–relationship model is usually the result of systematic analysis to define and describe what is
important to processes in an area of a business. An E-R model does not define the business processes; it only
presents a business data schema in graphical form. It is usually drawn in a graphical form as boxes (entities)
that are connected by lines (relationships) which express the associations and dependencies between entities.
An ER model can also be expressed in a verbal form, for example: one building may be divided into zero or
more apartments, but one apartment can only be located in one building. Entities may be characterized not
only by relationships, but also by additional properties (attributes), which include identifiers called "primary
keys".

Diagrams created to represent attributes as well as entities and relationships may be called entity attribute-
relationship diagrams, rather than entity-relationship models. An ER model is typically implemented as a
database. In a simple relational database implementation, each row of a table represents one instance of an
Dept. of CSE, 2023-2024 Page 7
VKIT
CHAPTER-3 MEN’S SALON MANAGEMENT SYSTEM

entity. There is a tradition for ER/data models to be built at two or three levels of abstraction. Note that the
conceptual-logical-physical hierarchy below is used in other kinds of specification, and is different from the
three-schema approach to software engineering.

When designing a database schema, the choice of names for entity types, attributes, relationship types, and
(particularly) roles is not always straightforward. One should choose names that convey, as much as possible,
the meanings attached to the different constructs in the schema. We choose to use singular names for entity
types, rather than plural ones, because the entity type name applies to each individual entity belonging to that
entity type. In our ER diagrams, we will use the convention that entity type and relationship type names are in
uppercase letters, attribute names have their initial letter capitalized, and role names are in lowercase letters.

ENTITY RELATIONSHIP DIAGRAM

DIAGRAM OF MEN’S SALON MANAGEMENT SYSTEM

Dept. of CSE, 2023-2024 Page 8

VKIT
CHAPTER-3 MEN’S SALON MANAGEMENT SYSTEM

3.3 SCHEMA:

A schema diagram is a diagram which contains entities and the attributes that will define that schema. A
schema diagram only shows us the database design. It does not show the actual data of the database. Schema
can be a single table or it can have more than one table which is related. The schema represents the
relationship between these tables. The term "schema" refers to the organization of data as a blueprint of how
the database is constructed (divided into database tables in the case of relational databases). The formal
definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a
database. A relational schema shows references among fields in the database. When a primary key is
referenced table in the database, it is called a foreign key. This is denoted by an arrow with the head pointing at the
referenced key attribute.

Dept. of CSE, 2023-2024 Page 9

VKIT
Chapter 4

DATABASE TECHNIQUES

4.1 DATABASE MANAGEMENT SYSTEM

A database-management-system is a computer-software application that interacts with end- users, other

applications, and the database itself to capture and analyses data. A general- purpose DBMS allows the
definition, creation, querying, update and administration of databases.

4.1.1 The CREATE TABLE Command in SQL

• The CREATE TABLE command is used to specify a new relation by giving it a name and specifying
its attributes and initial constraints.
• The attributes are specified first, and each attribute is given a name, a data type to specify its domain
of values, and any attribute constraints, such as NOTNULL.
• The key, entity integrity, and referential integrity constraints can be specified within the CREATE
TABLE statement after the attributes are declared, or they can be added later using the ALTER
TABLE command.
• The schema name can be explicitly attached to the relation’s name, separated by a period.
• Syntax: create table <table name> (<attribute1><type1>, <attribute2><type2>);

4.1.2 The INSERT Command

• INSERT is used to add a single tuple to a relation. The relation’s name and a list of values are
specified for the tuple.
• The values should be listed in the same order in which the corresponding attributes were specified in
the CREATE TABLE command.
• A second form of the INSERT statement allows the user to specify explicit attribute names that
correspond to the values provided in the INSERT Command. This is useful if a relation has many
attributes but only a few these attributes are assigned values in the new tuple.
• Syntax: 1. insert into <table name> values(‘value1’,’value2’);

2.insert into <table name> (<attribute1>, <attribute2>) values (‘value1’,’value2’);

Dept. of CSE, 2023-2024 Page 10

VKIT
CHAPTER-4 MEN’S SALON MANAGEMENT SYSTEM

4.1.3 The DELETE Command

 The DELETE command removes tuples from a relation.

 It includes a WHERE clause, to select the tuples to be deleted.
 Tuples are explicitly deleted from only one table at a time
 A missing WHERE clause specifies that all tuples in the relation are to be deleted but the table remains
in the database as an empty table.
 Syntax: delete from <table name> where<condition>;

4.1.4 The UPDATE Command

 The UPDATE command is used to modify attribute values of one or more selected tuples.
 A WHERE clause in the UPDATE command selects the tuples to be modified from a single relation.
 A SET clause in the UPDATE command specifies the attributes to be modified and their new values.
 Syntax: update <table name> set <attribute>=<new value> where<attribute>=<value>;

4.1.5 Unspecified WHERE Clause and Use of the Asterisk

 A missing WHERE clause indicates no condition on tuple selection. All tuples of the relation specified
in the FROM clause qualify and are selected for the query result.
 If more than one relation is specified in the FROM clause and there is no WHERE clause, then the
CROSS PRODUCT-all possible tuple combinations-of these relations is selected.
 To retrieve all the attribute values of the selected tuples, an asterisk (*) can be specified, which stands
for all the attributes.

4.2 TRIGGER

Another important statement in SQL is CREATE TRIGGER. Trigger has three components:

i. The event(s): These are usually database update operations that are explicitly applied to the database. In
this example the events are: inserting a new employee record, changing an employee’s salary, or changing an
employee’s supervisor.
ii. The condition that determines whether the rule action should be executed: Once the triggering event has
occurred, an optional condition may be evaluated. If no condition is specified, the action will be executed
once the event occurs

Dept. of CSE, 2023-2024 Page 11

VKIT
CHAPTER-4 MEN’S SALON MANAGEMENT SYSTEM

iii. The action: The action is usually a sequence of SQL statements, but it could also be a database
transaction or an external program that will be automatically executed.

4.3 STORED PROCEDURES

 A stored procedure is a program that is executed through a single SQL statement that can be locally
executed and completed within the process space of the database server.
 The results can be packaged into one big result and returned to the application, or the application logic
can be performed directly at the server, without having to transmit the results to the client.
 Stored procedures are also beneficial for software engineering because once a stored procedure is
registered with the database server, different users can re-use the stored procedure, eliminating
duplication of efforts in writing SQL queries or application logic, and making code maintenance easy.

4.4 NORMALIZATION

Database normalization, or simply normalization, is the process of organizing the columns (attributes) and
tables (relations) of a relational database to reduce data redundancy and improve data integrity. Normalization
is also the process of simplifying the design of a database so that it achieves the optimal structure composed
of atomic elements.

Normalization involves arranging attributes in relations based on dependencies between attributes, ensuring
that the dependencies are properly enforced by database integrity constraints Normalization is accomplished
by applying some formal rules either by a process of synthesis or decomposition. Synthesis creates a
normalized database design based on a known set of dependencies. Decomposition takes an existing
(insufficiently normalized) database design and improves it based on the known set of dependencies.

4.4.1 FIRST NORMALFORM

First normal form is an essential property of a relation in a relational database. Database normalization is the
process of representing a database in terms of relations in standard normal forms, where first normal is a
minimal requirement.

First normal form enforces these criteria:

 Eliminate repeating groups in individual tables.

Dept. of CSE, 2023-2024 Page 12

VKIT
CHAPTER-4 MEN’S SALON MANAGEMENT SYSTEM

 Create a separate table for each set of related data.

 Identify each set of related data with primary key.
4.4.2 SECOND NORMALFORM

A relation that is in first normal form (1NF) must meet additional criteria if it is to qualify for second normal
form. Specifically: a relation is in 2NF if it is in 1NF and no non-prime attribute is dependent on any proper
subset of any candidate key of the relation. A non-prime attribute of a relation is an attribute that is not a part
of any candidate key of the relation.

4.4.3 THIRD NORMALFORM

Third normal form is a normal form that is used in normalizing a database design to reduce the duplication
of data and ensure referential integrity by ensuring that (1) the entity is in second normal form, and (2) all
the attributes in a table are determined only by the candidate keys of that relation and not by any non-prime
attributes. 3NF was designed to improve database processing while minimizing storage costs. 3NF data
modelling was ideal for online transaction processing (OLTP) applications with heavy order entry type of
needs.

4.4.4 FOURTH NORMALFORM

Fourth normal form (4NF) is a normal form used in database normalization. Introduced by Ronald Fagin in
1977, 4NF is the next level of normalization after Boyce–Codd normal form (BCNF). Whereas the second,
third, and Boyce–Codd normal forms are concerned with functional dependencies, 4NF is concerned with a
more general type of dependency known as a multi valued dependency. A table is in 4NF if and only if, for
every one of its non-trivial multi valued dependencies X, Y, X is a super-key—that is, X is either a candidate
key or a superset.

4.4.5 FIFTH NORMALFORM

A database is said to be in 5th Normal Form, if and only if, it is in 4th Normal Form and if we decompose
the table further to eliminate redundancy and anomaly and when we re-join the decomposed tables by means
of candidate keys we should not be losing the original data or any new record set should not arise. In simple
words joining two or more decomposed tables should not lose records or create new records.

Dept. of CSE, 2023-2024 Page 13

VKIT
CHAPTER-4 MEN’S SALON MANAGEMENT SYSTEM

4.5 TESTING

The purpose of testing is to discover errors. Testing is the process of trying to discover every convincible fault
or weakness in a work product. It provides a way to check the functionality of components, sub- assemblies,
assemblies, and/or finished product. It is the process of exercising software with the intent of ensuring that the
software system meets its requirements and user expectations and does not fail in an unacceptable manner.

LEVELS OF TESTING:

4.5.1 UNIT TESTING:

Unit testing is a method by which individual units of source code, sets of one or more computer program
modules together with associated control data, usage procedures and operating procedures. For unit testing
first we adopted the code testing strategy, which examined the logic of program. During the development
process itself all the syntax errors get rooted out. For this developed test case that result in executing every
instruction in the program.

4.5.2 USER ACCEPTANCE TESTING:

User acceptance testing of the system is the key factor for the success of the system. A system under
consideration is tested for user acceptance by constantly keeping in touch with the prospective system at the
time of development and making change whenever required. This is done with regard to the input screen
design and output screen design.

Dept. of CSE, 2023-2024 Page 14

VKIT
CHAPTER-4 MEN’S SALON MANAGEMENT SYSTEM

Case Test Case Test Expected Actual Pass/Fail

id condition Output Output

1 Login Test Username Login Login Pass

Case &password successful successful
/
/ / /
Fail
Username Login Fail Login Fail
&password

2 Validation Insert Inserted Inserted Pass

Test Case Successfully Successfully
Delete Deleted Deleted Pass
Successfully Successfully
update Updated Updated Pass
Successfully Successfully
3 Phone_No Phone_No Must be Must be pass
Test case numeric numeric

Table 4.1:- User Acceptant Test Table

4.5.3 GUI Testing:

GUI testing is use to ensure the visual clarity of the system, flexibility of the system, user friendliness of the

system. The various components which are to be tested are:

 Relative layout
 Various Link and Buttons

Dept. of CSE, 2023-2024 Page 15

VKIT
CHAPTER-4 MEN’S SALON MANAGEMENT SYSTEM

4.5.4 VALIDATION TESTING:

At the culmination of black box testing, software is completely assembled is a package. Interfacing errors
have uncovered and the correct and final states of tests i.e. validation is defined with a simple definition that
validation succeeds when the software function in a manner that can be reasonably accepted by the customer.

4.5.5 OUTPUT TESTING:

After performing validation testing, the next step is output testing of the proposed system. Since the system
cannot be useful if it does not procedure the required output. Asking the user about the user about this
required format in which the system is required tests the output displayed or generated by the system under
consideration.

Dept. of CSE, 2023-2024 Page 16

VKIT
 Chapter 5

SNAPSHOTS AND RESULTS

5.1 : - Login Page

Description: Login page allows the user to login with their respective credential.

5.2 :- Home Page

Description: Home page of the website

Dept. of CSE, 2023-2024 Page 17

VKIT
5.3:- Service List page

Desripition :This page shows all service list avaible in website

5.4:- APPOINTMENT FORM

DESRIPITION : Here user can book an appointment

Dept. of CSE, 2023-2024 Page 18

VKIT
 CHAPTER-5 MEN’S SALON MANGEMENT SYSTEM

5.5:- Appointment Number

Description : Using the appointment number user can book an appointment

5.5:- Booking an appointment

Description: By using appointment number the user book appointment

5.6:-ADDING THE SERVICE

Descrpition: The user can add the service by customer wish

Dept. of CSE, 2023-2024 Page 19

VKIT
 CHPATER-5 MEN’S SALON MANAGEMENT SYSTEM

5.7:- Service Added

Description: This page shows the users add service as per customer choice

5.8:- ADD THE CUSTOMER

5.9:- Customer List

Description: The customer list added by user

Dept. of CSE, 2023-2024 Page 20

VKIT
Chapter 6

CONCLUSION

This application” MEN’S SALON MANAGEMENT SYSTEM” avoids the manual work and the problems
concern with it. It is an easy way to obtain the information regarding the various service hairstyle and variety
of products present in the markets. This system is an improved application better than the existing one’s
regarding the information about the various activities. Still, we found out that the project can be done in a
better way. Primarily, when we request information about particular details it shows all the relevant
information. This project is a computerized solution for storing the details of all related information in an
organization and also task assigned to an employee by an organization. Here, we can conclude that the
application been developed is to reduce manpower and various complexities.

Dept. of CSE, 2023-2024 Page 21

VKIT
 BIBLIOGRAPHY

1. Ramez Elmasri, Shamkant B.Navathe.” Fundamentals of Database System”,

Pearson Publication.
2. Silberschatz, Kortz, Sudarshan. “Database System Concepts”, Fourth Edition
3. V S Code Application.
4. https://githubb.com/
5. https://youtube.com/
6. https://phpgurukul.com/
7. /http://www.youtube/rezwhankhan/ueYu6c.
8. www.google.com.
9. http://www.yotube/codewithharry/RDWXWgZL4zx90&.

Dept. of CSE, VKIT 2023-2024 Page 22