Project Title: COSMETIC PRODUCT

(By SEMESTER –VI of III Year [Link]. (CA & IT) 2020-21)
Submitted By:
Student Name Roll No
Jinal Ramani 3065
Vaidehi Thummar 3083

Group ID: - 36
Name of Shop: Beauty Palace
Date of Submission: 18 sep,2023
Submitted To:
K.S. School of Business Management
[Link].-Computer Application and Information Technology.
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 2 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 3 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 4 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 5 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 6 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 7 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

ACKNOWLEDGEMENT
We are using this opportunity to express the gratitude to everyone who support us
throughout the project. We thankful to aspiring guidance, invaluably constructive criticism and
friendly advice during the project work. We are sincerely grateful to them for sharing there
truthful and illuminating views on number of issues related to the project.
We would like to express our gratitude to our institute who provided us the inspiration
and facility by giving us a chance to make is feel comfortable is professional environments of
the office premises.
We acknowledgement the management staff of “K S School of Business Management” for
giving us permission to develop “Cosmetic Product System” for business and helping
understanding the current system which is valuable input for developing the system.

With Regards,
Jinal Ramani (3065).
Vaidehi Thummar (3083).

P a g e 8 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Index
[Link]
1.1 Organization Profile 09
1.2 System Details 09
1.2.1 Existing System 09
1.2.2 proposed System 10
1.3 Scope of System 11
1.4 Objectives 12
2. Proposed System Requirement Gathering
2.1 Stakeholder of System 13
2.2 Requirement Gathering Technique Used 13
2.3 Consolidated List of Requirements 19
2.4 Project Definition 19
3. System Management and Planning
3.1 Feasibility Study 20
3.1.1 Technical Study 20
3.1.2 Economical Study 20
3.1.3 Operational Study 21
3.2 Hard Ware – Soft Ware Requirement 21
3.3 System Planning 22
3.3.1 Work Breakdown Structure 22
3.3.2 Gantt Chart 23
3.4 Process Model 24
[Link] Analysis And Design
4.1 UML(Unified Modelling Language) 25
4.1.1 Use Case Diagram 25
4.1.2 Sequence Diagram 28
4.1.3 Activity Diagram 30
4.1.4 Class Diagram 33
4.2 System Flow Diagram 34
4.3 Data Dictionary 35
4.4 User Interface 39
4.5 System Navigation 49
5. Input /Output Design
[Link]
7. Summary
P a g e 9 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Bibliography

Following tools are tools that are used for software development documentation:
Software Engineering-
A practitioner approach 7th
Adition By Ragor S. Pressman
Following tools are used for the completion of the user-interface and UML diagrams.
➢ [Link]

Help from internet:-

➢ [Link]
➢ [Link]
➢ [Link]
➢ [Link]
➢ [Link]
➢ [Link]

P a g e 10 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

CHAPTER 1 : INTRODUCTION
1.1 ORGANIZATION PROFILE
Beauty Palace
Address : 11,Shanti Ni Ketan -1,Raspan Cross Road,Ahmedabad.
E-mail : beautypalace@[Link]
Contact-Number : 9998175808
Contact Person : Chirag Patel

1.2 SYSTEM DETAILS

1.2.1 EXISTING SYSTEM

➢ Currently they have non-it system.

➢ An existing e-commerce website system typically contains several components and
features to support the buying and selling of products online. These may include:

1. User Registration and Authentication:

The system allows users to create accounts, login, and manage their profiles,
enabling personalized experiences, order history tracking, and secure
transactions.

2. Product Catalog:
The system features a catalog displaying various products for sale. Each product
is typically listed with details such as images, descriptions, prices, and
specifications.

3. Shopping Cart:
Users can add chosen products to a virtual shopping cart, allowing them to review,
modify, and finalize their purchases before proceeding to checkout.

4. Payment Gateway Integration:

To facilitate online transactions, the system integrates with payment gateways to
securely process payments through various methods such as credit/debit cards,
digital wallets, or bank transfers.

