The Bhopal School of Social Sciences
Project Report
On
Cosmetic Store Management System
SUBMITTED TO
DEPARTMENT OF COMPUTER APPLICATIONS
IN PARTIAL FULLFILLENT
OF
PGDCA-II SEM
SESSION – 2020-21
NAME: ALVEERA MAHWISH, PRIYANKA KUJUR, MELVIN XESS XALXO
Roll No:
Under the Guidance of
Ms.Swati Sharma
Assisant Proffessor
ACKNOWLEDGEMENT
We convey our sincere gratitude to Ms.Swati Sharma for giving us the
oppournity to prepare our project work in Cosmetic Shop
Management System. We express our sincere thanks to all the Staff
members of Computer Application Department.
We are Thankful to Ms.Swati Sharma for her guidance during our
project work and sparing her valuable time for the same.
We express our sincere obligation and thanks to the Principal and all
faculties of the Department of Computer Applications. The Bhopal
School of Social Sciences for providing us with guidance, help,
motivation and valuable advice at every stage for completing the
project work successfully.
Signature:
Name: AKANSHA YADAV & MADHU VISHWAKARMA
Roll No: 19101002 & 19101005
DECLARATION
We do hereby declare that the project work entitled “Cosmetic Shop
Management System “submitted by us for the partial fulfillment of
the requirement for the award PGDCA is an authentic work
completed by us.
The report being submitted has not been submitted earlier for the
award of any degree or diploma to any Institute or University.
Date
Name: AKANSHA YADAV & MADHU VISHWAKARMA
Roll No: 19101002 & 19101005
CERTIFICATE OF ORIGINALITY
This is to certify that the project report entitled “Cosmetic
Management System” Submitted to The Bhopal School of Social
Sciences, in partial fulfillment of the requirement for the award of the
degree of PGDCA is an original work carried out by
Name AKANSHA YADAV & MADHU VISHWAKARMA
Roll No: 19101002 & 19101005
The matter embodied in this project is a genuine work done by the
students and has not been submitted whether to this University or to
any other University / Institute for the fulfillment of the requirement
of any course of study.
Signature of the Guide
Ms. Swati Sharma
Assistant Professor
INTRODUCTION
A Cosmetic store is a web based application where users can view
various cosmetic products along with their description. The project
provides user with a flexible & attractive GUI & shows them a list of
products & carry out all the shopping activities online.
This project is developed for users to have a brief look at the
cosmetics products without actually visiting the store. The website
displays different kinds of products of different brands so that user
can easily get their expected cosmetic products.
OBJECTIVE
Provides the good user interface to ease of use and it also
provides the security to the database.
This system can view the details of any record.
Locate any cosmetic product information wanted by the user.
Reduced clerical work as most of the work done by computer.
Provide greater speed & reduced time consumptions.
SCOPE OF WORK
Manage online shopping easily.
Secure registration & profile management facilities for
customer.
Easy & Quick access to particular product & services.
This System is easy in handle & user friendly.
Time required for accessing any detail will be very less.
User can view details of the parts without going anywhere.
It is Convenient for users as this system provides accurate cost
& description of the system.
Tools/Software Used
1. Hardware Specification:-
1. Core 2 – Duo Processor(3.0GHZ)
2. 1 GB RAM
3. 320 GB HDD
4. LCD Monitor
2. Software Specification:-
1. Operating System – Windows 7
2. Back End – Oracle 9i or 10G
3. Front End- Microsoft Visual Basic 6.0
FRONT- END
Visual Basic is a third-generation event-driven programming
language from Microsoft for its Component Object Model (COM)
programming model first released in 1991 and declared legacy during
2008. Microsoft intended Visual Basic to be relatively easy to learn
and use. Visual Basic was derived from BASIC and enables the rapid
application development (RAD) of graphical user interface
(GUI) applications, access to databases using Data Access
Objects, Remote Data Objects, or ActiveX Data Objects, and creation
of ActiveX controls and objects.
A programmer can create an application using
the components provided by the Visual Basic program itself. Over
time the community of programmers developed third-party
components. Programs written in Visual Basic can also use
the Windows API, which requires external function declarations.
BACK-END
Oracle database (Oracle DB) is a relational database management
system (RDBMS) from the Oracle Corporation. Originally developed in
1977 by Lawrence Ellison and other developers, Oracle DB is one of
the most trusted and widely-used relational database engines.
The system is built around a relational database framework in which
data objects may be directly accessed by users (or an application front
end) through structured query language (SQL). Oracle is fully scalable
relational database architecture and is often used by global
enterprises, which manage and process data across wide and local
area networks. The Oracle database has its own network component
to allow communications across networks.
Diagrams
ER-diagram
Name
User name
Quantity
Price
LOGIN
ADMIN
PRODUCT
Password Stock
Brand
Description
ORDER
Employee USER Dealer
Employee ID
Customer Name
Name Address
Qualification Name Address
Brand Prize
Phone No
Phone No Bill Number Email
Quantity
Salary
Data Flow Diagram
3. ZERO LEVEL
Admin
Dealer Employee
Cosmetic
Management
Customer User Database
4. ADMIN
Admin
Login to
Database
System
User
Customer Employee Dealer
Product Salary Bill Product Product
Purchase Details Details Purchase Sale
Products Manage
Reports
Add Delete Update
Manage Manage Manage Manage Manage
Products Products Payment Stock Modules
Details Details Details Details
Modules
Modules
Admin User Product
Customer
Employee
Dealer
Screenshots
CoameSc Bhop Logn 3yetsiti
RECEIPT
bsMb
FT.
Future Enhancement
No project is ever complete in itself; there are always minor or
major changes in the project according to user requirements.
This project could be enhanced in the sense that it can overcome
its limitations in the future as sample scope for enhancement.
This system can generate various reports useful for the
management and as it is quite user friendly it saves time and
reduce the chances of error occurrences. The co-ordination of
various functions can be achieved and miss management does
not take place.
Latest technologies and software technologies can help to bring
in more enhancements which would help the management to
take quick decision. Proper security is maintained and data is
protected from an unauthorized user.
Conclusion
The system can generate various reports useful for the management
and as it is quite user friendly it saves time and reduce the chances of
error occurrences. The co-ordination of various functions can be
achieved and miss management does not take place.
This System guide lines the user in maintaining proper and
appropriate data generation of report is easy and fast which can help
the management to take quick decision. Proper security is maintained
and data is protected from and unauthorized user.
Thank
You!!!