5. Inventory Management:
The system includes a feature to manage and track available product quantities,
ensuring accurate stock management and preventing overselling.

6. Order Management:
Orders placed by customers are recorded and managed within the system. This
includes status updates, and communications related to order fulfillment.

P a g e 11 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

7. Customer Support:
The system usually provides a platform for customer support, enabling users to
contact the seller or customer service representatives for inquiries, returns, or
issue resolutions.

8. Content Management System (CMS):

The system may incorporate a CMS to manage website content, including product
updates, blog posts, promotions, and other informative pages.

9. Website Security:
To ensure secure transactions and protect user data, the system incorporates
security measures such as encryption technology, and regular vulnerability
assessments.

Challenges:
• Limited reached to local customers only.
• Insufficient documentation can hinder maintenance and make it
challenging for new developers to work on the system.
• Difficulty in inventory management and predication of stock
requirements.
• Inability to provide 24/7 shopping convenience to customers.
• The total cost of ownership for aging systems can be high, as they require
more maintenance and support.

1.2.2 PROPOSED SYSTEM:

➢ In a proposed e-commerce website system, several components and features can

be included to provide a comprehensive and user-friendly online shopping
experience. Some key components of a proposed e-commerce website system
may include:

1. User Registration and Authentication:

Allow users to create accounts, login, and manage their profiles, enabling
personalized experiences and secure transactions.

2. Product Listing and Catalog:

Display products for sale with detailed information, including product images,
descriptions, prices, variations, and specifications.

3. Product Search and Filtering:

Enable users to search for products using keywords, categories, filters, and sorting
options for a more targeted shopping experience.

4. Shopping Cart and Wishlist:

Allow users to add products to a shopping cart and save products to a wish list for
later purchase or comparison.

P a g e 12 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

5. Order Placement and Checkout:

Provide a seamless and user-friendly checkout process, including multiple payment
options, guest checkout, and order review before finalizing the purchase.

6. Payment Gateway Integration:

Integrate with secure payment gateways to process online payments, supporting
various methods such as credit/debit cards, digital wallets, or bank transfers.

7. Customer Support and Live Chat:

Provide a platform for customer support, including FAQs, contact forms, and live
chat options to address inquiries or issues promptly.

8. Content Management System (CMS):

Integrate a CMS to manage website content, including product updates, blog
posts, banners, and promotional content.

9. Website Security:
website security through the implementation of encryption technology, and regular
security updates to protect user data and transactions.

Advantages:
• Wider audience reach, including international customers.
• Users may have the ability to customize and tailor the system to their specific
needs and preferences.
• It could result in cost savings by optimizing resource usage, reducing errors,
and minimizing operational expenses.
• A robust system may have enhanced security features to protect data and
prevent unauthorized access.
• Real-time inventory management.

1.3 SCOPE OF THE SYSTEM

The cosmetic product website typically includes features like:

1. Product Listings:
The website showcases a wide range of cosmetic products, including makeup, skincare,
haircare, and fragrance, with detailed information about each product.

2. Detailed Product Descriptions:

Each product has comprehensive descriptions, including ingredients, usage instructions,
and benefits.

3. Product Images:
The website displays high-quality images of the products from different angles to give
users a clear view of what they're purchasing.

4. Customer Reviews:
Users can read and leave reviews for products, helping others make informed decisions
based on personal experiences.

P a g e 13 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

5. Secure Payment Processing:

The website integrates secure payment gateways to ensure safe and convenient
transactions using credit cards, digital wallets, or other payment methods.

6. Order Management:
Users can view order history, and receive updates on the status of their purchases.

7. Beauty Tips and Guides:

cosmetic product websites also provide beauty tips, tutorials, and guides to help users
make the most of their purchases.

1.4 OBJECTIVES
cosmetic product website includes objectives like:

➢ Our project is a Cosmetic Products System.

➢ Aims to develop the software that covers all the aspect of products, increase the speed of retrieval
and produces more accurate result and also provide more security and to make the system more
efficient and user friendly.
➢ The proposed system is very powerful and it is highly user friendly. It also prevents the
unauthorized access to data.
➢ The system provides accurate results and also, the well formatted products. It includes arrange the
products in ordering.
➢ This makes access and searching records become very efficient.
➢ The website ensures secure payment processing, protecting customer information and providing a
safe environment for online transactions.
➢ website strives to establish credibility and trust with customers through authentic
customer reviews, testimonials, and ratings.
➢ The website objective should be to provide a platform for customer service and after-
sales support.

P a g e 14 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

CHAPTER – 2 PROPOSED SYSTEM REQUIREMENT

GATHETING

2.1 Stack holder of the system

1. Admin :
An admin is responsible for maintaining the system as well as to keep the system running
smoothly.
Admin also manage the functionalities of the system like managing the users, products,
and orders.

2. Customers:
These are the individuals who purchase and use the cosmetic products. Their feedback
and preferences play a crucial role in shaping the development and marketing of the
products.

3. Visitor:
Visitor is also the user of the system that visits the system without getting registered into
the system. Visitor can view service category, details and feedback

2.2 Requirement gathering technique used

Description : Techniques used to obtain the specifics of what The software should
achieve.
Example:

➢ Interviews:
Personal interviews with the Cosmetic Product management team and select loyal
customers to understand their needs and preferences.

➢ Surveys and Questionnaires:

Sent to a broader base of potential online shoppers to gauge their expectations.

➢ Observation:
Spending time in the physical store to understand customer buying behaviors and
preferences.

➢ Prototyping:
Building a basic version of the platform to get feedback forms, and inventory lists.
P a g e 15 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Document Analysis:
Reviewing existing sales data, customer feedback forms, and inventory lists.

We used Interview technique for gathering the requirements.

Interview Q/A of Stakeholders:

[Link] :

Q. 1. Do you understand the role as an admin?

Ans : Yes

Q. 2. Have you ever managed some system like this before?

Ans : No, it's my first experience.

Q. 3. will you able to make updates by yourself of which type?

Ans : Yes, accept or reject order, update services, update, change the price of products etc.

Q. 4 .will you help to the customer or maid when they stuck with problem?

Ans : Yes

Q. 5. do you understand the functionality of the website?

Ans: Yes

Q. 6. will you give the answer of the customer via email?

Ans: Yes

Q. 7. will you able to manage service category, order department?

Ans : Yes

Q. 8. will you manage feedback segment or not?

P a g e 16 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Ans : Yes

Q. [Link] you provide of them order information to the customer by email?

Ans : Yes

Q. 10. will you handle any technical error by yourself?

Ans : Yes but not internal problem

Q. 11. will you generate the report periodically?

Ans : Yes

Q . 12. Will you provide the customer basic information to the worker? If yes then in which way?

Ans : Yes, the information about address of home, products name, phone number, price etc.

Q. 13. will you able to manage order department and payment segment?

Ans : Yes

Q. 14, will you collect analytics?

Ans : Yes

Q. [Link] you manage this side?

Ans : I am comfortably manage this side. I provide the data of order to the customer I able to
update, delete, save the product information. I also handle the database of system. Store the data
of customer, and order.

[Link] :

Q. 1. Will you prefer different types of products according to the

needs?

Ans : Yes

P a g e 17 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Q. 2. Will you cherish in giving fruitful feedback?

Ans : Yes

Q. 3. Will you prefer in choosing product of your choice?

Ans : Yes

Q. 4. Will you prefer manual process for contacting?

Ans : Yes, through calling and messaging both.

Q. 5. On what basis services will be provided?

Ans : It will be provided on monthly, weekly and biweekly basis.

Q. 6. Does orders services are their ?

Ans : Yes, customer can order as per their needs.

Q.7. Does cancellation or reschedule of orders are available?

Ans : Yes

Q. 8. How about payment mode?

Ans :Clients can pay through online and offline mode both.

Q. [Link] we find out the product as per our need?

Ans : Yes

Q .[Link] customer search for different types of products?

Ans : Yes

P a g e 18 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Q . [Link] this website is worthwhile useful to the customers?

Ans :Yes of course it is useful infect it is much beneficial to the customers in today's hectic life.

Q .[Link] customer can make choice in choosing product?

Ans : Yes

Q. 13. What is new and different in this website?

Ans: Our Cosmetic Product website will provide you offers and discounts.

Q. [Link] payment verification system is available?

Ans :Yes

Q. [Link] this website is user-friendly?

Ans : Yes

Q. [Link] customers can give feedback and check previous feedback and reviews?

Ans: Yes

[Link] :

Q. 1. Is the website user-friendly and easy to navigate?

Ans : Yes.

Q. 2. Does the website offer a wide variety of cosmetic products?

Ans :Yes.

Q. 3. Are the product descriptions detailed and informative?

Ans : Yes.

Q. 4. Can visitors easily find information about shipping and returns?

P a g e 19 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Ans : Yes.

Q. 5. Is there a secure payment system in place?

Ans : Yes.

Q. 6. Does the website provide customer reviews and ratings for products?

Ans : Yes.

Q. 7. Are there any discounts or promotions available for visitors?

Ans : Yes.

Q. 8. Is there a responsive customer support team available to assist visitors?

Ans : Yes.

Q. 9. Does the website offer a seamless checkout process?

Ans : Yes.

Q. 10. Are there clear and transparent policies regarding privacy and data protection?

Ans : Yes.

Q. 11. Is the website visually appealing and attractive to visitors?

Ans : Yes.

Q. 12. Can visitors easily search for specific cosmetic products on the website?

Ans : Yes.

Q. [Link] there a feature that allows visitors to save their favorite products for future reference?

Ans : Yes.

P a g e 20 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

2.3 Consolidated list of requirements:

1 .User Interface:
Clean design with easy navigation, product search, and filter Options.

2 .Product Listing:
Detailed product information, high-quality images, user reviews, and comparison
features.

3 .Shopping Cart & Checkout:

Secure payment gateway integration, coupon code. application, and guest checkout
option

4 .User Account Management:

Profile creation, order history, wish lists, and password Reset.

5 .Customer Support:
Live chat, FAQ section.

6 .Analytics:
Tools to monitor site traffic, user behavior, sales data, and marketing campaign
effectiveness.

2.4 Project definition

Description:
A clear, concise statement detailing what the project aims to achieve.

Example for Cosmetic Product:

“The Beauty Palace e-commerce platform project aims to develop a user-centric
online store for electronics. The platform seeks to offer an extensive range of Cosmetic
Products, ensuring secure transactions, real-time inventory management, and robust
customer support. Through this platform, Beauty Palace aspires to expand its customer
base, provide 24/7 shopping convenience, and elevate its market position in the cosmetic
products retail sector.”

P a g e 21 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

CHAPTER – 3 SYSTEM MANAGEMENT AND PLANNING

3.1 Feasibility Study

3.1.1 Technical Study
• Cosmetic Product system is a web based application. The main technologies and tools
which are going to be used in Cosmetic Product are as follows:-
o HTML
o CSS
o JQUERY
o PHP
o MYSQL
o DIAGRAM DRAWING TOOLS :- [Link]
• Each of these technologies are freely available and the skills required are manageable.
Time limitation of the product development and the ease of implementing using these
technologies are synchronized.
• The resources which are required (both hardware and software) and technologies are
available at no cost.
• By considering all these points we can say that our system is technically feasible as
minimal or no cost is required in its development and maintaining it is also quite easy.

3.1.2 Economical Study

• The System will follow the freeware standards. No cost will be charged from the potential
customers.
• In the development of the system, technologies which are going to be used are generally
open source and there is no cost incurred in the development process as well.
• Relatively there is no cost associated in managing the system once it is developed.
• Especially the extra effort that is associated with paper making and marking will be
significantly reduced while the effort to create descriptive statistical reports will be
eliminated, since report generation is fully automated.
• Future Updates an also be integrated into the system at no cost.
• No special hardware integration is required by the system.
• So it is very much clear that our system is economically feasible.

P a g e 22 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

3.1.3 Operational Study

• The Cosmetic Product system is going to be developed by keeping in mind the Beauty
Palace and there owners. The entire business environment will be considered in the
development of the system.
• The planning includes owner and other stakeholders for the development of the system.
• So the system will be user friendly for all its stakeholders.
• Also support will be provided by our side if the owner/admin gets stucked into some
problem.
• Our system will be easy to use and much secured.

3.2 Hardware/Software Requirement

• Client Side Requirements:-

o Hardware Requirements :-

Processor Minimum Core i5 or Higher

RAM Minimum 2 GB or Higher
Hard Disk Minimum 200 MB or Higher

o Software Requirements :-
OS Minimum Window 8 or Higher
Browser Mozilla v65.02 o Chrome v73.0.3683.86

• Server Side Requirements:-

o Hardware Requirements:-

Processor Minimum Core i5 or Higher

RAM Minimum 2 GB or Higher
Hard Disk Minimum 500 MB or Higher

o Software Requirements :-

OS Minimum Windows 7 or Higher

Server Apache Tomcat
BROWSER Mozilla v65.0.2 or Chrome v73.0.368

P a g e 23 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

3.3 System Planning

3.3.1 Work Breakdown Structure

P a g e 24 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

3.3.2 Gantt chart

Months Aug Sep Oct Nov Dec Jan Feb March Apri
Chapters l
[Link] of project
Definition Submission
Approval of Submission
[Link] Gathering

Defining stakeholders

Interview
Scope of System
[Link]
Analyzing Requirements
Feasibility study
Technical
Economical
Operational
[Link] design
UML diagrams
User Interface
System navigation
[Link] (Coding)
[Link] and implementation

P a g e 25 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

3.4 Process Model

Increment Model

➢ Different phases of the software development are included in an increment in a

linear fashion.
➢ The first increment will be a product with many supplementary features. User
uses it and the system will be evaluated with more modifications to better meet
the needs.
➢ The main advantage of using this process model is that the short-term goals can
be set and thus work can be done more effectively. Also, this helps the client to
keep a good track of the development process. Due to this reason, we choose this
process model.

P a g e 26 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

CHAPTER-4: SYSTEM ANALYSIS AND DESIGN

4.1 UML (Unified Modeling Language)
4.1.1 Use Case Diagrams
o Admin

P a g e 27 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

o Customer

P a g e 28 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

o Visiter

P a g e 29 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.1.2 Sequence Diagram

o Admin

P a g e 30 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

o Customer

P a g e 31 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.1.3 Activity Diagram

o Admin

P a g e 32 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

o Customer

P a g e 33 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

o Visitor

P a g e 34 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.1.4 Class Diagram

P a g e 35 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.2 System Flow Diagram

P a g e 36 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.3 Data Dictionary

• Total Tables
1. User Tables
2. Product Table
3. Category Table
4. Order Table
5. Cart Table
6. Wishlist Table
7. Feedback Table
8. Comment Table
9. Featured Products Table
10. Payment Table

Table Number : 1
Table Name : User Table
Primary Key : user_id
Description : Stores Details of User

[Link] Column Name Data Type Size Constraints Description

1 user_id Int 5 Primary Key System User Id
2 user_name Varchar 50 Not Null Name of User
3 user_email Varchar 150 Unique User E-Mail
4 user_address Varchar 200 Not Null Address of user
5 user_password Varchar 200 Not Null User Password
6 activation_code varchar 200 Not Null User unique number
7 user_status int 1 Not Null User is deleted or not

Table Number: 2
Table Name : Product Table
Primary Key : Product_id
Description: Stores Details of Product
[Link]. Column Name Data Type Size Constraints Description
1 product_id Integer 10 Pk Unique identifier for each
2 category_id Integer 10 Fk Identifier for the category
3 category_name varchar 200 Not Null Name of category
4 Product_name char 30 Not Null Name of Product
5 Price Integer 5 Not Null Price of Product
6 description Text - Not Null Description of Product
7 Product_Image Varchar 100 Not Null Image of Product

P a g e 37 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Table Number : 3
Table Name : Category Table
Primary Key : Category_id
Description : Stores Details of Category

[Link] Column Name Data Type Size Constraints Description

1 category_id Integer 10 Primary Key Store Unique Id
Category
2 category_name VarChar 30 Not Null Name of category

Table Number: 4
Table Name: Order Table
Primary Key: O_id
Description: Stores Details of order

[Link] Column Name Data Type Size Constraints Description

1 o_id Int 10 Primary Key Store Unique Id of order
2 user_id Int 10 Foreign key Store user id
3 order_date Date 40 Not Null Store order date
4 first_name Varchar 20 Not Null Store first name of user
5 last_name Varchar 20 Not Null Store last name of user
6 Address Varchar 150 Not Null Store address of user
7 city_name varchar 100 Not Null Store city Name
8 Zip_code varchar 200 Not null Store zip code
9 Email Varchar 50 Not Null Store email of user
10 phone_no Varchar 10 Not Null Store phone no of user
11 order_status Varchar 90 Not Null Store order status
12 cancel_order Boolean - Not Null Store cancel order or not
13 payment_status Varchar 20 Not Null Store payment status of
user
14 payment_mode Varchar 30 Not Null Store payment mode of
user
15 total_amount Int 40 Not Null Store Order total amout

P a g e 38 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Table Number: 5
Table Name: Cart Table
Primary Key: cart_id
Description: Stores Details of user cart

[Link] Column Name Data Type Size Constraints Description

1 cart_id Int 10 Primary key Store cart id
2 user_id Int 10 Not null Store User id
3 product_id Int 10 Not null Store Product id
4 Product_name varchar 200 Not null Store product name
5 Product_images varchar 255 Not null Store product images
6 description varchar 255 Not null Product description
7 Product_price Int 11 Not null Product price store
8 cart_quantity Int 10 Not Null Store Cart Quantity

Table Number : 6
Table Name : Wishlist Table
Primary Key : Wishist_id
Description : Stores details of Customer Wish list

[Link] Column Name Data Type Size Constraints Description

1 wishlist_id Int 10 Primary Key Store Wishlist id
2 User_id Int 10 Foreign Key Store User id
3 product_id Int 10 Foreign Key Store product id
4 Product_name varchar 255 Not null Store product name
5 Product_images varchar 255 Not null Store product images
6 Product_price Int 11 Not null Product price store

Table Number : 7
Table Name : Feedback Table
Primary Key : feedback_id
Description : Stores Details of Feedback Given by the Custmors

P a g e 39 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

[Link]. Column Name Data Type Size Constraints Description

1 User_id Int 10 Foreign Key Store User id
2 product_id Int 10 Not null Store product id
3 feedback_id Int - Primary Key Feedback id
4 user_name Varchar 50 Not Null Name of User
5 user_email Varchar 150 Unique User E-Mail
6 value varchar 150 Not null User response
7 feedback Varchar 250 Not Null Actual Feedback
8 feedback_date Date - Not Null Date on which feedback was
given

Table Number : 8
Table Name : Comment Table
Primary Key :id
Description : Stores Details of Comment Given by the Custmors

[Link]. Column Name Data Type Size Constraints Description

1 id int 11 Primary Key Store User id
2 time int 11 Not Null Comment time store
3 name varchar 255 Not Null User name store
4 email varchar 255 Not Null User email store
5 comment varchar 255 Not Null Actual comment

Table Number : 9
Table Name : Featured Products Table
Primary Key : product_id
Description : Stores Details of Product

[Link]. Column Name Data Type Size Constraints Description

1 product_id int 11 Primary Key Store product id
2 category_id int 11 Not Null Store category id
3 category_name varchar 255 Not Null Store category name
4 product_name varchar 255 Not Null Store product name
5 price varchar 255 Not Null Product price store
6 description varchar 255 Not null Product description store
7 Product_image varchar 255 Not null Product images store
8 time varchar 50 Not null Product available time show

P a g e 40 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Table Number : 10
Table Name : Payment Table
Primary Key : id
Description : Stores Details of Payment

[Link]. Column Name Data Type Size Constraints Description

1 Id int 11 Primary Key Store product id
2 Order_id int 11 Not Null Store order id
3 Payment_id varchar 255 Not Null Store payment id
4 amount float None Not Null Store amount
5 Add_date datetime none Not Null Date and time store

P a g e 41 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.4 User Interface

➢ Visitor Home Page :

P a g e 42 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 43 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 44 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 45 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ About Us Page :

P a g e 46 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 47 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Contact Us page:

P a g e 48 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Makeup Product Page :-

➢ Skin Product page :-

P a g e 49 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Skin Page Details Page:-

P a g e 50 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 51 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

4.5 System Navigation

P a g e 52 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

CHATER 5 : INPUT/OUTPUT DESIGN

➢ User Registration Page:-

Registration OTP

P a g e 53 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Will get OTP through mail

➢ Login page of User :-

P a g e 54 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Reset Password:

➢ Home page of User:-

P a g e 55 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Edit Profile Page :-

➢ User Add Wishlist Page:-

P a g e 56 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Add Cart Page:-

➢ User’s Feedback Page:-

P a g e 57 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Place Order page:-

➢ User Online payment Mode:-

P a g e 58 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 59 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 60 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 61 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Order Details Page:--

P a g e 62 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Admin Interface:-

➢ Admin Dashboard:

➢ Admin Category Page:-

P a g e 63 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Admin Product Page:-

P a g e 64 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Product Details Page:-

P a g e 65 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Admin Order Page:-

➢ Admin Feedback Page:-

P a g e 66 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 67 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

CHAPTER 6: TESTING
➢ Registration Validation:-
o All Fields are Required

➢ Email Validation
o Correct Formation of Email Required

P a g e 68 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Password Field validation:-

➢ OTP Validation:-
o Wrong OTP will not be Accepted by OTP Field

P a g e 69 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Login Validation:-

P a g e 70 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Reset Password Validation:-

o Field Will Not Accept Any User Email Which Does Not Exist Into The System

P a g e 71 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ User Profile Validation:-

o Fields Cannot be Empty

P a g e 72 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

➢ Contact Us Page Validation:-

P a g e 73 | 75
 K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

Chapter 7: Summary

7.1 Assumption

➢ The User Should have the basic knowledge of how the online system works.
➢ Proper Internet setup is required to run the system smoothy.
➢ User should be having a valid Gmail id.

7.2 Limitations

➢ The system is not configured for multi-users at this time. The concept of transaction can
be used to achieve this.
➢ The website is not accessible to everyone. It can be deployed on a web server so that
everybody who is connected to the internet can use it.
➢ Less security.

7.3 Future Scope

➢ New Revenue related Services other than the existing services will be added to the system
into the future.
➢ The system could be expanded to include additional features such as social networking
capabilities to encourage user engagement and collaboration.

7.4 Conclusion

➢ The online shopping is designed to provide a web based application that would make
searching, viewing and selection of a product easier.
➢ The user can the complete specification of each product. They can also view the product
Reviews and also write their own reviews.

P a g e 74 | 75
K S SCHOOL OF BUSNESS MANAGEMENT AND INFORMATION TECHNOLOG

P a g e 75 | 75